ive got a problem with connecting to mysql and have the following error:
Warning: mysql_connect(): Access denied for user: 'me@127.0.0.1' (Using password: YES) in C:\Inetpub\wwwroot\disso\add.php on line 18
Could not connect !
i figured that its probably because i don’t have privileges in the ‘mysql’ admin table.
I have already created tables in mysql and they work fine. I just cant connect to the database.
i have used the grant command too, 'GRANT ALL PRIVILEGES ON . to me@'localhost' IDENTIFIED BY 'password' but it dosent work!
i also tried to use insert into command to set up the host, user and db table but it still dosent work. i selected host, user, and password from the user table in the database 'mysql' and it shows the following;
host - user - password
localhost - root
%
localhost - root
%
localhost - Me - 70de51425df9787
So i guess that shows that i do have privileges? So why is it not working?? i really do not understand what is wrong?!???
PLZ HELP!!! MOST APPRECIATED!!!