Following on from the issue created in the wrong location (now closed) - https://git.ispconfig.org/ispconfig/ispconfig3/issues/5294 As requested - "Check that you have the correct MySQL root password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf" The MySQL password in here is correct, to be able to login to the local MySQL server on which the issue is apparent, any further suggestions?
Which MySQL or MariaDB version do you have installed? You can check that with the command: mysql --version
That's ok. And the mysql user mentioned in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf is the user 'root' and not a different user?
Yes, that's right, if it helps I believe this was working OK up until recently, we have recently moved from "stable" to "git-stable" to try and resolve another issue; https://git.ispconfig.org/ispconfig/ispconfig3/issues/5281.
And just to mention it, you created database too, right? MySQL users get created when you add the database and not when you create a mysql user in ispconfig. The reason for that is that mysql users are not bound to a specific server, so that ispconfig does not know on which server the user needs to be added unless you add a database which actually uses this user. And a user without being able to access anything makes no sense anyway.
Yes there is a database created for this user, and associated within ISPConfig, marked as active and seems to be setup correctly to me.
Really strange, I tested it here again with current git-stable, just to be sure, and it works fine. I'm using Ubuntu 18.04 and the same MariaDB version that you are using. Please try to create a new database user and then a new database, wait a minute and check in phpmyadmin if the user was created. Just to ensure that it is reproducible on your system. And please check in phpmyadmin if the root user in the mysql.user table has all privileges incl. the privileges to create users and the grant privilege etc. and in case there is more than one root user, check if all root users have all privileges.
Yes, so the user seems to be created correctly when trying with a new test site, let me do some more digging about how this user was initially created from my colleague and get back to you.
