yum安装mysql 之后问题

日志报错:

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

解决方法: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密码

 

 

转载于:https://www.cnblogs.com/sfth/p/10697039.html