CentOS RPM安装MySQL-5.6
时间:2016-10-18 16:16 来源:linux.it.net.cn 作者:IT
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)
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) |