一:实验环境
服务器端IP:192.168.1.9
客户端IP:192.168.1.3
二:实验目的
允许192.168.1.3这台机器以xiaohong这个用户访问,密码为xiaohong.
--注意:这个xiaohong用户可以在客户端不存在。
三:实验步骤
3.1 在服务器端执行
mysql> grant all privileges on *.* to 'xiaohong'@'192.168.1.3' identified by 'xiaohong';
Query OK, 0 rows affected (0.00 sec)
--这就相当于在mysql.user表里添加了一条记录:
| host | user |
+-------------+----------+
| 192.168.1.3 | xiaohong |
3.2 在客户端远程连接
C:\Users\dandan>mysql -u xiaohong -p -h 192.168.1.9 Enter password: ******** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 Server version: 5.6.20 MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rig Oracle is a registered trademark of Oracle Corporation and/or i affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current i --可以执行语句进行验证……