千家信息网

MySQL 5.7.15 安装 (二进制版本)

发表于:2025-01-25 作者:千家信息网编辑
千家信息网最后更新 2025年01月25日,0.创建mysql用户和组信息[root@gxoradb1 ~]# groupadd mysql[root@gxoradb1 ~]# useradd -r -g mysql -s /bin/false
千家信息网最后更新 2025年01月25日MySQL 5.7.15 安装 (二进制版本)
0.创建mysql用户和组信息
[root@gxoradb1 ~]# groupadd mysql[root@gxoradb1 ~]# useradd -r -g mysql -s /bin/false mysql
1.指定安装目录
[root@gxoradb1 ~]# cd /usr/local[root@gxoradb1 local]# lsmysql-advanced-5.7.15-linux-glibc2.5-x86_64.tar.gz
2.解压mysql
[root@gxoradb1 local]# tar -zxvf mysql-advanced-5.7.15-linux-glibc2.5-x86_64.tar.gz [root@gxoradb1 local]# mv mysql-advanced-5.7.15-linux-glibc2.5-x86_64/ mysql-5.7.15[root@gxoradb1 local]# ln -s mysql-5.7.15 mysql[root@gxoradb1 local]# ls -lalrwxrwxrwx  1 root root     12 Oct  4 14:58 mysql -> mysql-5.7.15drwxr-xr-x  9 root root   4096 Oct  4 14:56 mysql-5.7.15
3.调整目录权限
[root@gxoradb1 local]# cd mysql[root@gxoradb1 mysql]# mkdir mysql-files[root@gxoradb1 mysql]# chmod 750 mysql-files[root@gxoradb1 mysql]# chown -R mysql:mysql .
The mysql-files directory provides a convenient location to use as the value of the secure_file_priv system variable that limits import/export operations to a specific directory.
4.初始化mysql
[root@gxoradb1 mysql]# bin/mysqld --initialize --user=mysql2016-10-04T07:07:05.044029Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-10-04T07:07:05.351321Z 0 [Warning] InnoDB: New log files created, LSN=457902016-10-04T07:07:05.396915Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2016-10-04T07:07:05.454329Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2825c52a-8a01-11e6-abb2-080027b5eb23.2016-10-04T07:07:05.456104Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2016-10-04T07:07:06.265334Z 0 [Warning] CA certificate ca.pem is self signed.2016-10-04T07:07:06.503976Z 1 [Note] A temporary password is generated for root@localhost: <5Tk+Gs7frb7 //临时口令[root@gxoradb1 mysql]# bin/mysql_ssl_rsa_setup
5.调整目录权限
[root@gxoradb1 mysql]# chown -R root .[root@gxoradb1 mysql]# chown -R mysql data mysql-files
6.启动mysql
[root@gxoradb1 mysql]# bin/mysqld_safe --user=mysql &[1] 11211[root@gxoradb1 mysql]# 2016-10-04T07:10:20.032700Z mysqld_safe Logging to '/usr/local/mysql/data/gxoradb1.err'.2016-10-04T07:10:20.058270Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
7.创建自启动脚本
[root@gxoradb1 mysql]# cp support-files/mysql.server /etc/init.d/mysql.server[root@gxoradb1 mysql]# chkconfig --add mysql.server[root@gxoradb1 mysql]# chkconfig --list mysql.server  mysql.server    0:off   1:off   2:on    3:on    4:on    5:on    6:off
8.登录mysql数据库
[root@gxoradb1 ~]# mysql -u root -h localhost -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 5Server version: 5.7.15-enterprise-commercial-advancedCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
9.修改root用户口令
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'oracle';
mysql> set password for 'root'@'localhost'=password('oracle');


官方文档中对二进制安装的说明
shell> yum install libaio //安装libaio包
shell> groupadd mysqlshell> useradd -r -g mysql -s /bin/false mysqlshell> cd /usr/localshell> tar zxvf /path/to/mysql-VERSION-OS.tar.gzshell> ln -s full-path-to-mysql-VERSION-OS mysqlshell> cd mysqlshell> mkdir mysql-filesshell> chmod 750 mysql-filesshell> chown -R mysql .shell> chgrp -R mysql .shell> bin/mysql_install_db --user=mysql    # Before MySQL 5.7.6shell> bin/mysqld --initialize --user=mysql # MySQL 5.7.6 and upshell> bin/mysql_ssl_rsa_setup              # MySQL 5.7.6 and upshell> chown -R root .shell> chown -R mysql data mysql-filesshell> bin/mysqld_safe --user=mysql &# Next command is optionalshell> cp support-files/mysql.server /etc/init.d/mysql.server
DirectoryContents of Directory
bin,scriptsmysqld server, client and utility programs
dataLog files, databases
docsMySQL manual in Info format
manUnix manual pages
includeInclude (header) files
libLibraries
shareMiscellaneous support files, including error messages, sample configuration files, SQL for database installation



0