日志报错:

190412 15:56:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 190412 15:56:50 [Note] Server socket created on IP: '0.0.0.0'. 190412 15:56:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

解决方法:mysql_install_db --user=mysql --ldata=/var/lib/mysql/

 

解决后显示:

To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! To do so, start the server, then issue the following commands:

'/usr/bin/mysqladmin' -u root password 'new-password' '/usr/bin/mysqladmin' -u root -h localhost.localdomain password 'new-password'

Alternatively you can run: '/usr/bin/mysql_secure_installation'

which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers.

See the MariaDB Knowledgebase at http://mariadb.com/kb or the MySQL manual for more instructions.

You can start the MariaDB daemon with: cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/mysql/'

You can test the MariaDB daemon with mysql-test-run.pl cd '/usr/mysql-test' ; perl mysql-test-run.

 

根据提示:更改root密码

 

 

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