Connecting to mySQL databases

Discussion in 'General' started by timaaarrreee, Jun 7, 2008.

  1. timaaarrreee

    timaaarrreee New Member

    Hi

    I am having trouble connecting to mySQL databases when installing php programs like Simple Machines Forum, Joomla, Flash chat and more here is the format i have been trying:

    Host: localhost

    Databast name: web1db1
    Database user: web1u1
    Password: (my passoword)

    I have tried the following host names to connect but all have failed;
    ispconfig.khost.co.nz
    khost.co.nz
    ispconfig

    Am i doing somwthing patheticly wrong?

    Tim.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    You will have to use "localhost" as hostname.
     
  3. timaaarrreee

    timaaarrreee New Member

    yep i have certainly tried localhost but there is sign of it wanting to connect :mad:

    Edit:
    I have now tried to connect to my database as the mysql root user and still did not work!!

    I have also tried giving the user full permissions in PHPMyAdmin but still won't cinnect.

    Do i have to create a table prefis names smf_ with a certian number of feilds to be albe to get the smf install to work
     
    Last edited: Jun 8, 2008
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Please post the output of:

    netstat -tap | grep mysql
     
  5. timaaarrreee

    timaaarrreee New Member

    Code:
    ispconfig:~# netstat -tap | grep mysql
    tcp        0      0 *:mysql                 *:*                     LISTEN     1                                             995/mysqld
    
    I can connect to the database with mySQL Administration program on my windows comp but it is the web install that i can't get to work
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Are you able to login with the following command on the shell:

    mysql -h localhost -u root -p
     
  7. timaaarrreee

    timaaarrreee New Member

Share This Page