CenOS-6.x~7.x修改mysql默认root密码

1.   卸载mariadb(mysql已经走向收费，因此mariadb作为mysql的一个分支应运而生)，已经安装mariadb的情况下再安装mysql会因为冲突而安装失败。因此先卸载mariadb

执行如下命令，查看mariadb以及相关的程序安装情况：rpm-qa | grep mariadb

使用rpm命令卸载所有的程序(出现在” rpm-qa | grep mariadb”执行结果中的)：
rpm -e mariadb-libs-5.5.37-1.el7_0.x86_64

但是也许rpm会报告因为这个包被其他包依赖，其他包的存在导致无法被卸载，那么就强制卸载
rpm -e --nodeps mariadb-libs-5.5.37-1.el7_0.x86_64

 

2.    下载mysql-community-release-el7-7.noarch.rpm

3.    rpm 安装此软件源

rpm –ivh mysql-community-release-el7-7.noarch.rpm

4.    yum install mysql-server

5.    修改mysql配置文件，允许不输入密码登录mysql(在mysqld这个section添加skip-grant-tables这一行)

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

skip-grant-tables

6.    启动mysql

Service mysqld start

7.    连接mysql, 修改密码

[root@k2~]# mysql

Welcometo the MySQL monitor.  Commands end with; or \g.

YourMySQL connection id is 5

Serverversion: 5.7.19 MySQL Community Server (GPL)

 

Copyright(c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

 

Oracle isa registered trademark of Oracle Corporation and/or its

affiliates.Other names may be trademarks of their respective

owners.

 

Type'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql>use mysql;

Readingtable information for completion of table and column names

You canturn off this feature to get a quicker startup with -A

 

Databasechanged

mysql>UPDATE user SET authentication_string=password("mysql.passwd") WHEREUser='root';

Query OK,0 rows affected, 1 warning (0.00 sec)

Rows matched: 1 Changed: 0  Warnings: 1

mysql>flush privileges;

Query OK,0 rows affected (0.00 sec)

 

mysql>quit

Bye

8. 这时候算完了吗？no no no~!要把my.cnf修改回来(第五步里加上的skip-grant-tables这一行去掉)

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

References:

1.    http://www.linuxidc.com/Linux/2016-03/129683.htm

2.    http://www.cnblogs.com/allenblogs/archive/2010/08/12/1798247.html

3.    http://www.cnblogs.com/daizhuacai/archive/2013/01/17/2865138.html

如果您要使用该文章，请注明出处，附带上本文地址。