Roger Grosswiler wrote:
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
[root@localhost mysql]# /sbin/service mysqld start
mysqld: unrecognized service
I have no problems getting it started, or accessing it via cli. Thought
I made that point clear.
2) have you in your config.inc.php from phpmyadmin indicated the
hostname or localhost? Set it to localhost and try to connect.
Yes, the uri is correct.
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';
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?
Yes, well, that's the weird thing, I showed where it is shown as
running. Being able to access it also shows it's running.
btw. try ps -ef | grep mysql - this won't give you errors :-)
HTH
Roger
Thanx for trying to help. Cheers.
Mark Sargent.