linux安装mysql5.7自己初始化_linux系统安装mysql5.7步骤

1.下载mysql压缩文件，地址

https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz

2.将压缩文件上传到服务器home文件夹下

3.解压mysql到此文件夹

命令：tar -zxvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz -C /usr/local/mysql

4.创建一个mysql用户和组

命令：groupadd mysql

useradd mysql -g mysql

5.创建文件夹并授权

命令：mkdir /data/mysql

chown mysql:mysql -R /data/mysql

6.在/etc目录下创建my.cnf文件，并进行配置：

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

basedir=/usr/local/mysql

datadir=/data/mysql

socket=/tmp/mysql.sock

user=mysql

port=3306

character-set-server=utf8mb4

# cancle password

# skip-grant-tables

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# skip-grant-tables

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

7.配置mysql参数 (注意，控制台输出信息有临时密码)

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

8.把启动脚本放到开机初始化目录

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

9.开启数据库服务

service mysql start

service mysql stop --关闭

service mysqld restart  --重启

10.修改密码及允许远程连接

/usr/local/mysql/bin/mysql -u root -p  (输入临时密码)

>>use mysql;

>>update user set authentication_string=password('你的密码') where user='root';  或者  ALTER USER USER() IDENTIFIED BY '你的密码';

>>update user set host='%' where user = 'root';

>>flush privileges;

>>exit;

11.如没有域名远程连接时需要设置  my.cnf 的mysqld模块加一句  skip-name-resolve