进入服务器,安装步骤如下:
1:下载mysql安装包,版本自行选择
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2:安装mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm
3:安装mysql
yum install mysql-community-server
4:启动服务
systemctl start mysqld
5:最后一个查看安装成功的默认密码
grep 'temporary password' /var/log/mysqld.log
6:开启 MySQL 远程访问权限
连接数据库
mysql -hlocalhost -uroot -p密码
创建远程连接 MySQL 的用户,root为用户名,@后为适用的主机,‘%’表示所有电脑都可以访问连接,123456密码
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
刷新权限
flush privileges;