当前位置 博文首页 > 蜗牛为梦想而生H:Linux相关操作-安装MySQL
??
mkdir /opt/mysql -p?
cd ?/opt/mysql ?
mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar-其它文档类资源-CSDN下载
tar -xvf mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar
rpm -qa|grep mariadb
rpm -e mariadb包全名 --nodeps?? ???
rpm -ivh mysql-community-common-5.7.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.20-1.el7.x86_64.rpm
yum install -y perl-Module-Install.noarch
yum install net-tools
rpm -ivh mysql-community-server-5.7.20-1.el7.x86_64.rpm
service mysqld start
或者?
systemctl start mysqld.service
vi /var/log/mysqld.log
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
SET GLOBAL validate_password_policy=0;//修改密码策略为最低
?? ?
SET GLOBAL validate_password_length=4;//设置四位数密码比如root
#mysql表示数据库,并且安装时自带的数据库,不需要你创建?
use mysql;
update user set host='%' where user = 'root';
flush privileges;
设置端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重启防火墙
systemctl restart firewalld.service
或者
?? ?
关闭防火墙 ?
systemctl stop firewalld.service
开机禁用防火墙
systemctl disable firewalld.service