Can't access mysql via Webmin or PhpMyAdmin.
Mark Sargent
powderkeg at snow.email.ne.jp
Fri Apr 29 07:00:54 UTC 2005
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 at 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 at 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.
More information about the fedora-list
mailing list