UNIX for Advanced & Expert Users

It really depend on where you configure your Mysql to have that mysql.sock at. Most of the time it would be in /var/lib/mysql/mysql.sock but in some case it is in /tmp/mysql.sock. To make it easy, just make a link from /var/lib/mysql/mysql.sock to /tmp/mysql.sock. This would work.

<quote>Try something like:

shell> bin/safe_mysqld -u user_name &

Where user_name is your MySql login name.

To see if mysqld is running type:

Shell> bin/mysqladmin version

You should see something like:

Running threads: 1</quote>


I was having trouble getting the mysql server started and this tip did the trick but i have a question... I have the start mysql option set to yes in rc.config i believe it is, but it doesnt seem to want to stay on... i tried rcmysql start, it would say ;

starting service MySQL
starting mysql-daemon with database from /var/lib/mysql
021103 09:46:32 mysqld ended

anyway, it would statr and stop really fast. i entered bin/safe_mysqld -u user_name & in the console and it started then left the cursor droped down on the next line with no console prompt so i opened another console window typed rcmysql status and it says running, so cool!

What i would like to know is how to make it do that from start up with out having to type bin/safe_mysqld -u user_name & all the time. also is that the proper way to start mysql server or is it just a way to ensure everything should be working fine. If there is a proper way i wouls sur elike to know. Thanks alot!


Cerberus