1.下载mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
2.在/usr/local中新建mysql,将mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz上传到mysql中
3.解压tar -zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz
4.重命名mv tar -zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz mysql
5.创建mysql用户组及用户
groupadd mysql
useradd -r -g mysql mysql
6.修改my.cnf,vi /etc/my.cnf
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
skip-name-resolve
basedir=/usr/local/mysql/mysql
datadir=/usr/local/mysql/mysql/data
character-set-server=utf8
#socket=/var/lib/mysql/mysql.sock
socket=/tmp/mysql.sock
user=mysql
lower_case_table_names=1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
port=3306
[mysqld_safe]
open-files-limit=8192
[mysql]
no-auto-rehash
#socket = /var/lib/mysql/mysql.sock
socket=/tmp/mysql.sock
default-character-set=utf8
safe-updates
7.初始化数据
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql --datadir=/usr/local/mysql/mysql/data
在/usr/local/mysql/mysql下生成data文件夹
8.在mysql当前目录下设定目录的访问权限
chown -R mysql .
chgrp -R mysql .
chown -R root .
chown -R mysql data
9.将/usr/local//mysqlmysql/support-files/mysql.server文件复制到/etc/init.d/mysql中,更改mysql文件
cp /usr/local/mysql/mysql/support-files/mysql.server /etc/init.d/mysql
10.重启mysql
在/usr/local/mysql/mysql/support-files/mysql.server下,./mysql.server restart
11.登录mysql
在/usr/local/mysql/mysql/bin下 ./mysql -uroot -p 可以在安全模式下免密登录
12.修改登录密码后保存,退出,去除免密登录
update user set host = ‘%’ where user =‘root’ and authentication_string=‘win2000onmuicc’;
flush privileges;
quit;
13.设置远程连接
use mysql;
update db set host = ‘%’ where user = ‘用户名’; 若无法更改,则需要进行别的操作
flush privileges;
quit;
14.将mysql中的数据与系统分开存放
修改Mysql数据库的默认存放路径:
停止 mysql的服务
建立目标存放目录:mkdir /home/data
使用命令拷贝文件:cp -R /usr/local/mysql/mysql/data /home/data
修改MySQL配置文件:/etc/my.cnf,vi /etc/my.cnf
把其中的datadir更改为新的路径 datadir=/home/data
修改MySQL启动脚本 /etc/init.d/mysql
重启mysql