Access denied for user 'xenis'@'localhost'

3 posts / 0 new
Last post
#1 Tue, 03/20/2012 - 00:44
virtualmin108

Access denied for user 'xenis'@'localhost'

Howdy... on one of our we are unable to connect to the MySql Database for a upgrade of a script, error:
Database connection failed : DBI connect failed : Access denied for user 'xenis'@'localhost' (using password: YES) 1360
We have set the password for xenis user again, within the MySql Server Module.
The thing I can not understand, why all the databases for user xenis run fine, but we can not upgrade a script, like Joomla, for that user's database.
To my understanding, if the password of xenis is not correct, then we should get that error on the website. but this is not the case.
Instead, when we want to upgrade Joomla, then the access denied error appears.

regards
Tobias

Wed, 05/09/2012 - 03:32
LonDoh

I also have this issue. And I posted about a similar issue a few months ago here: https://www.virtualmin.com/node/20535 I thought then it was only a migrated sites issue, but it isnt.

Script installs on new sites are also showing exactly the same error virtualmin108 describes

I've reset vm password and mysql password. There is no problem with admin_user access for db. I can login and out of mysql via cli or a simple php script no problem. admin_user has mysql access from shell. ie: mysql -u admin_user -p works with existing vm admin_user password I tried granting privileges on any host (grant all ... admin_user@% ...)

But no success

I really need a solution to this.

Any ideas please?

Wed, 05/09/2012 - 04:23
Locutus

It might have to do with the password storage method. If I recall correctly, there is an "old" and a "new" method to store MySQL user passwords, and the client side (web script in this case) needs to be using the proper client library to make use of the one or the other password method.

This might help to find out if this is actually the case: http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Topic locked