Shulou(Shulou.com)06/01 Report--

The following mainly brings you how to realize the authorization of connecting with remote users under MYSQL. I hope these contents can bring you practical use. This is also the main purpose of this article on how to realize the authorization of connecting with remote users under MYSQL. All right, don't talk too much nonsense, let's just read the following.

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.01sec)

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)

# authorize remote users

Mysql > GRANT ALL PRIVILEGES ON. TO 'myuser'@'%' IDENTIFIED BY' 123456 'WITH GRANT OPTION

Query OK, 0 rows affected (0.02 sec)

Mysql >

# authorize remote designated IP users

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 >

# authorize local users

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

# authorize 127.0.0.1 users

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

For the above about how to achieve the authorization of connecting with remote users under MYSQL, do you think it is very helpful? If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.