phpMyAdmin, mysql

cornleader · 08-04-2005, 11:59 AM

I am trying to set up phpMyAdmin and mysql on a new Yoper install. I can log into mysql from the console but I cant get phpmyadmin to log in.

I am using phpMyAdmin 2.6.3-pl1. Here are some lines from the config file...

Code:

$cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?

$cfg['Servers'][$i]['user']          = 'root';      // MySQL user

$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed

The login screen just keeps popping up over and over when trying to log in.
if i use config for the auth type then this happens (and I did enter the password in the config file before changing to config auth)...

Code:

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

cookie does the same thing.

in phpinfo() under the mysql section i get this...

Code:

MYSQL_SOCKET 	/var/run/mysqld/mysqld.sock

I need help ... i have been searching for over 10 hours now and i'm loosing it.
Oh and I never tried to set this up in yoper before, only in slackware, which i ded get working.

And I should mention this...]
PHP Version 5.0.4
mysql version 4.0.21

i think the problem is with mysql. I can log in to the mysql> prompt but i cant issue any commands there like mysqladmin version.

I had it working there before but now it doesn't work. I am compleatly lost please help.

guideweb · 08-04-2005, 12:29 PM

Hi,

Are you sure your mysqld deamon is running ?
# service mysqld status
if not
# service mysqld start

Look in your /etc/my.conf file to see where the socket file is located (on my FC3 /var/lib/mysql/mysql.sock
)
After go in your /etc/php.ini and search for mysql.default_socket and set it to '/var/lib/mysql/mysql.sock
'

cornleader · 08-04-2005, 01:14 PM

when I do this

mysqld status

i get the following

050804 15:13:01 Can't start server: Bind on TCP/IP port: Address already in use
050804 15:13:01 Do you already have another mysqld server running on port: 3306 ?
050804 15:13:01 Aborting

050804 15:13:01 mysqld: Shutdown Complete

same when i try to start

guideweb · 08-04-2005, 04:30 PM

Ok, your sql server is running but do you match the socket file name in your my.conf and your php.ini ?

cornleader · 08-05-2005, 09:20 AM

I dont have a php.ini file

and in /etc/mycnf I have this

socket = /tmp/mysql.sock

guideweb · 08-05-2005, 12:04 PM

Quote:

Originally posted by cornleader
I dont have a php.ini file

and in /etc/mycnf I have this

socket = /tmp/mysql.sock

Here is differents methods to find your php.ini file :
$ php -i | grep php.ini
$ locate php.ini
$ find / -name "php.ini"

After go in your php.ini and search for mysql.default_socket and set it to '/var/lib/mysql/mysql.sock

make · 03-09-2007, 01:24 AM

Since I came across this problem myself and solved it, I'm posting the solution here. It's as simple as switching "localhost" to "127.0.0.1" from everything that connects to MySQL. For phpMyAdmin I changed it from /etc/phpMyAdmin/config.default.php.