Linux CentOS安装mysql-8.0.13-linux-glibc2.12-x86_64的过程

本篇内容介绍了"Linux CentOS安装mysql-8.0.13-linux-glibc2.12-x86_64的过程"的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

Linux下安装mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz

//下载 mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz[root@root ~]# wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.13-linux-glibc2.12-x86_64.tar.xzwget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz//解压mysql[root@root ~]# tar -xJvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz ……mysql-8.0.13-linux-glibc2.12-x86_64/bin/myisamchkmysql-8.0.13-linux-glibc2.12-x86_64/bin/myisamlogmysql-8.0.13-linux-glibc2.12-x86_64/bin/myisampack…… //解压完成//重命名mysql-8.0.13-linux-glibc2.12-x86_64文件夹为mysql[root@root ~]# mv mysql-8.0.13-linux-glibc2.12-x86_64 mysql//将mysql移到/usr/local/ 目录下[root@root ~]# mv /root/mysql /usr/local/mv：是否覆盖"/usr/local/mysql"？ y//添加mysql用户组及MySQL用户[root@root ~]# groupadd mysql[root@root ~]# useradd -r -g mysql mysql//设置/usr/local/mysql/文件夹的用户权限[root@root ~]# cd /usr/local/mysql/[root@root mysql]# chown -R mysql:mysql .///新建MySQL数据存储文件夹[root@root mysql]# mkdir data//初始化mysql数据库，生成默认密码[root@root mysql]#  bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/2018-12-22T05:24:39.603264Z 0 [Warning] [MY-011070] [Server] 'Disablining --skip-symbolic-links (or equivalent) is the default. Consider notas it' is deprecated and will be removed in a future release.2018-12-22T05:24:39.603444Z 0 [System] [MY-013169] [Server] /usr/localmysqld 8.0.13) initializing of server in progress as process 275192018-12-22T05:24:41.891360Z 5 [Note] [MY-010454] [Server] A temporary ed for root@localhost: ePrOX&p>L52#  //这是初始默认密码2018-12-22T05:24:43.475923Z 0 [System] [MY-013170] [Server] /usr/localmysqld 8.0.13) initializing of server has completed[Server] A temporary password is generated for root@localhost: lqs-.d,fN1pB[root@iZwz9ijcs0cia5xad0sewhZ mysql]#  bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/2019-07-01T08:42:30.346859Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.16) initializing of server in progress as process 158882019-07-01T08:42:33.616199Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: lqs-.d,fN1pB2019-07-01T08:42:35.006735Z 0 [System] [MY-013170] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.16) initializing of server has completed//设置数据库存储文件夹的用户权限[root@root mysql]# chown -R root:root ./[root@root mysql]# chown -R mysql:mysql data//修改etc/my.cnf配置文件[root@root ~]# vim /etc/my.cnf //修改为以下内容：[mysqld]server-id                      = 1port                           = 3306bind-address                   = 0.0.0.0 max_connections                = 5000mysqlx_port                    = 33060mysqlx_socket                  = /tmp/mysqlx.sockbasedir                        = /usr/local/mysqldatadir                        = /usr/local/mysql/datasocket                         = /tmp/mysql.sockpid-file                       = /tmp/mysqld.pidslow_query_log                 = ONslow_query_log_file            = /usr/local/mysql/logs/slow.loglog-error                      = /usr/local/mysql/logs/error.loglong_query_time                = 0.2log-bin                        = bin.logrelay-log                      = relay.logbinlog_format                  = ROWrelay_log_recovery             = 1character-set-client-handshake = FALSEcharacter-set-server           = utf8mb4collation-server               = utf8mb4_unicode_ciinit_connect                   ='SET NAMES utf8mb4'innodb_buffer_pool_size        = 1Gjoin_buffer_size               = 128Msort_buffer_size               = 2Mread_rnd_buffer_size           = 2Mlog_timestamps                 = SYSTEMlower_case_table_names         = 1default-authentication-plugin  = mysql_native_password保存退出。[root@root mysql]# chmod 777 /etc/my.cnf //设置开机自启动[root@root mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql[root@root mysql]# chmod +x /etc/init.d/mysql //注册查看服务[root@root mysql]# chkconfig --add mysql[root@root mysql]# chkconfig --list mysqlmysql              0:关闭    1:关闭    2:启用    3:启用    4:启用    5:启用    6:关闭//    /etc/ld.so.conf 这个文件记录了编译时使用的动态链接库的路径，告诉链接器去哪个路径下寻找链接时需要用到的库，如果找不到，就会提示链接错误。如果我们安装了第三方的库，而没有将它放在链接器可以找到的目录，则运行使用这些第三方库的程序时，会提示找不到库。[root@root mysql]# vim /etc/ld.so.cnf添加如下内容：include ld.so.conf.d/*.conf/usr/local/mysql/lib//配置环境变量[root@root mysql]# vim /etc/profile添加如下内容：export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib//让配置文件立马生效[root@root mysql]# source /etc/profile//启动MySQL服务[root@root mysql]# service mysql start//使用生成的密码登陆MySQL数据库[root@root mysql]# mysql -u root -pmysql: [Warning] World-writable config file '/etc/my.cnf' is ignored.Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 8Server version: 8.0.13Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.//修改密码mysql> alter user 'root'@'localhost' identified by '123456';Query OK, 0 rows affected (0.13 sec)mysql> exitBye//退出重登录mysql[root@root mysql]# mysql -u root -pmysql: [Warning] World-writable config file '/etc/my.cnf' is ignored.Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 9Server version: 8.0.13 MySQL Community Server - GPLCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema || sys                |+--------------------+4 rows in set (0.01 sec)到此安装完成！这里设置的 /etc/my.cnf 权限是777 ，就是任何人都可读可写，my.cnf 会被忽略掉，mysql的安全机制，也可以不要my.cnf配置文件。 下面设置一下MySQL的远程访问简单写一下命令，自己写的时候忘了记录，网上也是一大堆。登陆mysqlmysql -u root -p use mysql;select host,user from user; CREATE USER 'root'@'%' IDENTIFIED BY '123456';GRANT ALL ON *.* TO 'root'@'%';flush privileges;ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; FLUSH PRIVILEGES;  下面一定要记得关闭防火墙service iptables stop 设置防火墙开机不启动chkconfig iptables off  然后关机重启，连接试一试吧！

"Linux CentOS安装mysql-8.0.13-linux-glibc2.12-x86_64的过程"的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注网站，小编将为大家输出更多高质量的实用文章！