在阿里云服务器上安装mysql并且初始化

川长思鸟来 2022-09-05 00:19 223阅读 0赞

# 1、卸载MySQL #

1 删除Mysql

yum remove  mysql mysql-server mysql-libs mysql-server;
    
    find / -name mysql 将找到的相关东西delete掉(rm -rf /var/lib/mysql)；
    
    rpm -qa|grep mysql(查询出来的东东yum remove掉)
    
    rm /etc/my.cnf

查看是否还有mysql软件：

rpm -qa|grep mysql

如果存在的话，继续删除即可。

rpm方式安装的mysql

a）查看系统中是否以rpm包安装的mysql：

[root@localhost opt]# rpm -qa | grep -i mysql
    MySQL-server-5.6.17-1.el6.i686
    MySQL-client-5.6.17-1.el6.i686

b)卸载mysql

[root@localhost local]# rpm -e MySQL-server-5.6.17-1.el6.i686
    [root@localhost local]# rpm -e MySQL-client-5.6.17-1.el6.i686

c)删除mysql服务

[root@localhost local]# chkconfig --list | grep -i mysql
    [root@localhost local]# chkconfig --del mysql

d)删除分散mysql文件夹

[root@localhost local]# whereis mysql 或者 find / -name mysql
    mysql: /usr/lib/mysql /usr/share/mysql

清空相关mysql的所有目录以及文件

rm -rf /usr/lib/mysql
    rm -rf /usr/share/mysql
    
    rm -rf /usr/my.cnf

通过以上几步，mysql应该已经完全卸载干净了.

# 2、安装mysql; #

下载与安装MySQL：

这里采用Yum管理好了各种rpm包的依赖，能够从指定的服务器自动下载RPM包并且安装，所以在安装完成后必须要卸掉，否则会自动更新。

1.安装MySQL官方的yum repository

> \[root@localhost ~\]\#  
> wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

2.下载rpm包

> \[root@localhost ~\]\# yum -y install mysql57-community-release-el7-10.noarch.rpm

3.安装MySQL服务

> \[root@localhost ~\]\#yum module disable mysql  
> \[root@localhost ~\]\# yum -y install mysql-community-server

最后会出现个complete！

4.启动MySQL服务

> \[root@localhost ~\]\# systemctl start mysqld.service  
> \[root@localhost ~\]\# service mysqld start(我输入这行命令提示没有service，我没理它，直接下一步发现也可以)

检查

> \[root@localhost ~\]\# sudo service mysqld status

看到类似下面的界面，或者以Starting MySqL server… started MysqlServer…结尾的就成功启动了

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA5NjM1Mw_size_16_color_FFFFFF_t_70_pic_center]

5、获取临时密码登录

grep 'temporary password' /var/log/mysqld.log
    mysql -u root -p

![在这里插入图片描述][7f7621a4c60a4438a4d1adbfe4d591e6.png_pic_center]  
注意:这里输入密码登录是黑色的，没有提示

6、重新设置mysql密码

前提：退出数据库

> \[root@localhost ~\]\# vim /etc/my.cnf

修改文件，在根目录的\\etc\\my.cnf文件中添加一行“skip-grant-tables”，就是绕过密码验证，如下：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA5NjM1Mw_size_16_color_FFFFFF_t_70_pic_center 1]  
然后重启mysql服务即可，执行

> \[renyang@master ~\]\# systemctl restart mysqld.service

7、输入“mysql”，即可进入mysql了，接下来可以在mysql中通过SQL语句进行修改密码，依次输入如下命令

mysql> use mysql

mysql> update mysql.user set authentication\_string=password(‘123456’) where user=‘root’;

mysql> flush privileges;

mysql> quit

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA5NjM1Mw_size_16_color_FFFFFF_t_70_pic_center 2]  
8、重新编辑my.cnf，去掉刚才添加的内容：skip-grant-tables。 然后重启MySQL：

> \[renyang@master ~\]\# systemctl restart mysqld.service

就可以用密码进入MySQL了：\[renyang@master ~\]\# mysql -uroot -p

--------------------

参考文章

[https://www.cnblogs.com/cyl048/p/6879085.html][https_www.cnblogs.com_cyl048_p_6879085.html]

[centos7.8安装mysql5.7时Error: Unable to find a match: mysql-community-server][centos7.8_mysql5.7_Error_ Unable to find a match_ mysql-community-server]

[Linux CentOS7通过yum安装mysql-server][Linux CentOS7_yum_mysql-server]

[记录下在阿里云linux上安装与配置Mysql][linux_Mysql]

[阿里云Linux服务器安装MySQL数据库][Linux_MySQL]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA5NjM1Mw_size_16_color_FFFFFF_t_70_pic_center]: /images/20220829/192a3f05785f4191b8a3163df41a5dfa.png
[7f7621a4c60a4438a4d1adbfe4d591e6.png_pic_center]: /images/20220829/670a60b7c859456e89a2e0d4f971f037.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA5NjM1Mw_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20220829/3ca18315de1e4c8a817c745170e7ff88.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDA5NjM1Mw_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20220829/f4b3a6a191a14e419c01202d0efd4548.png
[https_www.cnblogs.com_cyl048_p_6879085.html]: https://www.cnblogs.com/cyl048/p/6879085.html
[centos7.8_mysql5.7_Error_ Unable to find a match_ mysql-community-server]: https://blog.csdn.net/weixin_45616519/article/details/105765719?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522162904983016780269873064%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=162904983016780269873064&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~baidu_landing_v2~default-1-105765719.first_rank_v2_pc_rank_v29&utm_term=Error:%20Unable%20to%20find%20a%20match:%20mysql-community-server&spm=1018.2226.3001.4187
[Linux CentOS7_yum_mysql-server]: https://blog.csdn.net/zhang7761/article/details/109018190?utm_medium=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromMachineLearnPai2~default-3.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromMachineLearnPai2~default-3.control
[linux_Mysql]: https://blog.csdn.net/weixin_30576859/article/details/98963949?utm_medium=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromMachineLearnPai2~default-4.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromMachineLearnPai2~default-4.control
[Linux_MySQL]: https://blog.csdn.net/weixin_45082716/article/details/108384675?utm_medium=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromMachineLearnPai2~default-1.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromMachineLearnPai2~default-1.control