一、环境
- linux Centos7 64
- mysql
二、过程
- 安装wget
# yum install -y wget
- 安装MySQL
# yum install -y mysql-community-server.x86_64
- 启动数据库
service mysqld start
- 查看数据库初始密码
grep 'temporary password' /var/log/mysqld.log
- 进入数据库
mysql -u root -p
- 修改远程用户
grant all privileges on *.* to 'root'@'%' identified by 'root'; flush privileges;
- 连接时可能报的错误
- 2003 can`t connect to mysql server on 'ip' (10060 unknown error)
- 解决方法:
# firewall-cmd --zone=public --add-port=3306/tcp --permanent # systemctl restart firewalld.service
- 连接成功