MySQL user not created

Hello,

I have an OVH Kimsufi server with ISPConfig Version: 3.0.5.4p8 installed on it.
Debian GNU/Linux 7.9 / PHP 5.4.45-0+deb7u2 (cli) / MySQL Ver 14.14 Distrib 5.5.46, for debian-linux-gnu
Since a little while (maybe last update) I can't handle my database user form Ispconfig.
The databases are created but the users are not.

Here is the process that I do:

Users :
Sites > Database Users > Add new User
Client : xxxxx
Database user : myuser
Database password : mypwd
> Save

Databases
Sites > Databases > Add new database
Serveur : nsXXXX
Site : yyyyyyyy.fr
Type : MySQL
Database name : mydb
Username : myuser
> Save

At this point I connect to my MySQL instance with my "root" user
mysql -u root -pzzzzzzzzzzz

SHOW DATABASES; show me my "mydb" database
However USE mysql; SELECT user,host FROM user; is not showing me my "myuser" user...

If I take a look into logs in /var/log/ispconfig/ispconfig.log I can see creation lines
20.11.2015-13:29 - DEBUG - Calling function 'db_user_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_insert'.
20.11.2015-13:29 - DEBUG - Processed datalog_id 607
20.11.2015-13:29 - DEBUG - Calling function 'db_user_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_update'.
20.11.2015-13:29 - DEBUG - Processed datalog_id 608
20.11.2015-13:29 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
20.11.2015-13:29 - DEBUG - Created MySQL database: mydb
20.11.2015-13:29 - DEBUG - GRANT for user myuser at host localhost
20.11.2015-13:29 - DEBUG - GRANT ALL ON mydb.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD '*XXXXX'; success? no
20.11.2015-13:29 - DEBUG - Processed datalog_id 609
20.11.2015-13:29 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
20.11.2015-13:30 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock

If I try to create user from MySQL instance that work well
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'xxxx'; => OK

When I try to grant privileges I have an error
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'localhost';
=> ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mydb'
If I try to grant privileges to my "root" user error again
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'zzzz' WITH GRANT OPTION;
=> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Here is the rigths for my user "root" SHOW GRANTS FOR 'root'@'localhost';
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '***********' |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |

Sorry for the long message but I tried to be the most precise.
That's where I'm stuck my expertise ends here!

Hope that I can find a solution here.

Thanks !

 

Hello Till,
yes I forgot to say that my user / password are goods in /usr/local/ispconfig/server/lib/mysql_clientdb.conf.
How can I check that ? This is not with the command SHOW GRANTS FOR 'root'@'localhost'; in my first post ?
Thank you.

 

Well... Nice community no response in two months.
Thanks for you help !
Good continuation.

 

Had the same problem. ISPConfig created the database but not the database user. Checked the mysql log and there was a mysql_upgrade command necessary to fix the issue.