From the terminal:
Hristo$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL ..................................................................... ERROR! Manager of pid-file quit without updating file.
so I checked the status:
Hristo$ sudo /usr/local/mysql/support-files/mysql.server status Password: /usr/local/mysql/support-files/mysql.server: line 418: pidof: command not found ERROR! MySQL is not running
Again tried this?
Hristo$ /usr/local/mysql/bin/mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
mysql.err:100706 11:38:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 100706 11:38:36 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead. 100706 11:38:36 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. 100706 11:38:36 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 100706 11:38:36 [Note] Plugin 'FEDERATED' is disabled. 100706 11:38:36 InnoDB: Started; log sequence number 0 69987 100706 11:38:36 [ERROR] Can't start server : Bind on unix socket: Permission denied 100706 11:38:36 [ERROR] Do you already have another mysqld server running on socket: /var/mysql/mysql.sock ? 100706 11:38:36 [ERROR] Aborting 100706 11:38:36 InnoDB: Starting shutdown... 100706 11:38:41 InnoDB: Shutdown completed; log sequence number 0 69987 100706 11:38:41 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
Solution:
Configure correctly your my.cnf file.[mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 127.0.0.1
Sael
I'm Sael. An expert coder and system admin. I enjoy to make codes easy for novice.
Website: fb/Fujael
No Comment to " [Solved] MySQL Error on Snow Leopard "