linux下mysql数据库的安装

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