shell> systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
Active: active (running) since 五 2016-06-2404:37:37 CST; 35min ago
Main PID: 2888 (mysqld)
CGroup: /system.slice/mysqld.service
└─2888 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid6月 2404:37:36 localhost.localdomain systemd[1]: Starting MySQL Server...
6月 2404:37:37 localhost.localdomain systemd[1]: Started MySQL Server.
shell> mysql -uroot-p
mysql> Enter password: Q2>r4=l-DWIP
1
2
修改默认密码
mysql> SET PASSWORD = PASSWORD('root');
# 上面的root是你的新密码
1
2
6.允许root远程登录
mysql> GRANT ALL PRIVILEGES ON*.*TO'root'@'%' IDENTIFIED BY'123@asdf'WITH GRANT OPTION;
mysql> flush privileges;
1
2
第一句中”%”表示任何主机都可以远程登录到该服务器上访问。如果要限制只有某台机器可以访问,将其换成相应的IP即可,如: GRANT ALL PRIVILEGES ON . TO root@”172.168.193.25” IDENTIFIED BY “123@asdf”; 123@asdf是登录密码。 第二句表示从mysql数据库的grant表中重新加载权限数据。因为MySQL把权限都放在了cache中,所以在做完更改后需要重新加载。