Today I faced interesting problem: I can't login t mysql with simple Code: mysql command. It throws error: With command like this: Code: mysql -u root -p I can login. Where did that shortcut go? What I did: * Checked /usr/local/ispconfig/server/lib/mysql_clientdb.conf . It is ok; * Checked if control server has any problems creating new websites / databases. It does not; * My /etc/hosts: * My 50-server.cnf:
Your problem is not related to ISPConfig directly or its config files. If a root user can log in without password depends on the root user entries that you have in the mysql user table, these are not managed by ISPConfig. There are various solutions for that, see here: https://serverfault.com/questions/563714/allow-linux-root-user-mysql-root-access-without-password But take care not to change the existing mysql root login with password as that's what gets used by ISPConfig to create databases and database users. So either create a ,my.cnf file for the root user or you can try to create an additional root user without password.
Ha, yes ~/.my.cnf helped. But strange that this issue randomly happened. Completely unrelated question (I don't want to create separate topic): how to set unlimited quota for website traffic in "Limit template"? Is it -1 or 0 ?
