PHP/MySQL help needed please

 
Post new topic   Reply to topic    Aprelium Forum Index -> PHP
View previous topic :: View next topic  
Author Message
pauldiston
-


Joined: 07 Apr 2003
Posts: 2

PostPosted: Sun Nov 30, 2003 3:08 pm    Post subject: PHP/MySQL help needed please Reply with quote

I am sure you have seen this question being asked a million times but I don;t know what to do.

This is the PHP piece of code I am using:-
$result = mysql_connect("127.0.0.1:3306", "root", "password");

This is the error I am getting when I run the PHP file :-
Warning: mysql_connect(): Access denied for user: 'root@localhost' (Using password: YES) in C:\PROGRAM FILES\ABYSS WEB SERVER\htdocs\index.php on line 13

This is a copy of my.ini (note the username and password) :-

#This File was made using the WinMySQLAdmin 1.4 Tool
#28/11/03 14:25:53

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions


[mysqld]
basedir=C:/MYSQL
#bind-address=169.254.217.29
datadir=C:/MYSQL/data
#language=C:/MYSQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M

[WinMySQLadmin]
Server=C:/MYSQL/bin/mysqld-opt.exe
user=root
password=password

How do I change access permission as this seems to be the problem. Any help on this will be great.
Thanks
Paul
Back to top View user's profile Send private message
Lengte
-


Joined: 30 Nov 2003
Posts: 3

PostPosted: Sun Nov 30, 2003 4:55 pm    Post subject: Reply with quote

Are you sure you have set the password to 'password' for the root user? At default there is no password so you could try:
$result = mysql_connect("localhost", "root", "");
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> PHP All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group