-
[root@localhost ~]# cd /usr/local/src/
-
[root@localhost src]# wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
-
[root@localhost src]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm
-
[root@localhost src]# yum -y install mysql-server
默认配置文件路径:
配置文件:/etc/my.cnf
日志文件:/var/log/var/log/mysqld.log
服务启动脚本:/usr/lib/systemd/system/mysqld.service
socket文件:/var/run/mysqld/mysqld.pid
不过安装完成后,密码为随机密码,需要重置密码。
4. 启动mysql服务
service mysqld restart
重置密码
[root@localhost ~]# grep "password" /var/log/mysqld.log
输入初始密码即可登陆数据库,然后需要重新设置密码,至少包含大写,小写字母,数字和符号。
alter user 'root'@'localhost' identified by 'password'; 填入自己要设置的密码
先新建一个用户,root
create user 'root'@'%' identified by 'password';
设置数据库登陆用户权限
grant all privileges on *.* to 'root'@'%' with grant option;
刷新权限
flush privileges;