vagrant ssh 虚拟机名字
su root
password:vagrant
修改配置:
vi /etc/ssh/sshd_config
将以下配置改为yes
PermitRootLogin yes
PasswordAuthentication yes
安装wget
1、yum -y install wget
2、wget http://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm
3、sudo rpm -ivh mysql80-community-release-el7-1.noarch.rpm
安装MySQL 服务
4、sudo yum install mysql-server
检查是否MySQL开机自启
systemctl list-unit-files|grep mysqld
查看MySQL是否启用
ps -ef|grep mysql
启动MySQL服务
systemctl start mysqld.service
初始化MySQL(其实初始化并没有成功,原因是文件夹无权限)
mysqld --initialize
查看MySQL 初始默认密码
grep ‘temporary password’ /var/log/mysqld.log
root’@'localhost 后面为默认密码
此时登录会出现下面错误:
查看MySQL状态
service mysqld status
错误原因是文件夹权限,应作以下修改:
查看日志报错
cat /var/log/mysqld.log
查找文件路径
find / -name ibdata1
授予文件夹权限
chmod -R 777 /var/lib/mysql
chown mysql:mysql -R /var/lib/mysql
启动MySQL
systemctl start mysqld.service
查看MySQL状态
systemctl status mysqld.service
可以登录了,使用默认密码登陆后,修改密码。
alter user ‘root’@‘localhost’ identified by ‘12345678’;
修改该用户可以远程连接
update user set host = ‘%’ where user = ‘root’;
flush privileges;