Linux Mysql8.x安装

Love The Way You Lie 2021-12-21 05:25 299阅读 0赞

Linux下MySql 8.x版本安装，这个安装和之前的mysql5.x的安装有点不同，

mysql5.x安装可以参考：[https://blog.csdn.net/vtopqx/article/details/80971158][https_blog.csdn.net_vtopqx_article_details_80971158]  
  
MySql 8.x具体操作：

**1.下载解压**  
[https://www.mysql.com/downloads/][https_www.mysql.com_downloads]  
[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]

**2.解压安装**

[root@txvm2019 mysql]# mv mysql-8.0.16-el7-x86_64  /usr/local/mysql
    [root@txvm2019 mysql]# cd /usr/local/mysql
    [root@txvm2019 mysql]# mkdir data
    [root@txvm2019 mysql]# chown -R mysql.mysql /usr/local/mysql/
    [root@txvm2019 mysql]# mkdir mysql_install_db
    [root@txvm2019 mysql]# chmod 777 ./mysql_install_db
    [root@txvm2019 mysql]# bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
    2019-06-21T02:09:59.805200Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.16) initializing of server in progress as process 15755
    2019-06-21T02:10:05.218758Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ?yl7a)rj_5B3
    2019-06-21T02:10:07.367976Z 0 [System] [MY-013170] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.16) initializing of server has completed

记住上面打印的mysql默认密码：**?yl7a)rj\_5B3**

**3.MySql配置参数**

[root@txvm2019 mysql]# cp -a ./support-files/mysql.server /etc/init.d/mysqld
    [root@txvm2019 mysql]# chmod +x /etc/rc.d/init.d/mysqld    
    [root@txvm2019 mysql]# chkconfig --add mysqld
    
    [root@txvm2019 mysql]# cp support-files/mysql.server /etc/init.d/mysql
    [root@txvm2019 mysql]# chmod +x /etc/init.d/mysql
    [root@txvm2019 mysql]# chkconfig --add mysql

检查服务是否生效

[root@txvm2019 mysql]# chkconfig  --list mysqld
    Note: This output shows SysV services only and does not include native
          systemd services. SysV configuration data might be overridden by native
          systemd configuration.
    
          If you want to list systemd services use 'systemctl list-unit-files'.
          To see services enabled on particular target use
          'systemctl list-dependencies [target]'.
    
    mysqld         	0:off	1:off	2:on	3:on	4:on	5:on	6:off

[root@txvm2019 mysql]# vi /etc/my.cnf
    [mysqld]
        basedir = /usr/local/mysql   
        datadir = /usr/local/mysql/data
        socket = /usr/local/mysql/mysql.sock
        character-set-server=utf8
        port = 3306
        sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    [client]
       socket = /usr/local/mysql/mysql.sock
       default-character-set=utf8

**4.环境变量配置：**

[root@txvm2019 mysql]# vi /etc/profile
    [root@txvm2019 mysql]# source /etc/profile
    [root@txvm2019 mysql]# service mysql start
    Starting MySQL.Logging to '/usr/local/mysql/data/txvm2019.err'.
    . SUCCESS!

**5.设置用户密码及远程连接**

[root@txvm2019 mysql]# 
    [root@txvm2019 mysql]# mysql -uroot -p'?yl7a)rj_5B3'
    mysql>

第一次登陆使用上面安装的默认密码登录，  
设置root密码：

mysql> alter user user() identified by "123456";
    mysql> use mysql
    mysql> update user set host='%' where user='root' limit 1;
    mysql> flush privileges;
    mysql> alter user 'root'@'%' identified with mysql_native_password by '123456';
    mysql> flush privileges;

配置完成！如果有防火墙或者设置了安全组的话需要开通一下默认的3306端口给远程连接。

[https_blog.csdn.net_vtopqx_article_details_80971158]: https://blog.csdn.net/vtopqx/article/details/80971158
[https_www.mysql.com_downloads]: https://www.mysql.com/downloads/
[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/