Hi, I create database in ispconfig... it looks fine, but it doesn't create the database (just add records in the ispconfig database).... I figured out this by logging into phpmyadmin as root and I could see databases... then I tried creating a new one (by using ispconfig admin) and it didn't show up.... Also when logged in as root in phpmyadmin it said I had no privilegs to create database in there.... could it be that I somehow has lost permissions? What could be the problem?
Look at http://yourserver.com/phpmyadmin/server_privileges.php Check if root have necessary ALL PRIVILEGES
Yes it has: Code: root 127.0.0.1 Yes ALL PRIVILEGES Yes root localhost Yes ALL PRIVILEGES Yes root server1.ispconfig.example Yes ALL PRIVILEGES Yes
Most likely the mysql root password was changed on your server after ISPConfig was installed. Make sure that the mysql root password in the file /usr/local/ispconfig/server/mysql_clientdb.conf is correct.
Thank you SO much!! You were right (was /usr/local/ispconfig/server/lib/mysql_clientdb.conf actually).
