MySql5.7.28在Linux下的安装教程
下载安装包
-
方法一:直接在Linux上下载
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
-
方法二:官网下载,再上传Linux
-
打开网址:
https://dev.mysql.com/downloads/mysql/
,如下图
点击红框内容,进入历史版本选择5.7版,并选择合适的版本,我选的64位版 。
-
用FTP工具上传服务器
-
解压安装包
-
tar -zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
-
移动并重命名至local文件夹下(可选,任意目录均可)
mv mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql
创建用户组与用户
-
创建用户组
groupadd mysql
-
创建用户
useradd -r -g mysql mysql
修改mysql目录权限
-
cd /usr/local/mysql chown -R mysql mysql/ chgrp -R mysql mysql/
创建配置文件
-
vim /etc/my.cnf
-
复制一下内容,也可自行修改位置
[mysqld] basedir=/user/local/mysql/ datadir=/user/local/mysql/data socket=/var/lib/mysql/mysql.sock port=3306 # Disabling symbolic-links is recommended to prevent assorted security risks 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 sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION [mysqld_safe] log-error=/work/mysql/log/mysqld.log pid-file=/work/mysql/run/mysqld.pid
-
ESC保存退出
:wq!
初始化数据库
-
安装libaio 与 numactl
yum install libaio numactl -y
-
手动生成日志
#手动编辑一下日志文件,什么也不用写,直接保存退出 cd /var/log/ vim mysqld.log :wq
-
设置权限
chmod 777 mysqld.log chown mysql:mysql mysqld.log
-
初始化
cd /usr/local/mysql/bin mysqld --initialize --user=mysql
-
保存密码
-
修改目录权限
chown -R root:root ./ chown -R mysql:mysql data
设置开机启动
-
拷贝mysql服务
cd /usr/local/mysql/support-files cp mysql.server /etc/init.d/mysqld
-
注册开机自启
chkconfig --add mysqld
启动服务
- 启动服务
service mysql start
-
链接socket文件至/tmp/目录下
ln -s /var/lib/mysql/mysql.sock /tmp/
-
添加mysql命令快捷访问
ln -s /usr/local/mysql/bin/mysql /usr/bin/
更新密码
-
使用初始密码登录
mysql -u root -p
-
设置新密码
alter user 'root'@'localhost' identified by '新密码'; flush privileges;
开启远程权限
-
开启root用户远程权限
update user set host='%' where user='root'; flush privileges;
-
创建新用户并开启远程权限
grant all privileges on *.* to '用户名'@'%' identified by '密码' with grant option; flush privileges;
参考:添加用户设置远程
添加系统路径
vim /etc/profile
export PATH=/usr/local/mysql/bin:$PATH
source /etc/profile