MySQL Daemon failed to start.

来源:13-6 线上环境安装配置实操(mysql)

Lifeisgreat

2017-11-24

我真是被折腾死了,4个多小时过去,仍然没有办法解决,对Linux完全不熟悉。


贴个报错信息,大家帮看下

WARNING: The host 'iZuf6br3aofhevs0d2p3bzZ' could not be looked up with 


resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges !

Installing MySQL system tables...

171124 22:36:09 [Warning] '--default-character-set' is deprecated and will be 


removed in a future release. Please use '--character-set-server' instead.

171124 22:36:09 [Warning] Can't create test file 


/var/lib/mysql/iZuf6br3aofhevs0d2p3bzZ.lower-test

171124 22:36:09 [Warning] Can't create test file 


/var/lib/mysql/iZuf6br3aofhevs0d2p3bzZ.lower-test

ERROR: 1005  Can't create table 'db' (errno: 13)

171124 22:36:09 [ERROR] Aborting


171124 22:36:09 [Note] /usr/libexec/mysqld: Shutdown complete



Installation of system tables failed!  Examine the logs in

/var/lib/mysql for more information.


You can try to start the mysqld daemon with:


    shell> /usr/libexec/mysqld --skip-grant &


and use the command line tool /usr/bin/mysql

to connect to the mysql database and look at the grant tables:


    shell> /usr/bin/mysql -u root mysql

    mysql> show tables


Try 'mysqld --help' if you have problems with paths.  Using --log

gives you a log in /var/lib/mysql that may be helpful.


Please consult the MySQL manual section

'Problems running mysql_install_db', and the manual section that

describes problems on your OS.  Another information source are the

MySQL email archives available at http://lists.mysql.com/.


Please check all of the above before mailing us!  And remember, if

you do mail us, you MUST use the /usr/bin/mysqlbug script!


写回答

1回答

Geely

2017-11-24

171124 22:36:09 [Warning] '--default-character-set' is deprecated and will be 


removed in a future release. Please use '--character-set-server' instead.



同学先看这个。这里提示啦。估计是版本造成的。先按这个提示来。


0
3
知道夜的黑
https://github.com/jdeathe/centos-ssh-mysql/blob/1.2.2/etc/services-config/mysql/my.cnf#L12 #加这几段代码就好了 skip-character-set-client-handshake=1 default-character-set=utf8 collation-server=utf8_unicode_ci
2018-09-01
共3条回复

从0开始 独立完成企业级Java电商网站服务端开发

前后端分离,数据库接口设计,架构设计,功能开发,上线运维

9487 学习 · 8814 问题

查看课程