Linux安装MySQL--详解,跟着一步一步来,你就成功了

╰+哭是因爲堅強的太久メ 2023-02-24 11:13 16阅读 0赞

[精选30+云产品，助力企业轻松上云！>>> ![hot3.png][]][30_ _hot3.png]

# 1. 卸载自带的mariadb数据库 #

*  查询mariadb数据库

命令:   rpm -qa | grep -i mariadb

![up-b286749158f1f61997145ade12b8f389923.png][]

*  卸载mariadb数据库

根据自己查询出来的名字删除 mariadb-libs-5.5.64-1.el7.x86_64, 如上图
    命令:  rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64

![up-ed9c882eead653e40e5a76f0a406e4774c5.png][]

# 2. 安装 #

用到的软件以及安装包,都在该网盘中,自己去取即可
    链接：https://pan.baidu.com/s/1kGFEv--CQ5RlVLwgLiy8dg
    提取码：f1qw
    复制这段内容后打开百度网盘手机App，操作更方便哦

![up-31f0590bc8d78713d4e610a33015c91c396.png][]

## \---安装要正式开始了哦--- ##

## 2.1 通过root账号创建mysql账号 ##

命令:
    useradd mysql
    passwd mysql

![up-108cd362f962935450929d17226d573beb1.png][]

## 2.2 通过CRT登录mysql账号 ##

### 2.2.1. 连接 ###

![up-25ee2fbf6062735b222a7d46eb31f585db4.png][]

### 2.2.2.输入密码 ###

![up-b33b64bf7c3956426bd5ad6047ea88053d3.png][]

### 2.2.3. 设置 ###

![up-ef4191e6f5e5595d045fb73786de8428114.png][]

#### 2.2.3.1.修改名字 ####

![up-4143c2841ba80b4d64af82513e845248f87.png][]

#### 2.2.3.2.背景颜色 ####

![up-9a5820f2926ec3818dc243caae708a92c4f.png][]

#### 2.2.3.3.修改编码 utf-8 ####

![up-0fa3d06360464309375d665fe7dc0ff1445.png][]

## 2.3 获取root权限 ##

命令: su

![up-aeb69160b0178a3bf09d0382f7f629c98a2.png][]

## 2.4 安装 ##

### 2.4.1 上传安装包 ###

使用SecureFX软件进行上传安装包,上面百度网盘中有,安装步骤也有,自己看
    如果有自己的工具使用自己的即可。

![up-cbb64520fc7e5fa48abb6c9869085c8aba3.png][]

![up-2f32859c783a96a204d14a29fcf612bff1e.png][]

### 2.4.2 安装 ###

#### 2.4.2.1 查看是否已经上传成功 ####

切换到上传的mysql目录
    切换命令: cd
    查看所在没目录命令: pwd
    查看目录下所有目录及文件命令(不是数字1,是字母L的小写): ll

![up-3b7ada08e7ac777310c4601c1fecdbd4411.png][]

#### 2.4.2.2 使用yum命令进行安装 ####

命令: yum install mysql-community-*.rpm
    注意: 安装过程中, 后面会提示是否确定, 输入y即可继续,输入n即可停止,我们输入y继续

![up-904a8d7b11f8be7e4630f507ae118818704.png][]

## 2.5 启动mysql(停止mysql) ##

启动命令: systemctl start mysqld.service
    停止命令: systemctl stop mysqld.service

![up-d3a5044469fe24ad01d75b480078c935c6b.png][]

## 2.6 修改默认密码 ##

### 2.6.1 查看默认密码,用于登录mysql ###

命令: grep 'temporary password' /var/log/mysqld.log
    下划线标注的即是默认密码,使用时复制,避免出错

![up-203bbaa173938027260cc490e16170d7211.png][]

### 2.6.2 登录mysql ###

mysql -uroot -p密码(密码复制即可,避免出错)
    命令: mysql -uroot -p,Qp::,7#:hs0

![up-5956c892effaa9eb10cfe0e3f175e1aade6.png][]

### 2.6.3 设置root密码 ###

命令
    set password=password("1234");
    set global validate_password_policy=0;
    set global validate_password_length=1;

![up-a81229501927a8d6460aff971d9b54a0032.png][]

### 2.6.4 退出mysql账号&root权限 ###

exit

![up-66f87a69ea5f49e42a5c4ed029d18665567.png][]

## 2.7 创建mysql远程账号 ##

![up-1c643b2e8a1a2b703466a2a925d6f75d952.png][]

需要先登录mysql,用你刚刚重新设置的密码进行登录即可
    授权命令: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234' WITH GRANT OPTION;
    刷新命令: flush privileges;

![up-29a13165c02bc8bc7c595164257de225ab2.png][]

%的意思是代表远程可以访问

![up-c6dfbb7a5dc239612799c0f0d90a5331bac.png][]

## 2.8 开启mysql防火墙端口 ##

注意: 先关闭mysql账号登录linux, 使用root账号登录linux

#添加端口号 --permanent代表永久生效，没有此参数重启后失效
    firewall-cmd --zone=public --add-port=3306/tcp --permanent 
    #重新载入
    firewall-cmd --reload
    #查看所有打开的端口:
    firewall-cmd --zone=public --list-ports
    #启动：
    systemctl start firewalld
    #关闭：
    systemctl stop firewalld

