[BlueOnyx:04270] Re: MySQL/phpmyadmin error

[Don Teague]

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


On Sat, Apr 17, 2010 at 5:04 PM, Gerald Waugh <gwaugh at raqware.com> wrote:
>
> On Sat, 2010-04-17 at 16:31 -0500, Don Teague wrote:
>> Anyone else have ideas? (Or tell me where the file is, that would be a
>> start.....)
>
> Looks like you get into mysql
> When there.....
>
> mysql> update user set Password=PASSWORD('newpwd') where User='root';
> mysql> quit
>
> Then go into the network services msyql
> and set the same password
>
> Gerald
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx
>
>