Hi,

I have just instlaled a clean instalation of fedora core to run as a ftp and web serer.

I am tryign to set up mysql, when i installed i selceted all the mysql options and all teh web server options inclusing php mysql or something.

I also have webmin which reports that mysql server is running, and i have made a username in there sa well as root.

I am trying to set up phpmyadmin, i have downloaded it, un zipped it and ftped it to a folder called phpmyadmin in my /var/www/html folder.

The problem is, is that when i go there, i get the error:

MySQL said:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

I think i have set up the config fiel right:

ive put in my pmi url to be:
(just for localuse)

"http://10.0.0.10/administration/phpmyadmin"

ANd have entered a blowfish secret, got he auth type on cookie (althpouhg on http no usernames seem to work) and my user naem and password in thee first section.

Any help appreciated

Thanks

Darren

Thanks,

What type of socket (socket or TCP) did you setup in the phpmyadmin config? Does the socket exist?

Its set as tcp, is this right?

If not how whould it be set up.

Thanks

Darren

Thanks,

TCP is fine. do a netstat -an. Is mysql.sock listed?

Hi,

Netstat is not listed, although wen i accidently did netstat -sumthing else mysql was listed as a tcp entry.

Not shore what i did there though.

do i need mysql.sock to work even though im connecting with tcp?

Thanks

Darren

Thanks,

Yes.

Post the following lines (and their values) from your config.inc.php file:

$cfg['Servers'][$i]['host']
$cfg['Servers'][$i]['port']
$cfg['Servers'][$i]['socket']
$cfg['Servers'][$i]['connect_type']
$cfg['Servers'][$i]['auth_type']

$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'socket'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user

Thats the liuens form the config file

anything wrong?

DArren

Thanks,

( the connect type is tcp sorri, i was just tring it under socket when i did that, its tcp though, althoug dosnt work on socket either

Darren

Thanks,

Hi,

I ahve changed a few settings in teh cofig fiel and it will now let me try to login but it just sais the username or password is denied, what is cuaing this?

Darren

Thanks,

Just a guess - wrong username and password?

No, i dont think this i the problem, as the usernaem and pword i have in, works if i go to the command line and type in mysql -u root -p
and put the root password in tehre it work

just wont in phpmyadmin.

What could cause this?

DArren

Thanks,

Ok.

What settings did you change in the config file? What were their previous values, and what are their current values?

Hi,

I had the same problems and finally this configuration worked for me.

$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = ''; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only

I did not set any connection type and I tried this before setting mysql root password.

You may want to try?