MySQL Daemon failed to start.

Question

我真是被折腾死了，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!

Answer 1

Geely 2017-11-24 22:58:09

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

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

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

• 提问者 Lifeisgreat #1

  删除了不行的。还是报错。但是我又root重启服务便成功了。。。

• Geely 回复 提问者 Lifeisgreat #2

  汗好滴吧。。别卡着，先继续学习

• 知道夜的黑 #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