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]