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

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容