Start MySQL server from command line on Mac OS Lion

Question

I had installed MySQL in my Mac operating system. After starting the SQL server using MySQL prefpane tool which is installed in the System Preference, I need to know the instruction to start from command-line. I do as follow:

After

su root

I am starting the MySQL server by command-line, it results with an error as below:

sh-3.2# /usr/local/mysql/bin/mysqld

111028 16:57:43 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-5.5.17-osx10.6-x86_64/data/ is case insensitive

111028 16:57:43 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

111028 16:57:43 [ERROR] Aborting

111028 16:57:43 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

Where I am doing wrong ?

Answer 1

Try /usr/local/mysql/bin/mysqld_safe.

Example:

shell> sudo /usr/local/mysql/bin/mysqld_safe

(Enter your password, if necessary)

(Press Control-Z)

shell> bg

(Press Control-D or enter "exit" to exit the shell)

You can also add these lines to your bash startup scripts:

export MYSQL_HOME=/usr/local/mysql

alias start_mysql='sudo $MYSQL_HOME/bin/mysqld_safe &'

alias stop_mysql='sudo $MYSQL_HOME/bin/mysqladmin shutdown'

Want to be a SQL expert? Come and join this SQL training and certification program by Intellipaat.

If you want to know more about MySQL, refer to the below MySQL tutorial video that will help you out in a better way: