MySQL installation error solved a case

Error log:

[[email protected] scripts]# tail /var/log/mysqld.loginnodb: apply batch  Completed2014-12-08 11:01:37 15721 [note] innodb: 128 rollback segment (s)  are active.2014-12-08 11:01:37 15721 [Note] InnoDB: Waiting for  purge to start2014-12-08 11:01:37 15721 [note] innodb: 5.6.12 started;  log sequence number 16006072014-12-08 11:01:37 15721 [note] server  hostname  (bind-address):  ' * ';  port: 33062014-12-08 11:01:37 15721 [ note] ipv6 is available.2014-12-08 11:01:37 15721 [note]   -   ':: '  resolves to  ':: ';2014-12-08 11:01:37 15721 [note] server  socket created on ip:  ':: '. 2014-12-08 11:01:37 15721 [error] fatal  error: can ' T open and lock privilege tables: table  ' mysql.user '  doesn ' t exist141208  11:01:37 mysqld_safe mysqld from pid file /var/lib/mysql/HKBO.pid  Ended

Cause of Error:

The DataDir path specified by mysql_install_db is/home/tools/mysql/data, and MY.CNF is the default path

So modify the/ETC/MY.CNF path and he'll be the same.

[Email protected] scripts]# VIM/ETC/MY.CNF
[Mysqld]

..........
Datadir=/home/tools/mysql/data
Socket=/var/lib/mysql/mysql.sock
User=mysql
..........

Then re-mysql_install_db, problem solving

[[email protected] scripts]#/etc/init.d/mysqld start
Starting MySQL. success!

This article is from the "it--Brother" blog, please make sure to keep this source http://402753795.blog.51cto.com/10788998/1764136

MySQL installation error solved a case