MySQL is not running on your system.....

[Juan]

Hello,

I have an interesting issue here. When I try to administer MySQL, I get this notice:

"MySQL is not running on your system - database list could not be retrieved."

It provides a "Start MySQL Server" button with an additional message of:

"Click this button to start the MySQL database server on your system with the command /etc/init.d/mysql start. This Webmin module cannot administer the database until it is started."

Now, I know for fact that MySQL is running because I can access my sites, log into mysql to admin via command line.

The module is configured correctly as the path to mysql binaries are in fact in /usr/bin...

What could my problem be?

Package versions:
Webmin 1.170
MySQL 4.0.22

[homemachine]

click the button

[Juan]

Had I fixed my issue by "clicking the button" I wouldn't have posted a message.

Thanks anyways.

[homemachine]

basics first

try stopping mysql then start it with that module

[Juan]

Well, the module *does* start the mysql server but still nothing.

[Juan]

errrr. Nothing as in... I still get the same screen as my original post.

[homemachine]

do whereis mysql and see if the mysql config matches that output

[Juan]

Here's the output:

shadow dracco # whereis mysql
mysql: /usr/bin/mysql /etc/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql /usr/man/man1/mysql.1.gz /usr/share/man/man1/mysql.1.gz

My path to mysql shared libs is /usr/lib and the path to the binaries is /usr/bin and my init script is /etc/init.d/mysqld...

So yea, everything checks out...

Weird.

[Juan]

I suppose this is forcing me to learn mysql from command line but.. um... hehe. it's easier with a purdy GUI.. =P