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.
