【数据库】数据库服务端启动错误
| 1 minute read | Using 180 words
mariadb Could not open mysql.plugin table 错误
解决如下
systemctl stop mariadb
rm -R /var/lib/mysql/*
mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
systemctl start mariadb
Mar 25 11:27:28 clay mariadbd[1669385]: 2022-03-25 11:27:28 0 [Note] Plugin 'FEEDBACK' is disabled.
Mar 25 11:27:28 clay mariadbd[1669385]: 2022-03-25 11:27:28 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Mar 25 11:27:28 clay mariadbd[1669385]: 2022-03-25 11:27:28 0 [Note] InnoDB: Buffer pool(s) load completed at 220325 11:27:28
Mar 25 11:27:28 clay mariadbd[1669385]: 2022-03-25 11:27:28 0 [Note] Server socket created on IP: '127.0.0.1'.
Mar 25 11:27:28 clay mariadbd[1669385]: 2022-03-25 11:27:28 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 98: Address already in>
Mar 25 11:27:28 clay mariadbd[1669385]: 2022-03-25 11:27:28 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Mar 25 11:27:28 clay mariadbd[1669385]: 2022-03-25 11:27:28 0 [ERROR] Aborting
Mar 25 11:27:28 clay systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Mar 25 11:27:28 clay systemd[1]: mariadb.service: Failed with result 'exit-code'.
Mar 25 11:27:28 clay systemd[1]: Failed to start MariaDB 10.5.12 database server.
这个是端口错误 修改 /ect/mysql/mariadb.cnf
到空闲的端口
root 密码 无密码登录
sudo mysql -u root -h localhost -p