环境:centos7(阿里云vps)
mysqld 5.7.27
先检查系统是否装有mysql,如果返回空值,说明没有安装MySQL;
[root@localhost ~]# rpm -qa | grep mysql
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm包
[root@localhost ~]# yum -y install mysql-community-server
安装成功后,启动
systemctl start mysqld.service
进行登录
mysql -u root -p password
发现并不清楚mysql的默认密码
需要重置密码
首先配置mysql的免密登录,修改etc/my.cnf
去掉注释:#skip-grant-tables
重启mysqld
systemctl restart mysqld.service
登录mysql
mysql -u root
修改etc/my.cnf,关闭免密登录,
重启mysqld
systemctl restart mysqld.service