您好,欢迎来到花图问答。
搜索
您的当前位置:首页centos 6.5 安装mysql5.7

centos 6.5 安装mysql5.7

来源:花图问答

Step1: 检测系统是否自带安装mysql

# yum list installed | grep mysql

Step2: 删除系统自带的mysql及其依赖命令:

# yum -y remove mysql-libs.x86_64

Step3: 给CentOS添加rpm源,并且选择较新的源命令:

# wget  yum localinstall mysql-community-release-el6-5.noarch.rpm# yum repolist all | grep mysql# yum-config-manager --disable mysql55-community# yum-config-manager --disable mysql56-community# yum-config-manager --enable mysql57-community-dmr# yum repolist enabled | grep mysql

Step4:安装mysql 服务器命令:

# yum install mysql-community-server

Step5: 启动mysql命令:

# service mysqld start

Step6: 查看mysql是否自启动,并且设置开启自启动命令:

# chkconfig --list | grep mysqld# chkconfig mysqld on

Step7:设置防火墙

iptables -I INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT  
/etc/init.d/iptables save  
chkconfig mysqld on  

Step8:查看root用户密码

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

Step9:使用root登陆

mysql -u root -p 'password'

Step10:修改密码复杂度

set global validate_password_policy=0; 

Step11:修改root密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

Step12:设置mysql root 远程访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

Copyright © 2019- huatuowenda.com 版权所有 湘ICP备2023022495号-1

违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务