Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
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,

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 fileanything 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,

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 workjust 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?

![]() |
![]() |
![]() |

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |