can not make database or add user

Discussion in 'Installation/Configuration' started by kwickcut, Nov 29, 2023.

  1. kwickcut

    kwickcut Member HowtoForge Supporter

    so i have installed using this tutorial https://www.howtoforge.com/ispconfig-autoinstall-debian-ubuntu/

    server has been running for 8 or 9 days and has 2 sites going without issues.

    now today i add a new client without issue then add site and then added database user and database. everything shows that it was added under database user and database

    the issue is the database user and database do not truly exist.

    so i checked the users with
    Code:
    mysql -u root -p
    then
    Code:
    SELECT User, Host FROM mysql.user;
    and the user is not listed that was added under ispconfig
    then i checked the listed databases using
    Code:
    SHOW DATABASES;
    and the database does not exist

    like i said they are seen under ispconfig control panel

    not sure what to check to see why they do not exist


    kwick
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Most likely you changed MySQL root password after installing ISPConfig but missed setting the new MySQL root password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf. Or you altered your MySQL configuration and disabled networking in MySQL.
     
    ahrasis likes this.
  3. kwickcut

    kwickcut Member HowtoForge Supporter

    thank you till it was the password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf.

    changed the password and then restarted apache and mysql and everything works as it should..



    kwick
     

Share This Page