View previous topic :: View next topic |
Author |
Message |
pauldiston -
Joined: 07 Apr 2003 Posts: 2
|
Posted: Sun Nov 30, 2003 3:08 pm Post subject: PHP/MySQL help needed please |
|
|
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 |
|
 |
Lengte -
Joined: 30 Nov 2003 Posts: 3
|
Posted: Sun Nov 30, 2003 4:55 pm Post subject: |
|
|
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 |
|
 |
|