PHPMyAdmin Problem


#1

I am having problems writing my basic config.inc.php file.

Here is what I have currently. I’ve tried various configs and I get a username and password with the following error: #2002 - The server is not responding (or the local MySQL server’s socket is not correctly configured)

Here is what I have been trying:

<?php $cfg['blowfish_secret'] = '1bigconspiracy'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ $i = 0; $i++; $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?>

#2

Stupid question (maybe) but is the Mysql server running?


#3

Yes it is running. Does it have to be off?


#4

Erm, no ;) MySQL has to be running.

Here’s what google showed me:
http://forums.mysql.com/read.php?35,648#msg-75300

worships google


#5

I tried changing localhost in my web address and in the config.inc.php to
127.0.0.1 and now get “Cannot log in to the MySQL server” error.

Here is my code:
[php]

<?php /* $Id: config.sample.inc.php 9689 2006-11-10 20:05:49Z nijel $ */ // vim: expandtab sw=4 ts=4 sts=4: /** * phpMyAdmin sample configuration, you can use it as base for * manual configuration. For easier setup you can use scripts/setup.php * * All directives are explained in Documentation.html and on phpMyAdmin * wiki . */ /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = '1bigconspiracy'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysql'; /* User for advanced features */// $cfg['Servers'][$i]['controluser'] = 'root'; //$cfg['Servers'][$i]['controlpass'] = '1bigconspiracy'; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?>

[/php]


#6

If you use [php] and [/php] tags around the code, it’ll show up highlighted. Makes it that much easier for us :wink: In which case I’d suggest trying to connect as root with an empty password field.