[BlueOnyx:03362] Re: mysql server

[Darrell D. Mobley]

> -----Original Message-----
> From: blueonyx-bounces at blueonyx.it [mailto:blueonyx-bounces at blueonyx.it]
> On Behalf Of Gerald Waugh
> Sent: Tuesday, January 19, 2010 3:00 PM
> To: 'BlueOnyx General Mailing List'
> Subject: [BlueOnyx:03361] mysql server
> 
> mysql server is messed up.
> I can login to mysql as root and see everything.
> But can't do a mysqldump
> I get
> mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to
> database 'baiidnet' when using LOCK TABLES
> 
> baiidnet is the first database listed in "show databases"

Maybe you need to set the MySQL root password the same as your BX settings?

/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("thenewpassword") where User='root';
flush privileges;
quit
/etc/init.d/mysqld stop
/etc/init.d/mysqld start