I have the newest version of Ispconfig - 3.1.1p1. I created client, database user, database and finally website. Unfortunatelly only database I can see after login as root to phpmyadmin. I can't login as created database user. I have errors: #1045 - Access denied for user 'serpepsAdm1'@'localhost' (using password: YES) mysqli_real_connect(): (HY000/1045): Access denied for user 'serpepsAdm1'@'localhost' (using password: YES) Database serpeps_base1 is normally created via ISP panel. I logged in as root and checked users accounts - there is root, ispconfig and roundcube users but not serpepsAdm1. What should I check resolve this issue? By the way - few days after ISPconfig installation I upgraded mysql from 5.5.53 version to 5.7.16 - MySQL Community Server (GPL), and moreover I see that mysql client under www server (all in phpmyadmin) is in strange version -> libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $.
Use the ispconfig debug mode to create a new mysql user and database to see if you get any additional errors in the log or hint's why it fails.
Debugging is at the bottom of https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ as for reconfiguring mysql, I know slave servers can reconfigure permissions on the master (download the ispconfig source, untar it and run update.php (from install/ directory), and answer yes to that question), but I am not positive if that is done on a single-server installation. it shouldn't hurt to try.
Ok, I will do this. Btw Is it possible to reinstall mysql and is it possible that Ispconfig will see properly reinstalled mysql? EDIT This is what this command /usr/local/ispconfig/server/server.sh shows: 02.12.2016-06:33 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. 02.12.2016-06:33 - DEBUG - Found 1 changes, starting update process. 02.12.2016-06:33 - DEBUG - Calling function 'db_user_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_insert'. 02.12.2016-06:33 - DEBUG - Processed datalog_id 58 02.12.2016-06:33 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock ~~ above part for user creation, below for db creation 02.12.2016-06:35 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. 02.12.2016-06:35 - DEBUG - Found 2 changes, starting update process. 02.12.2016-06:35 - DEBUG - Calling function 'db_user_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_update'. 02.12.2016-06:35 - DEBUG - Processed datalog_id 59 02.12.2016-06:35 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'. 02.12.2016-06:35 - DEBUG - Created MySQL database: serpeps_base1 02.12.2016-06:35 - DEBUG - Calling GRANT for serpeps_base1 with access rw and hosts localhost 02.12.2016-06:35 - DEBUG - GRANT for user serpepsAdm1 at host localhost 02.12.2016-06:35 - DEBUG - GRANT ALL PRIVILEGES ON `serpeps_base1`.* TO 'serpepsAdm1'@'localhost' IDENTIFIED BY PASSWORD '*5B114EAB83AFCA2F5D6E84CA70CB58574F4F0183' success? no 02.12.2016-06:35 - DEBUG - Processed datalog_id 60 02.12.2016-06:35 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock Third line from the bottom says "success? no". Btw I have created backup 25.11.2016 - there is: etc.tar.gz, ispconfig_db_backup.sql, ispconfig_software.tar.gz.
