第一步
官方下载地址:https://dev.mysql.com/downloads/mysql/5.7.html#downloads
版本:mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
下载:wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
安装依赖包:
yum -y install libaio numactl
第二步
解压:tar -zxf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
移动:mv mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/mysql
创建数据目录:mkdir /usr/local/mysql/data
创建用户:
groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql
赋予权限
chown mysql:mysql -R /usr/local/mysql/
创建链接:
cd /usr/local/mysql
ln support-files/mysql.server /etc/init.d/mysqld
ln bin/mysql /bin/mysql
初始化数据库:
bin/mysqld –initialize –user=mysql –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data
注意:
初始化数据库,会随机创建密码
一般密码在,初始化输出的日志中,最后一行,最后一个值
第三步
修改my.cnf配置文件
vim /etc/my.cnf
[client]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock
[mysql]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock
[mysqld]
user = mysql
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
character_set_server=utf8
pid-file = /usr/local/mysql/mysqld.pid
socket = /usr/local/mysql/mysql.sock
server-id = 1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT,ANSI_QUOTES
第四步
修改mysqld文件
vim /etc/init.d/mysqld
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
mysqld_pid_file_path=/usr/local/mysql/mysqld.pid
##修改以上这三行的配置
第五步
启动:service mysqld start
进入mysql:mysql -u root -p#F,bkgSk/4hg (密码是随机生成的)
想要对数据库进行操作,需要修改密码,不然会一提示你
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
修改密码
SET PASSWORD FOR ‘root’@localhost=PASSWORD(‘#F,bkgSk/4hg’);
创建外部连接用户跟密码
create user ‘root’@’%’ identified by ‘密码’;
赋予二个用户权限(最大)
grant all on . to root@’%’ identified by ‘密码’;
grant all on . to root@’localhost’ identified by ‘密码’;
刷新Mysql权限
flush privileges;
查看数据库版本
SHOW VARIABLES WHERE Variable_name = ‘version’;