linuxmysql远程登录,及用户权限.doc

linux mysql 远程登录，及用户权限 在 windows和 linux 上远程登录时，通常会遇到拒绝连接，密码错误，或者权限不足。以致无法正常的使用数据库，如无法创建数据库，看不到系统数据库 mysql等等。 报错如下。 C:\Users\zouqonemysql -h10.20.5.238 -uroot -p1ERROR 1130 (00000): Host 10.20.5.41 is not allowed to connect to this MySQL server 或者 权限不足，看不到所有的数据库 # mysql -uroot -p1Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 10Server version: 5.5.25a-log MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners. Type help; or \h for help. Type \c to clear the current input statement. mysql show databases;+--------------------+| Database |+--------------------+| information_schema || test |+--------------------+2 rows in set (0.00 sec) 其中 ，mysql，无法看到，但是明显mysql是存在的。 解决方法： 进入数据库，修改系统user表。 # mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.5.25a-log MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners. Type help; or \h for help. Type \c to clear the current input statement. mysql use mysql;Database changed 查看user表结构mysql desc user;+------------------------+-----------------------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+------------------------+-----------------------------------+------+-----+---------+-------+| Host | char(60) | NO | PRI | | || User | char(16) | NO | PRI | | || Password | char(41) | NO | | | || Select_priv | enum(N,Y) | NO | | N | || Insert_priv | enum(N,Y) | NO | | N | || Update_priv | enum(N,Y) | NO | | N | || Delete_priv | enum(N,Y) | NO | | N | || Create_priv | enum(N,Y) | NO | | N | |