MYSQL下如何實(shí)現(xiàn)與遠(yuǎn)程用戶連接授權(quán)

下文主要給大家?guī)?lái)MYSQL下如何實(shí)現(xiàn)與遠(yuǎn)程用戶連接授權(quán)，希望這些內(nèi)容能夠帶給大家實(shí)際用處，這也是我編輯MYSQL下如何實(shí)現(xiàn)與遠(yuǎn)程用戶連接授權(quán)這篇文章的主要目的。好了，廢話不多說(shuō)，大家直接看下文吧。

Last login: Sat Jun 25 21:57:19 2011 from 172.16.0.56
[root@localhost ~]# /usr/bin/mysqladmin -u root password 123456
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[root@localhost ~]#
[root@localhost ~]# ls
anaconda-ks.cfg           Desktop      install.log.syslog
BAK20110625.bash_profile  install.log
[root@localhost ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 187
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.03 sec)

mysql> ls    
-> show databases;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ls
show databases' at line 1
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| func                      |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| proc                      |
| procs_priv                |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
17 rows in set (0.00 sec)

mysql> select * from host;
Empty set (0.00 sec)

mysql> select from host
-> select from host;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select from host' at line 2
mysql> select from host;
Empty set (0.00 sec)

mysql> update user set host = '%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 1
mysql> ls
-> show tables;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ls
show tables' at line 1
mysql> ls show tables;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ls show tables' at line 1
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.01 sec)

mysql> update user set host = '%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 1
mysql> update user set host = '%' where user = 'root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 1
mysql> Aborted
[root@localhost ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 194
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql> show tables;
ERROR 1046 (3D000): No database selected
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| func                      |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| proc                      |
| procs_priv                |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
17 rows in set (0.00 sec)

#對(duì)遠(yuǎn)程用戶進(jìn)行授權(quán)

mysql> GRANT ALL PRIVILEGES ON . TO 'myuser'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected (0.02 sec)

mysql>

#對(duì)遠(yuǎn)程指定IP用戶進(jìn)行授權(quán)
mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'172.16.0.62' IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql>

#對(duì)本機(jī)用戶進(jìn)行授權(quán)

GRANT ALL PRIVILEGES ON . TO root@localhost IDENTIFIED BY '123456' WITH GRANT OPTION;

#對(duì)127.0.0.1用戶進(jìn)行授權(quán)

GRANT ALL PRIVILEGES ON . TO root@127.0.0.1 IDENTIFIED BY '123456' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON . TO root@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

對(duì)于以上關(guān)于MYSQL下如何實(shí)現(xiàn)與遠(yuǎn)程用戶連接授權(quán)，大家是不是覺(jué)得非常有幫助。如果需要了解更多內(nèi)容，請(qǐng)繼續(xù)關(guān)注我們的行業(yè)資訊，相信你會(huì)喜歡上這些內(nèi)容的。