[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Can't access mysql via Webmin or PhpMyAdmin.



Mark Sargent schrieb:
I can start mysql with the following cmd,

/etc/rc.d/init.d/mysql start

phpmyadmin error below,

Error

*MySQL said: *Documentation <http://dev.mysql.com/doc/mysql/en/Error-returns.html>

| #2002 - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I've got user as root and no password, as I haven't set 1 yet. Why am I getting this.? Anyone seen this before.?

With webmin, I get this displayed,

|*MySQL is not running on your system - database list could not be retrieved.

root localhost ~]# ps -uxwww | grep mysql
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
root 4640 0.0 0.2 4180 1116 ? S 14:19 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid
root 4771 0.0 0.0 1580 124 pts/2 R+ 14:36 0:00 grep mysql


Hi Mark,

1) /sbin/service mysqld start -> this should start your mysql server properly

2) have you in your config.inc.php from phpmyadmin indicated the hostname or localhost? Set it to localhost and try to connect.

usually, when no socket is found, mysql is not running. Look in /var/lib/mysql - do you find a file called mysql.sock? If no, where does it reside now?

btw. try ps -ef | grep mysql - this won't give you errors :-)

HTH
Roger


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]