mysql5.7Windows安装和Linux安装手册

---

windows下安装

---

配置文件

[mysqld]


port = 3306


basedir=C:/software/mysql-5.7.21-winx64


datadir=C:/software/mysql-5.7.21-winx64/data


max_connections=200


character-set-server=utf8


default-storage-engine=INNODB


sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES


[mysql]
default-character-set=utf8

安装

mysqld --install MySQL --defaults-file="D:\JavaSoft\mysql-5.6.40-winx64\my.ini"

修改密码

update mysql.user set password=PASSWORD('root') where User='root'; # 修改
flush privileges; # 刷新权限

linux下安装

rpm -qa | grep mysql

rpm -e --nodeps mysql-community-libs-compat-5.7.17-1.el6.x86_64 mysql-community-common-5.7.17-1.el6.x86_64 mysql-community-server-5.7.17-1.el6.x86_64 mysql-community-libs-5.7.17-1.el6.x86_64 mysql-community-client-5.7.17-1.el6.x86_64

rpm -qa | grep mariadb
rpm -e --nodeps mariadb-5.7.17-1.el6.x86_64

find / -name mysql

关闭setenforce

setenforce 0

tar xvf mysql-5.7.17-1.el6.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-libs-compat-5.7.17-1.el6.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-5.7.17-1.el6.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-common-5.7.17-1.el6.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-5.7.17-1.el6.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-5.7.17-1.el6.x86_64.rpm --nodeps --force

ln -s /复制目录/mysql/mysql.sock /var/lib/mysql/mysql.sock
查看初始化密码

grep 'temporary password' /var/log/mysqld.log

mv /var/lib/mysql /data/mysql/data/
chown mysql:mysql -R /data/mysql

vi /etc/init.d/mysqld

systemctl daemon-reloa

vi /etc/my.cnf

[client]
port = 3306
socket = /data/mysql/data/mysql.sock
default-character-set=utf8




[mysql]
user = mysql
no-auto-rehash
socket=/data/mysql/data/mysql.sock
default-character-set=utf8




[mysqld]
user = mysql
port = 3306
socket = /data/mysql/data/mysql.sock
character-set-server=utf8
lower_case_table_names=1
basedir=/data/mysql
datadir=/data/mysql/data
log-error=/data/mysql/log/error.log
pid-file=/data/mysql/mysqld.pid
init_connect='SET NAMES utf8'
symbolic-links=0




skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M




[mysqld_safe]
user = mysql
log-error=/data/mysql/log/mysqld.log

mysql -uroot -p
#输入密码后，在mysql>执行，修改默认密码
set password=‘Admin$123456’;
grant all privileges on . to ‘root’@’%’ identified by ‘Admin$123456’;
quit

#设置开机自启
运行命令：chkconfig --add mysqld
运行命令: chkconfig --level 345 mysqld on