Hello, I have a multi-server setup with a Control Panel, Web host, and mail (SMTP server. I am adding another host to be a DNS server, and running through the installation script after answering all the questions, it exits with: ERROR 1698 (28000): Access denied for user 'root'@'localhost' ERROR: Unable to load SQL-Dump into database table. I am able to log in to MySQL (MaridDB) ont he new host with the 'root' user and credentials that I supplied when the installation script asked. I found a post from 2015 with a similar issue (user was reinstalling ISPConfig3) and it was suggested to delete the 'dbispconfig3' database and any 'ispconfig' user that was created. I deleted the database, but there was no 'ispconfig' user in the mysql.user table, so I did not delete any user. Not sure what else to look at or try? Maybe I am missing somewhere else the 'ispconfig' user gets created? Thanks!
The root login is not working, test it with this: mysql -h localhost -u root -p and mysql -h 127.0.0.1 -u root -p Both commands must work. Do not delete any databases or users. You just have a mysql root login issue.
I have done that already (stated in my post) and am able to log in to MySQL with the very same credentials I am giving in the install script.
Have you tested the two exact commands I posted? It is not enough to test just one of them, MySQL has two root login users.
Ah, OK, gotcha. The "localhost" works, but "127.0.0.1" does not. I added a "GRANT ALL PRIVILEGES ON *.*" for 'root'@'127.0.0.1' and the user shows up as such in the mysql.user table, but still gives me an "Access Denied" error. Now that I know what the issue is, I think I can sort it out from here. Interestingly, though, I just checked the SMTP server I added to the "cluster" a few weeks ago, and there is no entry in the mysql.user table for 'root'@'127.0.01' and I am able to connect to MySQL using 127.0.0.1. I will see what the difference in MySQL configuration is between the two servers.
Maybe you disabled networking in mysql? The connection to 'localhost' is a socket and not a network connect.
Doesn't look like networking is disabled. My 50-server.cnf file (this is a Debian host) has: bind-address = 127.0.0.1 and running 'netstat -antup | grep 3306' shows a LISTEN for 127.0.0.1:3306 It is weird. Maybe it is worth just nuking-and-repaving this server and trying again.
OK, so it seems to be resolved. I can log in to MySQL using both 'localhost' and '127.0.0.1'). I did ended up reinstalling the server, then I installed mariadb-server and then ran 'mysql_secure_installation'. Afterwards, I tested and confirmed I could log in using both "hosts". I did run 'mysql_secure_installation' before when I first installed MariaDB as well as while troubleshooting being unable to log in using '127.0.0.1' but I must have really messed something up. I have run the installer and successfully got the server added to my ISPConfig3 cluster. I probably could have just removed MariaDB and then re-installed, but this worked as well.
