【数据库】数据库服务端启动错误

   |   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


© 2025 by clayliu. All Rights Reserved.