Hi John, You saved my day. Haven't laughed like this for long time ;-)
>How do I set no password for root? .... > It worked!!. Thanks. Now how do I protect it so that not anyone who > points to it cannot get to it without putting in a username/password? Thanks a lot really. Best regards Nils Valentin Tokyo/Japan 2003年 6月 14日 土曜日 14:53、John Chang さんは書きました: > It worked!!. Thanks. Now how do I protect it so that not anyone who > points to it cannot get to it without putting in a username/password? > > At 12:24 AM 6/14/2003 -0500, John Nichel wrote: > >John Chang wrote: > >>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/ > > > >If you changed it to have no root password, you need to edit the > >config.inc.php file in your phpmyadmin directory. Get rid of the password > >there. > > > >With that being said, why would you want an empty root password???? -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]