mysql遇到的问题

1. MySQL said: Can't connect to MySQL server on error (61)

1) first check status

netstat -tulpen

2)modify your configuration

vi/etc/mysql/my.cnf

bind-address=0.0.0.0

3)entry mysql to give privileges

GRANT ALL PRIVILEGES ON *.* to 'root'@'%'IDENTIFIED BY 'Root_MyLearn2012' WITH GRANT OPTION;

FLUSH PRIVILEGES;

4)restart mysql

/etc/init.d/mysql restart

1. Unknown/unsupported storage engine: InnoDB

[mysqld]

default-storage-engine=myisam

2.mysql-server : Depends: mysql-server-5.5 but it is not going to be installed

sudo apt-get purge mysql-client-core-5.6

sudo apt-get autoremove

sudo apt-get autoclean

sudo apt-get install mysql-client-core-5.5

sudo apt-get install mysql-server

3.

14013100:03:02mysqld_safe Loggingto'/usr/local/var/mysql/david-mbp.err'.

14013100:03:02mysqld_safe Starting mysqld daemonwithdatabasesfrom/usr/local/var/mysql

14013100:03:03mysqld_safe mysqldfrompidfile/usr/local/var/mysql/david-mbp.pid ended

sudo chown -R _mysql:admin /usr/local/var/mysql

sudo chmod -R u+rwX,g+rwX,o-rwx /usr/local/var/mysql

http://stackoverflow.com/questions/21470193/mysql-server-start-issues-on-mavericks