1、安装rpm包
获取:wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
安装:sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
2、安装mysql(默认密码为空)
安装:sudo yum install mysql-server
3、登录mysql(有权限问题,使用chown更改mysql文件拥有者)
登录:mysql -u root
报错:(Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'),则修改拥有者:chown root /var/lib/mysql,然后重启:service mysqld restart
4、启动服务
service mysqld start
5、授权root用户可以远程连接。(mysql指令)
有密码:GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "password";
没密码:GRANT ALL PRIVILEGES ON *.* TO root@"%"
6、开放3306端口
如果有防火墙的话,则需要开放3306端口:/sbin/iptables -I INPUT -p tcp --dport 3306-j ACCEPT
7、修改密码
格式:mysql> set password for 用户名@localhost = password('新密码');
例子:mysql> set password for root@localhost = password('123');
登录:mysql -u root -p,回车后输入密码即可。
方式二:直接更新user表
update user set password=password('123') where user='root';
flush privileges; (必须要刷新权限)