1. Download Mysql For Mac Os
2. Mac Manual Mysql Tutorial
3. Mysql Mac Manual
4. Install Mysql On Mac Os
5. Mac Manual Mysql Download
6. Mac Manual Mysql Tutorial

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:

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 have been using Excel 2011 for Mac for a couple of years to connect to a MySQL database using the ODBC Connector. This morning I upgraded to Excel 2016 for Mac. Unfortunately this has broken my connection to MySQL. I can't access MySQL now from either Excel 2016 or 2011.

After

su root

I start the mySQL server by command-line, it produce 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

Please help me!

Download Mysql For Mac Os

EDIT:

The reason is here: http://dev.mysql.com/doc/refman/5.5/en/changing-mysql-user.html

A solution is described in the xdazz's answer below.

Anthonyvietstonevietstone

12 Answers

Try /usr/local/mysql/bin/mysqld_safe

Example:

You can also add these to your bash startup scripts:

Alanxdazzxdazz

Simply:

mysql.server start

mysql.server stop

mysql.server restart

tom10271user2792249user2792249

I like the aliases too ... however, I've had issues with MySQLCOM for start ... it fails silently ... My workaround is akin to the others ... ~/.bash_aliases

JordanEddie B

Mac Manual Mysql Tutorial

Eddie B

As this helpful article states:On OS X to start/stop MySQL from the command line:

On Linux start/stop from the command line:

Some Linux flavours offer the service command too

or

If you installed it with homebrew, the binary will be somewhere like

which means you can start it with

and stop it with

Edit: As Jacob Raccuia mentioned, make sure you put the appropriate version of MySQL in the path.

Alex KAlex K

make alias in .bash_profile

and if you are trying to run as root use following safe mode

if you are still having issues starting, a recommended read:mysql5.58 unstart server in mac os 10.6.5

DennisDennis

maybe your mysql-server didn't started

you can try

/usr/local/bin/mysql.server start

If it's installed with homebrew try just typing down mysql.server in terminal and that should be it.AFAIK it executable will be under /usr/local/bin/mysql.server.

If not you can always run following 'locate mysql.server' which will tell you where to find such file.

gitaarik

Mysql Mac Manual

If you have MySQL installed through Homebrew these commands will help you:

Mario UherMario Uher

My MySQL is installed via homebrew on OS X ElCaptain. What fixed it was running

brew doctor

• which suggested that I run

sudo chown -R $(whoami):admin /usr/local

Then:

Install Mysql On Mac Os

mysql is now running

Mac Manual Mysql Download

Have you set a root password for your mysql installation? This is different to your sudo root password. Try /usr/local/mysql/bin/mysql_secure_installation

Mac Manual Mysql Tutorial

Not the answer you're looking for? Browse other questions tagged mysqlmacoscommand-lineosx-lion or ask your own question.