yum安装mariadb(mysql)报错及解决方案

1.错误一： Could not retrieve mirrorlist http://mirrorlist.centos.org/

在执行时yum install mysql-community-server-5.7.10-1.el7.x86_64.rpm报出：

原因：系统自带的yum命令不完整，需要连网

解决：重新安装yum,不要嫌麻烦，安装好了以后安装其它软件就是一个命令搞定的事，都不用去下载安装包

如何安装：http://blog.itpub.net/29827022/viewspace-1876981/

因为我自己用rpm安装mysql老是出问题，经人提醒说cenos7自带的是mariadb（mysql的一个分支，即开源mysql）,就转而安装mariadb

yum -y install mariadb* 

2.错误二：Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.

在执行时systemctl start mariadb.service报错

root@localhost:/var/log/mariadb>cat mariadb.log

151221 22:41:16 InnoDB: Completed initialization of buffer pool

InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes

InnoDB: than specified in the .cnf file 0 5242880 bytes!

151221 22:41:16 [Note] Plugin 'FEEDBACK' is disabled.

151221 22:41:16 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

将/var/lib/mysql/ ib_logfile0, ib_logfile1手动删除再mysql_upgrade报下面第三个错误

3.错误三：Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

运行mysql_upgrade时mariadb.log中报错

解决：运行mysql_install_db --user=mysql --ldata=/var/lib/mysql/

具体原因不知

再运行：systemctl start mariadb.service居然不报错了，oh my god终于可以睡个安稳觉咯

root@localhost:/var/log/mariadb>ps -ef|grep -i mariadb*

mysql      4896   4739  0 Dec21 ?        00:00:04 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock

root       7434   4475  0 01:26 pts/1    00:00:00 grep --color=auto -i mariadb.log