Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Trying to setup phpMyAdmin for the first time with MySQL.

I just created the config script with the wizard as follows:

$i++;
$cfg['Servers'][$i]['host'] = 'http://server_name_here.edu';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['port'] = '10021';
$cfg['Servers'][$i]['socket'] = '/home/user7/mysql.sock';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mypassword12345';
$cfg['Servers'][$i]['AllowDeny']['order'] = '';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array();

When I go to run the main php admin index page I get the following error:

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. Error

MySQL said: Documentation 2005 - Unknown MySQL server host 'http' (1)

Any point in the right direction is very helpful.

Thank You.

EDIT

removed the http:// prefix from the server name -

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. Error

MySQL said: Documentation 2013 - Lost connection to MySQL server at 'waiting for initial communication packet', system error: 99

share|improve this question
    
what distribution of linux are you running? Is mysql started ps ax | grep mysql? –  Jeremy W Jun 15 '12 at 5:10
add comment

1 Answer

Remove http:// from the server hostname. MySQL doesnt use http for connections.

Also MySQL uses port 3306 not 10021.

share|improve this answer
    
even if I changed the port number during installation? i.e. - setenv MYSQL_TCP_PORT 10021 –  Greg McNulty Jun 15 '12 at 4:39
1  
remove http:// as a first step. –  Jeremy W Jun 15 '12 at 4:41
    
@Greg McNulty the hostname cant have http:// prefixed to it, it just wont work however your port might be different (Generally its 3306.) –  Adam Jun 15 '12 at 4:42
    
All I removed the http:// prefix, however, now the index page sits there forever and then times out....? –  Greg McNulty Jun 15 '12 at 4:43
2  
check your logs ... tail -fn30 /var/log/mysql/error.log or something like it. –  Jeremy W Jun 15 '12 at 4:44
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.