rpm安装mysql5.7.17_Mysql必读linux下使用RPM安装mysql5.7.17

《MysqL必读linux下使用RPM安装MysqL5.7.17》要点：

本文介绍了MysqL必读linux下使用RPM安装MysqL5.7.17，希望对您有用。如果有疑问，可以联系我们。

linux下MysqL5.7 rpm安装方式记录,供大家参考,具体内容如下

# rpm -qa | grep -i MysqL

# rpm -ev MysqL-libs-* --nodeps

安装rpm包：

# rpm -ivh MysqL-community-common-5.7.17-1.el7.x86_64.rpm

# rpm -ivh MysqL-community-libs-5.7.17-1.el7.x86_64.rpm

# rpm -ivh MysqL-community-client-5.7.17-1.el7.x86_64.rpm

# rpm -ivh MysqL-community-server-5.7.17-1.el7.x86_64.rpm

启动、停止：

# service MysqLd start

# service MysqLd stop

# service MysqLd status

初始随机密码：

# cat /var/log/MysqLd.log | more

修改初始密码及授权远程访问：

# MysqL -uroot -p

MysqL> set password='Pwd@123456';

MysqL> grant all privileges on *.* to 'root'@'%' identified by 'Pwd@123456';

密码复杂度属性：

MysqL> set global validate_password_policy=0;

validate_password_policy有以下取值：(默认是1,即MEDIUM,所以刚开始设置的密码必须符合长度,且必须含有数字,小写或大写字母,特殊字符.)

修改数据目录：

新目录需要给MysqL用户授权,MysqLd_safe日志文件授权,关闭selinux(没找到相关策略设置的方法)

# mkdir /data/MysqL/data

# mv /var/lib/MysqL/* /data/MysqL/data/

# mkdir /data/MysqL/log

# chown MysqL:MysqL -R /data/MysqL

# touch MysqLd_safe.log

# chown MysqL:MysqL MysqLd_safe.log

# vi /etc/my.cnf

/**

[client]

port = 3306

socket = /data/MysqL/log/MysqL.sock

default-character-set=utf8

[MysqL]

no-auto-rehash

socket=/data/MysqL/log/MysqL.sock

default-character-set=utf8

[MysqLd]

port = 3306

socket = /data/MysqL/log/MysqL.sock

character-set-server=utf8

lower_case_table_names=1

basedir=/usr

datadir=/data/MysqL/data

log-error=/data/MysqL/log/error.log

pid-file=/data/MysqL/log/MysqL.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]

log-error=/data/MysqL/log/MysqLd_safe.log

*/

# getenforce

Enforcing

# setenforce 0

# vi /etc/selinux/config

/**

# This file controls the state of SELinux on the system.

# SELINUX= can take one of these three values:

# enforcing - SELinux security policy is enforced.

# permissive - SELinux prints warnings instead of enforcing.

# disabled - No SELinux policy is loaded.

#SELINUX=enforcing

SELINUX=disabled

# SELINUXTYPE= can take one of these two values:

# targeted - Targeted processes are protected,# mls - Multi Level Security protection.

SELINUXTYPE=targeted

*/

# service MysqLd start

其他命令：

# MysqLadmin -u root -p password

MysqL> select version();

# chkconfig --list

# chkconfig --level 345 MysqLd on

# netstat -na | grep 3306

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持编程之家PHP.

总结

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。

如您喜欢交流学习经验，点击链接加入交流1群：1065694478(已满)交流2群：163560250