linux date -d -2,linux安装mysql5.7

Mysql5.5安装地址：

https://my.oschina.net/u/3896587/blog/3109841

RedHat系统安装Mysql5.7请点击

https://my.oschina.net/u/3896587/blog/3116927

1)本系统采用的是MySQL版本5.7，安装前需检查系统是否安装其他版本的MYSQL，在命令行中输入

rpm -qa|grep mysql

查看 如果有使用

例如：执行rpm -qa|grep mysql后控制台显示MySQL-server-5.5.59-1.el7.x86_64

MySQL-client-5.5.59-1.el7.x86_64

则卸载rpm -e --nodeps MySQL-server-5.5.59-1.el7.x86_64

rpm -e --nodeps MySQL-client-5.5.59-1.el7.x86_64

注意：若删除的时候，出现删除不成功，出现依赖的包，前提必须删除依赖项。

2)创建mysql目录

cd /usr/local

mkdir mysql

3)进入mysql

cd /usr/local/mysql/

4)下载mysql5.7

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

5)解压

tar -xvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz

6)新建data目录

mkdir /usr/local/mysql/data

7)新建mysql用户、mysql用户组

# mysql用户组

groupadd mysql

# mysql用户

useradd mysql -g mysql

8)将/usr/local/mysql的所有者及所属组改为mysql

chown -R mysql.mysql /usr/local/mysql

9)数据库初始化

/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data

如出现如下错误

则使用以下命令：

/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize

# 如果出现以下错误：

/usr/local/mysql/ mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory

# 则执行以下命令：

yum -y install numactl

# 完成后继续安装：

/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize

# 编辑/etc/my.cnf

[mysqld]

datadir=/usr/local/mysql/data

basedir=/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64

socket=/tmp/mysql.sock

user=mysql

port=3306

character-set-server=utf8

# 取消密码验证

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

10)开启服务

# 将mysql加入服务

cp /usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/support-files/mysql.server /etc/init.d/mysql

# 开机自启

chkconfig mysql on

# 启动服务

service mysql start

#查看端口

netstat -tulpn

11)设置密码

# 登录(由于/etc/my.cnf中设置了取消密码验证，所以此处密码任意)

/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p

# 操作mysql数据库

>>use mysql;

# 修改密码

>>update user set authentication_string=password('123456') where user='root';

>>flush privileges;

>>exit;

12)将/etc/my.cnf中的skip-grant-tables删除

13)登录再次设置密码(必要步骤，密码可与上面一致)

/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p

>>ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

>>exit;

14)允许远程连接

/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p

>>use mysql;

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

>>flush privileges;

>>exit;

15)添加快捷方式

ln -s /usr/local/mysql/bin/mysql /usr/bin

16)7.5及以上功能依赖检测功能

/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p

>>use mysql;

>>select @@global.sql_mode;

去掉ONLY_FULL_GROUP_BY修改配置文件my.cnf(在【mysqld】下面添加)

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,

NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,

NO_ENGINE_SUBSTITUTION(去除换行符)

重启数据库service mysql restart

2.1.1 创建数据库

1)创建数据库

使用root账号登录

/usr/local/mysql/mysql-5.7.22-linux-glibc2.12-x86_64/bin/mysql -u root -p

在mysql命令行中输入以下命令创建法人认证数据库

mysql>create database authentification;

2)导入数据库脚本

mysql>use authentification;

mysql>set names utf8;

mysql>source /usr/local/mysql/authentification.sql;( source 脚本路径)