5

MySQL 5.6 won't start on OS X - ambiguous option

view full story
linux-howto

http://serverfault.com – I would like to try MySQL 5.6 on my machine, but I cannot start it. I always get an error : [ERROR] /usr/local/mysql-5.6.5-m8-osx10.6-x86/bin/mysqld: ambiguous option '--log=/var/log/mysqld.log' (log-bin, log_slave_updates) my.cnf: [mysqld]<br/> pid-file=/usr/local/mysql-5.6.5-m8-osx10.6-x86/mysql.pid<br/> log-error=/usr/local/mysql-5.6.5-m8-osx10.6-x86/data/mysql-error.log<br/> log-slow-queries=/usr/local/mysql-5.6.5-m8-osx10.6-x86/data/mysql-slowquery.log<br/> log-bin=/usr/local/mysql-5.6.5-m8-osx10.6-x86/data/mysql-bin.log<br/> general_log_file=/usr/local/m (HowTos)

grtyyu's picture
Submitted by grtyyu on 06/10/2012 – Made popular on 06/10/2012

Stories similar to MySQL 5.6 won't start on OS X - ambiguous option

I originally installed mySQL on OSX and it started fine. I was able to connect with mySQL workbench and create a database. However, after a reboot mySQL will no longer start.

/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.example.com.err --open-files-limit=20000 --pid-file=/var/lib/mysql/server1.example.com.pid

Memory is at %10 always and Cpu at %1 Also /usr/local/apache/bin/httpd -k start -DSSL I have like 10 of them running

How can i stop mysql server (installed using binary installation under /usr/local/mysql)?

When i go in /usr/local/mysql/bin and execute command

mysqld stop i get following error message :

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

[ERROR] Aborting

[Note] mysqld: Shutdown complete

and i can still see process for mysql server.

sa

mysqld fails on F16 41 weeks 5 days ago

I have installed mysql and phpmyadmin via, yum. I get the message

#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) The server is not responding (or the local server's socket is not correctly configured).

The problem though, is with mysql itself.

# service mysqld start Redirecting to /bin/systemctl start mysqld.service Job failed.

I've been trying to reset the root password, and have been following these instructions: http://www.coolestguyplanet.net/how-to-change-the-mysql-root-password/

However, when I use the command:

/usr/local/mysql/bin/mysqld_safe --skip-grant-tables

I receive the following output:

111217 10:00:42 mysqld_safe Logging to '/usr/local/mysql/data/******-********-MacBook-Pro.local.err'. 111217 10:00:42

Installing Mysql.

You can download MySQL at http://www.mysql.org/ . Unzip it at the /usr/local/src/. # cd /usr/local/src # tar zxf mysql-5.1.x.tar.gz # cd mysql-5.1.x To support multilanguage, we set up it as utf8. Also, we set up /usr/local/mysql as a basic directory.

I've changed data directory in /etc/my.cnf.

I was setting up a soft link in linux. Here were the steps I followed:

> groupadd mysql > useradd -g mysql mysql > cd /usr/local > gunzip /home/Tim/Download/mysql.....gz | tar xvf - > ln -s /usr/local/mysql.... mysql

I have mistakenly deleted some of the dependent file for mysql when I am trying to use mysql command i am getting following error :

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have tried reinstalling mysql-server but it still not resolved .

What should I do to bring back everything to normal condition.