Linux云服务环境安装-Mysql8.0篇

淩亂°似流年 2024-04-03 07:26 67阅读 0赞

(1)进入 cd /usr/local/ ,创建mysql文件夹

> mkdir mysql

进入文件夹

![4d508917babc4af895000e3212db1bf6.png][]

(2)下载mysql8.0安装包

> wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.18-el7-x86\_64.tar.gz

![4fb8f44cf8c8497a90294d6eba7ab9af.png][]

拉取成功![1b66f1c1ee634609a1d7c74687cba48b.png][]

(3)进件解压

> tar zxvf mysql-8.0.18-el7-x86\_64.tar.gz

![5432ffa4cb7d4cb6ad2737f650569b5f.png][]

(4)将mysql-8.0.18-el7-x86\_64重命名为 mysql8

![289c2dcd35694c1994f744f0a41f7635.png][]

(5)将mysql8复制到 /usr/local/目录下

> cp -r ./mysql8 /usr/local/

![c6b8333cf0774c4982509ce5b44a53d3.png][]

(6)创建data文件夹

> mkdir data

![3b0312c62d534c04ad0c910d0918faa0.png][]

(7)分别创建用户组以及用户和密码

> groupadd mysql

> useradd -r -g mysql mysql

![36219d0dfae94d2193128993adf93860.png][]

(8)授权用户

> chown -R mysql.mysql /usr/local/mysql8

![5f80eb3ed59d495aa5669ee4299bfd2e.png][]

(9)配置 /etc/my.cnf

> vi /etc/my.cnf

> \[mysqld\]  
> basedir=/usr/local/mysql8/  
> datadir=/usr/local/mysql8/data/  
> socket=/tmp/mysql.sock  
> character-set-server=UTF8MB4  
> lower\_case\_table\_names=1  
> lc-messages=en\_US  
> lc-messages-dir=/usr/local/mysql8/share/english/

(10)进入mysql8文件夹下的bin目录下 -------------初始化基础信息

> ./mysqld --user=mysql --basedir=/usr/local/mysql8/–datadir=/usr/local/mysql8/data/–lower-case-table-names=1 --initialize

![592bf91cbadc44d1babbcd51d7265b27.png][]

获得初始密码

![53b9110974634fcb9c966a2949dfd814.png][]

(11)返回上一级目录,添加mysqld服务到系统

> cd ..

> cp -a ./support-files/mysql.server /etc/init.d/mysql

![ba92fe98fcce4931ac1b66b75f8a815f.png][]

(12)授权以及添加服务

> chmod +x /etc/init.d/mysql

> chkconfig --add mysql

![8a32e2a0c68a4fd0ba86047ccd40d6b8.png][]

(13)启动mysql

> service mysql start

> 查看启动状态
> 
> service mysql status

![25f399b9299c4ecd910f934671502a12.png][]

(14)将mysql命令添加到服务

> ln -s /usr/local/mysql8/bin/mysql /usr/bin

![ff00b1781bb9426b9465284c91cab07e.png][]

(15)登录mysql -uroot -p

> mysql -uroot -p

![9c3a45c4d7424325a68c2e47e9bd2a30.png][]

如果报错 mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

执行此命令 -------------没有报错跳过

> yum install libncurses\*

![1ae16ee590794079be36d04291f0d440.png][]

登录成功,可以修改密码

> ALTER USER USER() IDENTIFIED BY '你的密码';

进行刷新

> flush privileges;

![02257d8651d2468f843c98dfc96a91d2.png][]

(16)进入数据库,配置对外开放

> use mysql;

> select host from user where user = 'root';

> update user set host = '%' where user = 'root'

修改完刷新应用

> flush privileges;

![ff03d6fb9d3e45118747dee605022fbd.png][]

修改成功

![298fcbcbb007453ea66dcb54ddd6f608.png][]

连接成功

![5b2d69d550a84bb2b180e99d37596b2e.png][]

[4d508917babc4af895000e3212db1bf6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/b95f28322741433aa06ceb46811ee67b.png
[4fb8f44cf8c8497a90294d6eba7ab9af.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/c672135c8e4941a19ecdc80594d28bfb.png
[1b66f1c1ee634609a1d7c74687cba48b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/308019647ada44d7b592f019ca918774.png
[5432ffa4cb7d4cb6ad2737f650569b5f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/b5045034197746f1a03bda0cb583b8da.png
[289c2dcd35694c1994f744f0a41f7635.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/18d3adaa5f2046098b1f103cb4153df0.png
[c6b8333cf0774c4982509ce5b44a53d3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/74bebba8bea14387af919d14a7d0fe65.png
[3b0312c62d534c04ad0c910d0918faa0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/efa9d99bdf9c4296b3846aaba4be6993.png
[36219d0dfae94d2193128993adf93860.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/53b54f00d53c46e6880ab312a1034cff.png
[5f80eb3ed59d495aa5669ee4299bfd2e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/7fa8bf42fbcb4a44bceb52792ce33dd1.png
[592bf91cbadc44d1babbcd51d7265b27.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/edd11a1d753f45c3871672c951a63b28.png
[53b9110974634fcb9c966a2949dfd814.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/9022011d9f034e468601eefd33866fb1.png
[ba92fe98fcce4931ac1b66b75f8a815f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/aa214012e565484db39e32bc44d4d424.png
[8a32e2a0c68a4fd0ba86047ccd40d6b8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/cc3233266ce3402abd95a20d06c837bf.png
[25f399b9299c4ecd910f934671502a12.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/3878d47d0c0e4876b20d5cf307627479.png
[ff00b1781bb9426b9465284c91cab07e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/843d3f64d6a24b94a1c41c677313fe9d.png
[9c3a45c4d7424325a68c2e47e9bd2a30.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/161c9b7d370047e6bb7b45a276f37dd9.png
[1ae16ee590794079be36d04291f0d440.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/a3fbe2e5aedc4180bcfeae8e8afd98ee.png
[02257d8651d2468f843c98dfc96a91d2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/55e92ca8dec94b5e9fbe4e1345a9389a.png
[ff03d6fb9d3e45118747dee605022fbd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/26dc81221366433b9fd91d4ab05b1627.png
[298fcbcbb007453ea66dcb54ddd6f608.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/6a4de7bd37f04daabc643e12c7caf271.png
[5b2d69d550a84bb2b180e99d37596b2e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/03/8236422a358d4ce98f93f87a4a2bc1a9.png