ispconfig creating database problem

Discussion in 'Installation/Configuration' started by Dag Andresen, Dec 4, 2009.

  1. Dag Andresen

    Dag Andresen New Member

    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?
     
    Last edited: Dec 4, 2009
  2. lucani

    lucani Member HowtoForge Supporter

    Last edited: Dec 7, 2009
  3. Dag Andresen

    Dag Andresen New Member

    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
     
  4. Dag Andresen

    Dag Andresen New Member

    Any solutions? Anyone?
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  6. Dag Andresen

    Dag Andresen New Member

    Thank you SO much!! :):) You were right (was /usr/local/ispconfig/server/lib/mysql_clientdb.conf actually).
     

Share This Page