检查一下云系统的更新
yum -y update
下载安装包
rpm -ivh http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
安装mysql
`
yum install -y mysql-serve
`
设置开机启动mysql
`systemctl enable mysql.service`
检查是否加入开机自启动
systemctl list-unit-files | grep mysqld
查看mysql默认的密码,如何你找不到这个文件,可以看一下我另一篇博文
grep 'temporary password' /var/log/mysqld.log
登录mysql
mysql -u root -p
如何输入密码,这里的密码是不可见的,输入完直接回车就行
修改密码
SET PASSWORD = PASSWORD('123456');
或者
ALTER USER USER() IDENTIFIED BY '123456';
如果
sql服务器密码可能会过期,例如如下报错
You must reset your password using ALTER USER statement before
executing this statement