Try 'mysqladmin flush-privileges'
--cut--
flush-privileges
Reload grant tables (same as reload)
--end cut--
then login (been there... Stuck there too...)
chris
-----Original Message-----
From: John Chang [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 14, 2003 12:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Set no root password
I changes the password but it still doesn't work. This is the error I
get
when I try to connect to MySQL using phpmyadmin using a browser. What
do
I need to change? Thanks.
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote:
>At 0:10 -0400 6/14/03, John Chang wrote:
>>How do I set no password for root?
>
>mysql -u root -p
>Enter password: (your current root password here)
>mysql> SET PASSWORD = '';
>mysql> quit
>
>
>--
>Paul DuBois, Senior Technical Writer
>Madison, Wisconsin, USA
>MySQL AB, www.mysql.com
>
>Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
