CentOS下安装环境安装(2)-----mysql

CentOS下安装环境安装(2)-----mysql

系统环境

• CentOS 6.9
• MySQL 5.6.25

1.卸载系统自带mysql

• 1.1检查是否安装了mysql

  rpm -qa |grep mysql

• 1.2卸载

  rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64

• 一步到位

  rpm -e --nodeps $(rpm -qa |grep mysql)

2. 上传mysql或者直接在线下载mysql文件

3.解压安装

cd mysql 
rpm -ivh *.rpm

4.启动mysql

service mysql start

5.查看mysql初始密码

cat /root/.mysql_secret
# The random password set for the root user at Mon Jul 23 23:39:24 2018 (local time): 3BwgPfmuGCIPISFc   //随机密码

6.登陆mysql修改密码

mysql -uroot -p3BwgPfmuGCIPISFc //明文登陆

7.修改密码

mysql> SET PASSWORD = PASSWORD('新的密码');

8.授权远程登录

mysql> grant all privileges on *.* to 'root' @'%' identified by '上面设置的密码'; 
mysql> flush privileges;

9.添加msyql到开机启动

//添加到开机启动项
chkconfig --add mysql
//开机启动
chkconfig mysql on
//检查是否添加成功
chkconfig