Shulou(Shulou.com)05/31 Report--

Editor, I would like to share with you the error "Table 'mysql.user' doesn't exist??" when starting the database during the installation of MySQL 5.5 source code. What to do? I hope everyone will get something after reading this article. Let's discuss it together.

MySQL 5.5Boot database error during source code installation

The error log is as follows:

2016-05-15 02:41:06 42565 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

Reason for reporting an error:

Although the MySQL system table is created, the software installation directory and data file directory are not specified in the configuration file

Solution:

Specify the software installation directory and data file directory in the configuration file

[root@localhost mysql-cluster-gpl-7.4.11] # vim / etc/my.cnf

[client]

Socket=/cluster_data/mysql.sock

[mysqld]

Ndbcluster # start the NDB storage engine

Basedir = / cluster

Datadir = / cluster_data

Socket=/cluster_data/mysql.sock

Log_error = / cluster_data/err.log

[mysql_cluster]

# MySQL cluster node options:

Ndb-connectstring=192.168.78.141 # host of the management node

After reading this article, I believe you have a certain understanding of "MySQL 5.5 source code installation starts the database error" Table 'mysql.user' doesn't exist?? ", if you want to know more related knowledge, welcome to follow the industry information channel, thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.