\n
sandbox\u6267\u884cgrant\u8bed\u53e5\u603b\u662f\u62a5\u9519\u3002<\/h3>\n
mysql [localhost] {msandbox} (mysql) > grant all on *.* to banqz;
\r\nERROR 1045 (28000): Access denied for user 'msandbox'@'localhost' (using password: YES)<\/p>\r\n\r\n
\u00a0<\/p>\r\n\r\n
mysql [localhost] {msandbox} (mysql) > select user,host from user;
\r\n+-------------+-----------+
\r\n| user \u00a0 \u00a0 \u00a0 \u00a0| host \u00a0 \u00a0 \u00a0|
\r\n+-------------+-----------+
\r\n| root \u00a0 \u00a0 \u00a0 \u00a0| % \u00a0 \u00a0 \u00a0 \u00a0 |
\r\n| msandbox \u00a0 \u00a0| 127.% \u00a0 \u00a0 |
\r\n| msandbox_ro | 127.% \u00a0 \u00a0 |
\r\n| msandbox_rw | 127.% \u00a0 \u00a0 |
\r\n| rsandbox \u00a0 \u00a0| 127.% \u00a0 \u00a0 |
\r\n| banqz \u00a0 \u00a0 \u00a0 | 192.% \u00a0 \u00a0 |
\r\n| msandbox \u00a0 \u00a0| localhost |
\r\n| msandbox_ro | localhost |
\r\n| msandbox_rw | localhost |
\r\n+-------------+-----------+
\r\n9 rows in set (0.00 sec)<\/p>\r\n\r\n
\u53e6\u5916\uff0c\u5982\u679c\u80fd\u8ba9root\u7528\u6237\u767b\u5f55\u5230sandbox\u91cc\u9762\u7684mysql\uff1f<\/p>\r\n\r\n
[root@DATA-TEST m****_5_6_36]# .\/use -uroot -p
\r\nEnter password:\u00a0
\r\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)<\/p><\/p>\n <\/div>\n