CentOS RPM安装MySQL 5.6修改默认密码

来源：互联网发布：计算机性能测试软件编辑：程序博客网时间：2024/06/07 19:02

01cd /usr/local/src02wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.13-1.el6.x86_64.rpm03wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.13-1.el6.x86_64.rpm04 05#安装之前应该先查询系统是否自在了mysql的软件包 rpm -qa|grep -i mysql06#如果有的话需要先删除 rpm -e 软件名 --nodeps07 08rpm -ivh MySQL-server-5.6.13-1.el6.x86_64.rpm09rpm -ivh MySQL-client-5.6.13-1.el6.x86_64.rpm10 11 12#安装后生成的一个随机密码在 /root/.mysql_secret13#启动 MySQL14service mysql start15 16#登录mysql17mysql -u root -p18 19#修改密码20SET PASSWORD=password('password');21 22#添加一个可远程登录的帐号23GRANT all privileges on *.* TO 'root'@'%' identified by 'password' WITH GRANT OPTION;24FLUSH PRIVILEGES;25#修改密码26SET PASSWORD FOR 'root'@'%' = PASSWORD('password');27 28 29#########################################30 31#可运行此脚本 进行生产服务器安全配置32/usr/bin/mysql_secure_installation33 34 35#Enter current password for root  输入root密码36#Change the root password?  是否修改root的密码37#Remove anonymous users?  是否删除匿名账号38#Disallow root login remotely?  是否取消root用户远程登录39#Remove test database and access to it?  是否删除test库和对test库的访问权限40#Reload privilege tables now?  是否现在刷新授权表使修改生效

原文转自云栖社区

阅读全文

0 0