Centos7 安装mysql-5.7.23-el7-x86_64.tar及配置

Centos7 安装mysql-5.7.23-el7-x86_64.tar及配置

1、下载mysql安装包

下载安装包:https://dev.mysql.com/downloads/mysql/

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28-el7-x86_64.tar

mysql 下载

mysql tar安装包

下载好后,解压,我这里把mysql-5.7.23-el7-x86_64.tar 改名成了mysql-5.7.23.tar.gz

[root@git opt]# mv mysql-5.7.23-el7-x86_64.tar mysql-5.7.23.tar.gz
[root@git opt]# 
[root@git opt]# tar -xcvf mysql-5.7.23.tar.gz
[root@git opt]# ll
total 697288
drwxr-xr-x. 9 root root        168 Oct 10 21:56 mysql-5.7.23
-rw-r--r--. 1 7161 31415 714022690 Jun 10 23:40 mysql-5.7.23.tar.gz

mysql tar 解压

解压后有两个解压包,只管mysql-5.7.23-el7-x86_64.tar.gz这个包,另一个是测试包不用管

2、开始安装mysql

[root@git /opt]# tar -xf mysql5.7.23.tar.gz 
[root@git /opt]# ls
mysql5.7.23.tar.gz                   
mysql-5.7.23-el7-x86_64.tar.gz  
mysql-test-5.7.23-el7-x86_64.tar.gz
[root@git /]# useradd -s /bin/false -d /usr/local/mysql/ mysql
--创建用户 
[root@git /]# mkdir -p /usr/local/mysql/data
[root@git bin]# chown -R mysql.mysql /usr/local/mysql
--创建目录 
(这里没装过数据库是没有mysql这个目录的) 
[root@git /]# tar -xf mysql-5.7.23-el7-x86_64.tar.gz 
[root@git /]# cd mysql-5.7.23-el7-x86_64/
[root@git mysql-5.7.23-el7-x86_64]# ls
bin  COPYING  docs  include  lib  man  README  share  
support-files 
[root@git mysql-5.7.23-el7-x86_64]# cd bin/
[root@git bin]# ls
innochecksum    my_print_defaults          mysql_config         mysqldump       mysqlpump                  mysql_tzinfo_to_sql  resolve_stack_dumplz4_decompress  
mysql           mysql_config_editor        mysqldumpslow     mysql_secure_installation  mysql_upgrade        zlib_decompressmyisamchk   mysqladmin                  
mysqld          mysql_embedded    mysqlshow                  mysqlxtestmyisam_ftdump    mysqlbinlog                 
mysqld-debug         mysqlimport       mysqlslap                  perrormyisamlog      mysqlcheck                  
mysqld_multi         mysql_install_db  mysql_ssl_rsa_setup        replacemyisampack    mysql_client_test_embedded  
mysqld_safe          mysql_plugin      
mysqltest_embedded   resolveip 
[root@git bin]# yum -y install libaio gcc make
--安装依赖包 
[root@git bin]# ./mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize
2018-08-03T08:22:14.766220Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. 
Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2018-08-03T08:22:14.768375Z 0 
[ERROR] Can't find error-message file '/usr/local/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.2018-08-03T08:22:15.280059Z 0 
[Warning] InnoDB: New log files created, LSN=457902018-08-03T08:22:15.372315Z 0 
[Warning] InnoDB: Creating foreign key constraint system tables.2018-08-03T08:22:15.435202Z 0 
[Warning] No existing UUID has been found, so we assume that thisis the first time that this server has been started. Generating a new UUID: 543f3d19-96f6-11e8-a609-525400603f3a.2018-08-03T08:22:15.486161Z 0 
[Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2018-08-03T08:22:15.486770Z 1 
[Note] A temporary password is generated for root@localhost: wM<vlfOyU8kN
//到这里就安装完了

3、修改配置

[root@git /]# vim /etc/my.cnf
[root@git /]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock

secure_file_priv="/usr/local/mysql"

#端口
port = 3306

#数据库安装路径
basedir = /usr/local/mysql

#数据文件保存路径
datadir = /usr/local/mysql/data

#socket文件保存位置
socket=/tmp/mysql.sock

#数据库编码格式
character_set_server=utf8

#用户
user=mysql
#
#最大连接数
max_connections=1500
#
skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
#是否支持符号链接,即数据库或表可以存储在my.cnf中指定datadir之外的分区或目录,为0不开启
#symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
#PID文件
pid-file=/usr/local/mysql/data/mysql.pid
#错误文件
log-error=/usr/local/mysql/data/error.log
# include all files from the config directory

!includedir /etc/my.cnf.d
#

4、启动

[root@git mysql-5.7.23-el7-x86_64]# pwd
/mysql-5.7.23-el7-x86_64 
[root@git mysql-5.7.23-el7-x86_64]# ls
bin  COPYING  docs  include  lib  man  README  share
support-files 
[root@git mysql-5.7.23-el7-x86_64]# cp support-files/mysql.server /etc/init.d/mysqld
#复制启动文件到/etc/init.d目录
[root@git mysql-5.7.23-el7-x86_64]# cp -r bin/ /usr/local/mysql/
[root@git mysql-5.7.23-el7-x86_64]# chown -R mysql:mysql /usr/local/mysql/ 
#设置属组属主
[root@git mysql-5.7.23-el7-x86_64]# cd /
[root@git /]# /etc/init.d/mysqld 
restartShutting down MySQL.. SUCCESS! 
Starting MySQL. SUCCESS!
#进入 mysql会报无mysql命令解决方法
-bash: mysql: command not found
[root@git /]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 

5、修改密码

[root@git  ~]# cd /usr/local/mysql/bin/
[root@git bin]# ls
innochecksum       mysql                       mysqld          mysqlimport                mysql_ssl_rsa_setup  resolveip
lz4_decompress     mysqladmin                  mysqld-debug    mysql_install_db           mysqltest_embedded   resolve_stack_dump
myisamchk          mysqlbinlog                 mysqld_multi    mysql_plugin               mysql_tzinfo_to_sql  zlib_decompress
myisam_ftdump      mysqlcheck                  mysqld_safe     mysqlpump                  mysql_upgrade
myisamlog          mysql_client_test_embedded  mysqldump       mysql_secure_installation  mysqlxtest
myisampack         mysql_config                mysqldumpslow   mysqlshow                  perror
my_print_defaults  mysql_config_editor         mysql_embedded  mysqlslap 
[root@git bin]# ./mysql -r root -p
password: 

6、F&Q

6.1、密码忘记修改

1.修改MySQL的登录设置: 
[root@git bin]# vim /etc/my.cnf 
#在[mysqld]的段中加上一句:skip-grant-tables 
#例如: 
[mysqld] 
datadir=/var/lib/mysql 
socket=/var/lib/mysql/mysql.sock 
skip-grant-tables 
保存并且退出vim。
2.重新启动mysql服务 
[root@git bin]# service mysqld restart 
Stopping MySQL: [ OK ] 
Starting MySQL: [ OK ]
3.登录并修改MySQL的root密码 
[root@nginx-test ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14159
Server version: 5.7.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> USE mysql ; 
Database changed 
mysql> UPDATE user SET Password = password ( 'new-password' ) WHERE User = 'root' ; 
Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0 
mysql> flush privileges ; Query OK, 0 rows affected (0.01 sec) 
mysql> quit ;
mysql>set password for root@localhost = password('123456');
如果报错需要先执行
mysql>flush privileges;

6.2、mysql 全目录可执行

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

6.3、阿里云远程访问

如果换用户无法访问,检查有无访问链接路径的权限
阿里云需要配置安全组规则,开放3306端口
详见https://blog.csdn.net/wei389083222/article/details/78286629