CentOS 7上安装/升级MariaDB10.2并且重置root密码

发表于 更新于 分类于 ， 阅读次数：

安装MariaDB10.2

1
2
3
4
5
6
7
8
9
10
11
12
13
14
# cd /etc/yum.repos.d/
# vi MariaDB.repo
[root@centos7 yum.repos.d]# cat MariaDB.repo
[mariadb]
name = MariaDB
#baseurl = http://yum.mariadb.org/10.2.7/centos7-amd64
#gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
baseurl = http://mirrors.shu.edu.cn/mariadb/yum/10.2/centos7-amd64/
gpgkey=http://mirrors.shu.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1
# yum install mariadb-server maridb-client
# systemctl enable mariadb
# systemctl start mariadb
# systemctl status mariadb

升级数据库

1
# mysql_upgrade -uroot -p

重置root密码

1
2
3
4
5
6
7
8
9
# systemctl stop mariadb
# mysqld_safe --skip-grant-tables --skip-networking &
# mysql -u root
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> quit;
# kill `cat /var/lib/mysql/centos7.pid`
# systemctl start mariadb