mysql5.7安装

1、登录mysql官网，下载mysql安装包

http://dev.mysql.com/downloads/mysql/

选择community版本

选择Linux generic

 

以下命令为示例，不能直接使用

2、添加mysql用户和用户组

shell> groupadd mysql

shell> useradd -r -g mysql -s /bin/falsemysql

 

3、解压文件并创建软连接

shell> cd /usr/local

shell> tar zxvf/path/to/mysql-VERSION-OS.tar.gz

shell> ln -sfull-path-to-mysql-VERSION-OS mysql

 

4、对文件授权

shell> cd mysql

shell> mkdir mysql-files

shell> chmod 750 mysql-files

shell> chown -R mysql .

shell> chgrp -R mysql .

 

 

5、安装mysql

shell> scripts/mysql_install_db--user=mysql  # MySQL 5.7.0 to 5.7.4

shell> bin/mysql_install_db--user=mysql     # MySQL 5.7.5

shell> bin/mysqld --initialize--user=mysql    # MySQL 5.7.6 and up

shell> bin/mysql_ssl_rsa_setup             # MySQL 5.7.6 and up

shell> chown -R root .

shell> chown -R mysql data mysql-files

shell> bin/mysqld_safe --user=mysql&

 

6、拷贝服务启动文件到系统默认目录

shell> cp support-files/mysql.server/etc/init.d/mysql.server

 

7、mysql配置文件

[client]

character_set_client=utf8

port=3306

socket=/var/lib/mysql/mysql.sock

 

[mysqld]

port=3306

datadir=/usr/local/mysql/data

socket=/var/lib/mysql/mysql.sock

log-error=/usr/local/mysql/log/mysql.log

pid-file=/usr/local/mysql/log/mysql.pid

lower_case_table_names=1

user=mysql

 

# Disabling symbolic-links is recommendedto prevent assorted security risks

symbolic-links=0

 

 

[mysqld_safe]

socket=/var/lib/mysql/mysql.sock

log-error=/usr/local/mysql/log/mysql.log

pid-file=/usr/local/mysql/log/mysql.pid

time_zone='+8:00'

其中pid和sock文件的路径必须配置指定的路径，否则会使用临时目录，导致服务下次无法启动和停止。

 

8、数据库创建和用户授权

CREATE DATABASE IF NOT EXISTS yourdbnameDEFAULT CHARSET utf8 COLLATE utf8_general_ci;

 

grant all privileges on testDB.* to test@'%' identified by '1234';

flush privileges;

 

use mysql;

select * from user;