Setting up MySQL on Mandrake 7.0

Hi,

I'm running Linux-Mandrake 7.0 (Air) and installed MySQL when I setup Mandrake. Now, I'm attempting to run MySQL but I don't believe it is running. How can I check this, and if it is not running how can go about having it start up automatically and use it with Apache and PHP or PERL.

If there's a tutorial or something that someone point me to it would be much appreciated, as I haven't found the MySQL docs to be much help. I'm not even sure if everything is installed properly.

If anyone can help it would be much appreciated, thanks.

Chris

------------------
------------------
Chris Rose
crose@teamit.net

You need to run mysql_install_db script. It might be found at /usr/local/mysql/bin/.
Then you may run safe_mysqld to start Mysql.

Thanks,

I gave it a try and the mysql_install_db seemed to run properly but I recieve the following message when I run safe_mysql.

"Starting mysqld demon with databases from /var/lib/mysql
mysqld demon ended

And if I try anything else I get this message.

mysqladmin: connect to server at '' failed; error: 'Can't connect to local mysql server (111)'

Chris

------------------
------------------
Chris Rose
crose@teamit.net

Be sure to setup a hostname correctly. It is something like "foo.bar.com".
Check and see if this script "mysql.server" is found. If so, copy it to your local starup dir.
Any pid file in /var/run/mysqld.pid or /usr/local/mysql/var/mysqld.pid?

Do not run mysqladmin until you setup your hostname correctly.