[BlueOnyx:03366] Re: mysql server

[Michael Stauber]

Hi Gerald,

> 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"

If the password for MySQL-user "root" is correct (sounds like it), then please 
check in what format the MySQL tables of the database 'baiidnet' are. Is it 
"MyISAM" or "InnoDB"? If it's "InnoDB" the problem could be a corrupted ibdata 
file. If that's the case things get messy. But before getting worried, check 
with phpMyAdmin if the database and the tables within need any repairs. 

Or it could be that someone accidentially removed some "stock" permissions 
from MySQL user "root". Don't laugh, I even had cases where user "root" was 
missing entirely and no remaining user had sufficient privileges to do 
anything noteworthy.

So if you have phpMyAdmin, login there, check under "Privileges" if user 
"root at localhost" has "all privileges" under "Global Privileges". If he hasn't, 
you can fix it with this guide:

http://www.solarspeed.net/otrs/public.pl?Action=PublicFAQ&CategoryID=10&ItemID=26

-- 
With best regards

Michael Stauber