linux 安装mysql

一、环境

• linux Centos7 64
• mysql

二、过程

1.    安装wget

     # yum install -y wget

2.  安装MySQL  

   # yum install -y mysql-community-server.x86_64

    

3. 启动数据库

   service mysqld start

4. 查看数据库初始密码

    grep 'temporary password' /var/log/mysqld.log 

    
5. 进入数据库

   mysql -u root -p

    
6.  修改远程用户

   grant all privileges on *.* to 'root'@'%' identified by 'root';
   flush privileges;

    

7.  连接时可能报的错误
   1. 2003 can`t connect to mysql server on 'ip' (10060 unknown error)
   2. 解决方法:

      # firewall-cmd --zone=public --add-port=3306/tcp --permanent
      # systemctl restart firewalld.service 

       

8.  连接成功