Can't access mysql via Webmin or PhpMyAdmin.
roger at gwch.net
Fri Apr 29 06:53:04 UTC 2005
Mark Sargent schrieb:
> I can start mysql with the following cmd,
> /etc/rc.d/init.d/mysql start
> phpmyadmin error below,
> *MySQL said: *Documentation
> | #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
> root at localhost ~]# ps -uxwww | grep mysql
> Warning: bad syntax, perhaps a bogus '-'? See
> 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
> root 4771 0.0 0.0 1580 124 pts/2 R+ 14:36 0:00 grep mysql
1) /sbin/service mysqld start -> this should start your mysql server
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 :-)
More information about the users