[BlueOnyx:04273] Re: MySQL/phpmyadmin error

[Don Teague]

Can someone explain to me why I'm resetting the ROOT password, when I
can connect via ROOT (via the command line.)

The root user/pass works ... just doesn't show in the GUI.


On Sat, Apr 17, 2010 at 6:01 PM, Gerald Waugh <gwaugh at raqware.com> wrote:
>
> On Sat, 2010-04-17 at 17:35 -0500, Don Teague wrote:
>> Failed.
>>
>> [root at bx2 ~]# mysql -u root -p
>> Enter password:
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 746
>> Server version: 5.0.77 Source distribution
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>> mysql> update user set Password=PASSWORD('newpassword') where User='root';
>> ERROR 1046 (3D000): No database selected
>> mysql> quit
>>
>
> # /etc/init.d/mysqld stop
> # /usr/bin/mysqld_safe  --datadir=/var/lib/mysql --skip-grant-tables &
> # mysql -u root mysql
> mysql> update user set Password=PASSWORD('newpwd') where User='root';
> mysql> quit
> # /etc/init.d/mysqld stop
> # /etc/init.d/mysqld start
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx
>
>