CentOS RPM安装MySQL-5.6

cd /usr/local/src  wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.13-1.el6.x86_64.rpm wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.13-1.el6.x86_64.rpm   #安装之前应该先查询系统是否自在了mysql的软件包 rpm -qa|grep -i mysql #如果有的话需要先删除 rpm -e 软件名 --nodeps   rpm -ivh MySQL-server-5.6.13-1.el6.x86_64.rpm rpm -ivh MySQL-client-5.6.13-1.el6.x86_64.rpm      #安装后生成的一个随机密码在 /root/.mysql_secret  #启动 MySQL  service mysql start    #登录mysql  mysql -u root -p   #修改密码  SET PASSWORD=password('password');    #添加一个可远程登录的帐号  GRANT all privileges on *.* TO 'root'@'%' identified by 'password' WITH GRANT OPTION;  FLUSH PRIVILEGES; #修改密码 SET PASSWORD FOR 'root'@'%' = PASSWORD('password');     #########################################    #可运行此脚本 进行生产服务器安全配置  /usr/bin/mysql_secure_installation      #Enter current password for root  输入root密码  #Change the root password?  是否修改root的密码  #Remove anonymous users?  是否删除匿名账号  #Disallow root login remotely?  是否取消root用户远程登录  #Remove test database and access to it?  是否删除test库和对test库的访问权限  #Reload privilege tables now?  是否现在刷新授权表使修改生效   (责任编辑：IT)

转载于:https://www.cnblogs.com/jpfss/p/7422107.html