Tim wrote regarding '[SLE] mysql permissions in 9.2' on Mon, Jan 24 at 08:20:
There seems to be some fundamental change in the permissions in mysql as shipped with 9.2 compared with 9.0 which has completely floored me.
A bugzilla set up that works fine talking to a mysql db on 9.0 comes up with the following error when the db is on a 9.2 system:-
DBI connect(';localhost;3306','test2',...) failed: Access denied for user: 'test2@localhost' (Using password: YES) at ./checksetup.pl line 1460
As far as I can tell permissions on both the 9.0 and 9.2 db's are identical, *and* I have no trouble at all connecting to the 9.2 db using Rekall and the same username/login as bugzilla is trying to use.
And for the moment the firewall is off, (but then Rekall wouldn't work anyway).
Anyone any idea at all where to carry on looking for this one, as I've run out of ideas!!
Look at the startup log for mysql (frequently /var/lib/mysql/*.log), and see if it's complaining about anything. Also, make sure that you can actually connect with the mysql client mysql -h localhost -u test2 -p dbname (It'll prompt you for a password). I had that problem when connecting to a new MySQL while using an old MySQL client, as the format of the PASSWD() function output changed. But then, that was when I switched to 4.1, IIRC. --Danny, always checking the logs first