MySQL +phpMyadmin

Discussion in 'Server Operation' started by kendel, Aug 23, 2010.

  1. kendel

    kendel New Member

    I been going off old outdate guides and informaion around the internet and nothing is working

    I have 2 Servers
    Server A running apache, php, phpmyadmin
    Sever B running MySQL

    Server A has IP of 192.168.1.110
    Server B has IP of 192.168.1.120

    I edited /etc/phpmyadmin/config.inc.php

    to have these:
    $cfg['Servers'][$i]['host'] = 'MySQL IP Address'; // MySQL hostname
    $cfg['Servers'][$i]['port'] = 'port number'; // MySQL port
    $cfg['Servers'][$i]['extension'] = 'mysql';
    $cfg['Servers'][$i]['connect_type']= 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    $cfg['Servers'][$i]['auth_type'] = 'config';
    $cfg['Servers'][$i]['user'] = 'username'; // MySQL user
    $cfg['Servers'][$i]['password'] = 'password'; // MySQL password


    (This par was confusing to I just re-added the line above instead of searching for it all).

    Then I set the MySQL vi /etc/mysql/my.cnf to comment out #bind-address = 127.0.0.1
    There is another line that most of the guides asked me to comment out but I cannot find that like: # skip-networking

    The Next closest match to that is: skip-external-locking

    I will assume that is not it and leave it alone....

    I keep getting errors for example: "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly"

    Another error was it canno connect because it is not accepting connections from the IP Address of my webserver...

    Can anyone help?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    1) Post the output of:

    netstat -tap | grep mysql

    2) Make sure that you created an additional root user record in the mysql User database which allows access from the IP or % and not just from localhost.
     
  3. kendel

    kendel New Member

    Ok thank you I will try...
     

Share This Page