title: How to start MySQL server from command line on Mac OS Lion?
body: <p>I installed mySQL on my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preferences, I want to know the instructions to start from command-line.
  I do as follows:</p>
  <p>After</p>
  <blockquote>
  <p>su root</p>
  </blockquote>
  <p>I start the mySQL server by command-line, but it produces an error as below:</p>
  <blockquote>
  <p><strong>sh-3.2#</strong> /usr/local/mysql/bin/mysqld</p>
  <p><strong>111028 16:57:43</strong> [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</p>
  <p><strong>111028 16:57:43</strong> [ERROR] Fatal error: Please read &quot;Security&quot; section of
  the manual to find out how to run mysqld as root!</p>
  <p><strong>111028 16:57:43</strong> [ERROR] Aborting</p>
  <p><strong>111028 16:57:43</strong> [Note] /usr/local/mysql/bin/mysqld: Shutdown complete</p>
  </blockquote>