![up-238c65fe05a959c0e7fab5eab8e1101c1c6.png][]

## 2.9 远程访问 ##

本地cmd访问
    mysql -h地址 -u账号 -p密码
    示例: mysql -h192.168.137.131 -uroot -p1234

![up-7b49ee1468175652ad97d68d99c5eb93e56.png][]

## ok,安装成功,如果有用帮忙点个赞,谢谢 ##

[hot3.png]: /images/20230209/dbeabbb9ae094d2990cd7d698ca13ae6.png
[30_ _hot3.png]: https://www.oschina.net/action/visit/ad?id=1221
[up-b286749158f1f61997145ade12b8f389923.png]: /images/20230209/fb6dff3900754ef68d85d8980066d2c8.png
[up-ed9c882eead653e40e5a76f0a406e4774c5.png]: /images/20230209/471a6a38b4de4da5b334e071bb5bdb41.png
[up-31f0590bc8d78713d4e610a33015c91c396.png]: /images/20230209/99d7ddbdf7d84f19bf538b3834dbbb67.png
[up-108cd362f962935450929d17226d573beb1.png]: /images/20230209/c769a467726349dd999e7a1c01be8235.png
[up-25ee2fbf6062735b222a7d46eb31f585db4.png]: /images/20230209/56114ebd4aef4bdc98a0f23691df74dd.png
[up-b33b64bf7c3956426bd5ad6047ea88053d3.png]: https://oscimg.oschina.net/oscnet/up-b33b64bf7c3956426bd5ad6047ea88053d3.png
[up-ef4191e6f5e5595d045fb73786de8428114.png]: https://oscimg.oschina.net/oscnet/up-ef4191e6f5e5595d045fb73786de8428114.png
[up-4143c2841ba80b4d64af82513e845248f87.png]: https://oscimg.oschina.net/oscnet/up-4143c2841ba80b4d64af82513e845248f87.png
[up-9a5820f2926ec3818dc243caae708a92c4f.png]: https://oscimg.oschina.net/oscnet/up-9a5820f2926ec3818dc243caae708a92c4f.png
[up-0fa3d06360464309375d665fe7dc0ff1445.png]: https://oscimg.oschina.net/oscnet/up-0fa3d06360464309375d665fe7dc0ff1445.png
[up-aeb69160b0178a3bf09d0382f7f629c98a2.png]: https://oscimg.oschina.net/oscnet/up-aeb69160b0178a3bf09d0382f7f629c98a2.png
[up-cbb64520fc7e5fa48abb6c9869085c8aba3.png]: https://oscimg.oschina.net/oscnet/up-cbb64520fc7e5fa48abb6c9869085c8aba3.png
[up-2f32859c783a96a204d14a29fcf612bff1e.png]: https://oscimg.oschina.net/oscnet/up-2f32859c783a96a204d14a29fcf612bff1e.png
[up-3b7ada08e7ac777310c4601c1fecdbd4411.png]: https://oscimg.oschina.net/oscnet/up-3b7ada08e7ac777310c4601c1fecdbd4411.png
[up-904a8d7b11f8be7e4630f507ae118818704.png]: https://oscimg.oschina.net/oscnet/up-904a8d7b11f8be7e4630f507ae118818704.png
[up-d3a5044469fe24ad01d75b480078c935c6b.png]: https://oscimg.oschina.net/oscnet/up-d3a5044469fe24ad01d75b480078c935c6b.png
[up-203bbaa173938027260cc490e16170d7211.png]: https://oscimg.oschina.net/oscnet/up-203bbaa173938027260cc490e16170d7211.png
[up-5956c892effaa9eb10cfe0e3f175e1aade6.png]: https://oscimg.oschina.net/oscnet/up-5956c892effaa9eb10cfe0e3f175e1aade6.png
[up-a81229501927a8d6460aff971d9b54a0032.png]: https://oscimg.oschina.net/oscnet/up-a81229501927a8d6460aff971d9b54a0032.png
[up-66f87a69ea5f49e42a5c4ed029d18665567.png]: https://oscimg.oschina.net/oscnet/up-66f87a69ea5f49e42a5c4ed029d18665567.png
[up-1c643b2e8a1a2b703466a2a925d6f75d952.png]: https://oscimg.oschina.net/oscnet/up-1c643b2e8a1a2b703466a2a925d6f75d952.png
[up-29a13165c02bc8bc7c595164257de225ab2.png]: https://oscimg.oschina.net/oscnet/up-29a13165c02bc8bc7c595164257de225ab2.png
[up-c6dfbb7a5dc239612799c0f0d90a5331bac.png]: https://oscimg.oschina.net/oscnet/up-c6dfbb7a5dc239612799c0f0d90a5331bac.png
[up-238c65fe05a959c0e7fab5eab8e1101c1c6.png]: https://oscimg.oschina.net/oscnet/up-238c65fe05a959c0e7fab5eab8e1101c1c6.png
[up-7b49ee1468175652ad97d68d99c5eb93e56.png]: https://oscimg.oschina.net/oscnet/up-7b49ee1468175652ad97d68d99c5eb93e56.png