For Mysql, 127.0.0.1 is not the same as localhost.
Localhost refers to the socket file on the operating system, and is faster than 127.0.0.1.
Use 'root'@'127.0.0.1' in your grant statements.


Ola Ogunneye wrote:

Please somebody help me.

I have installed MySql 4.0.13 and it works up until I try to apply security settings to the root user at localhost.

I see the mysql database and I check the privileges and there is no password for the roo user. But when I assign a password to make it secure, I can run phpmyadmin, but I cannot get into the database anymore. All I get is:

MySql Said:
Access Denied for user: [EMAIL PROTECTED] (Using password: NO)

This situation has happened 3 times and I had to reinstall MySql and start from scratch.

Can someone please point me in the right direction, this is my first try and it has been quite a serious learning experience.

Thank you in advance.






-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to