[BlueOnyx:04272] Re: MySQL/phpmyadmin error

[Gerald Waugh]

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