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

[Mark Sargent <powderkeg snow email ne jp>]

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.