start mySQL server from command line on Mac OS

ituetvn · 10-29-2011, 08:45 PM

I installed mySQL for my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preference, I want to know the instruction to start from command-line.
I do as follow:

After:

Code:

su root

I start the mySQL server by command-line, it produce error as below:

Code:

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

Please help me

**JasonR** · 10-29-2011, 11:06 PM

Did you read the "Security" section of the manual? The basic problem is that it's not considered safe to run MySQL as root, so you are being prevented from doing so.

To be honest, there aren't many good reasons to run it from the command line that I know of, so I'm not even sure how to do it myself any more. Are you sure you need to?

iSDK · 10-30-2011, 10:19 AM

You should probably checkout running a local web-server like MAMP which is really easy to use and has PHPMyAdmin installed too for easy MySQL database modification.