阿里云centos7 安装mysql

阿里云centos7 安装mysql

过程

1. 下载mysql的repo源

   wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
   sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
   

2. 安装

   yum install mysql-server
   yum install mysql-devel
   yum install mysql
   rpm -qa | grep -i mysql
   

3. 启动mysql

   service mysqld start
   

4. 设置开机启动

   systemctl enable mysqld
   

查看初始密码并修改

1. 打开文件my.cnf，位置在etc/my.cnf

2. 在my.cnf中的[mysqld]之后插入skip-grant-tables

3. 重启mysql服务

   service mysqld restart						
   

4. 输入

   mysql -u rooot -p								
   

   直接登录，密码是空

5. 修改密码操作

   mysql> use mysql;
   
   mysql> show tables;
   
   select user,authentication_string from user;
   update mysql.user set authentication_string=password('123456') where user='root';
   flush privileges;
   exit
   

'123456’即新密码

6. 删掉my.cnf中的skip-grant-tables

7. 重启服务

   service mysqld restart
   

over