1. MySQL 5.7 版本的首次登陆
(1)利用yum命令安装了MySQL后,因为5.7 的安全性增强,所以首次登陆需要密码,启动命令:
sudo service mysqld start
(2)初始化的密码在mysql.log 里,利用命令进行查看:
# cat /var/log/mysqld.log | grep "temporary password"
2016-04-08T15:10:00.920194Z 1 [Note] A temporary password is generated for root@localhost: yP(DO;EM&2CY
(3)首次登陆命令:
mysql -uroot -p'yP(DO;EM&2CY'
(4)首次登陆后立即更改密码:
mysql> SET PASSWORD=PASSWORD('Root1234@');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
来自:http://blog.itpub.net/29773961/viewspace-2077579/
2. 允许远程访问
(1)登陆mysql,用命令更改:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
说明:例如,你想root使用123456从任何主机连接到mysql服务器。
mysql>GRANT ALL PRIVILEGES ON *.* TO 'jack'@’10.10.50.127’ IDENTIFIED BY '654321' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES
说明:如果你想允许用户jack从ip为10.10.50.127的主机连接到mysql服务器,并使用654321作为密码
来自:http://www.cnblogs.com/cnblogsfans/archive/2009/09/21/1570942.html
也可参考:http://www.cnblogs.com/XL-Liang/archive/2012/05/03/2481310.html
更加详细,请直接看MySQL文档:https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html