mysql 对远程用户进行授权,MYSQL下对远程用户进行连接授权

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)

#对远程用户进行授权

mysql> GRANT ALL PRIVILEGES ON . TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION;

Query OK, 0 rows affected (0.02 sec)

mysql>

#对远程指定IP用户进行授权

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>

#对本机用户进行授权

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

#对127.0.0.1用户进行授权

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;

MYSQL下对远程用户进行连接授权

标签：mysq   type   near   error   ocs   abort   cal   conda   source

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://blog.51cto.com/14130600/2329762