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

[Roger Grosswiler <roger gwch net>]

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