linux里mysql远程登录,linuxmysql远程登录

《linuxmysql远程登录》由会员分享，可在线阅读，更多相关《linuxmysql远程登录(12页珍藏版)》请在人人文库网上搜索。

1、实用标准文案 linux mysql 远程登录，及用户权限 在 windows和 linux 上远程登录时，通常会遇到拒绝连接，密码错误，或者权限不足。以致无法正常的使用数据库，如无法创建数据库，看不到系统数据库 mysql等等。 报错如下。 C:Userszouqonemysql -h10.20.5.238 -uroot -p1 ERROR 1130 (00000): Host 10.20.5.41 is not allowed to connect to this MySQL server 或者 权限不足，看不到所有的数据库 # mysql -uroot -p1 Welcome to th。

2、e MySQL monitor. Commands end with ; or g. Your MySQL connection id is 10 Server 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 its affiliates. Oth。

3、er names may be trademarks of their respective owners. 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 -p。

4、 Enter password: Welcome to the MySQL monitor. Commands end with ; or g. 精彩文档实用标准文案 Your MySQL connection id is 2 Server 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 Corporati。

5、on and/or its affiliates. Other names may be trademarks of their respective owners. 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 |。

6、 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) | 。

7、NO | | N | | | Drop_priv | enum(N,Y) | NO | | N | | | Reload_priv | enum(N,Y) | NO | | N | | | Shutdown_priv | enum(N,Y) | NO | | N | | | Process_priv | enum(N,Y) | NO | | N | | | File_priv | enum(N,Y) | NO | | N | | | Grant_priv | enum(N,Y) | NO | | N | | | References_priv | enum(N,Y) | NO | | N | 。

8、| | Index_priv | enum(N,Y) | NO | | N | | | Alter_priv | enum(N,Y) | NO | | N | | | Show_db_priv | enum(N,Y) | NO | | N | | | Super_priv | enum(N,Y) | NO | | N | | | Create_tmp_table_priv | enum(N,Y) | NO | | N | | | Lock_tables_priv | enum(N,Y) | NO | | N | | | Execute_priv | enum(N,Y) | NO | | N |。

9、 | | Repl_slave_priv | enum(N,Y) | NO | | N | | | Repl_client_priv | enum(N,Y) | NO | | N | | | Create_view_priv | enum(N,Y) | NO | | N | | | Show_view_priv | enum(N,Y) | NO | | N | | 精彩文档实用标准文案 | Create_routine_priv | enum(N,Y) | NO | | N | | | Alter_routine_priv | enum(N,Y) | NO | | N | | | Create。

10、_user_priv | enum(N,Y) | NO | | N | | | Event_priv | enum(N,Y) | NO | | N | | | Trigger_priv | enum(N,Y) | NO | | N | | | Create_tablespace_priv | enum(N,Y) | NO | | N | | | ssl_type | enum(,ANY,X509,SPECIFIED) | NO | | | | | ssl_cipher | blob | NO | | NULL | | | x509_issuer | blob | NO | | NULL | |。

11、 | x509_subject | blob | NO | | NULL | | | max_questions | int(11) unsigned | NO | | 0 | | | max_updates | int(11) unsigned | NO | | 0 | | | max_connections | int(11) unsigned | NO | | 0 | | | max_user_connections | int(11) unsigned | NO | | 0 | | | plugin | char(64) | YES | | | | | authentication_s。

12、tring | text | YES | | NULL | | +-+-+-+-+-+-+ 42 rows in set (0.00 sec) 查看所有用户 精彩文档实用标准文案 mysql select host ,user,password,Process_priv from user; +-+-+-+-+ | host | user | password | Process_priv | +-+-+-+-+ | % | root | *E6CC90B878B948C35E92B003C792C46C58C4AF40 | Y | | ytc | root | *E6CC90B878B948。

13、C35E92B003C792C46C58C4AF40 | Y | | 127.0.0.1 | root | *E6CC90B878B948C35E92B003C792C46C58C4AF40 | Y | | :1 | root | *E6CC90B878B948C35E92B003C792C46C58C4AF40 | Y | | ytc | | *E6CC90B878B948C35E92B003C792C46C58C4AF40 | N | | localhost | root | *E6CC90B878B948C35E92B003C792C46C58C4AF40 | Y | +-+-+-+-+。

14、 6 rows in set (0.00 sec) host 为% 的是所有网址都可访问数据， 为 localhost是本地登录 精彩文档实用标准文案 这两个是必须的。 其他的host是特殊名登录限于本地 如 修改root 权限： 删除原来的host 为%, localhost 的记录 插入 两条记录。 INSERT INTO user VALUES (localhost, root, *E6CC90B878B948C35E92B003C792C46C58C4AF40, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y,。

15、 Y, Y, Y, Y, Y, Y, Y, Y, , , , , 0, 0, 0, 0, , ); INSERT INTO user VALUES (%, root, *E6CC90B878B948C35E92B003C792C46C58C4AF40, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, Y, , , , , 0, 0, 0, 0, , ); 重启服务 # service mysql.server restart Shutting down MySQL . * S。

16、tarting MySQL . * 精彩文档实用标准文案 linux 本地登录 # mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 Server version: 5.5.25a-log MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle。

17、 is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type help; or h for help. Type c to clear the current input statement. mysql show databases; +-+ | Database | +-+ | information_schema | | mysql | | performance_schema | 。

18、| test | 精彩文档实用标准文案 +-+ 4 rows in set (0.00 sec) 远程登录 C:Userszouqonemysql -h10.20.5.238 -uroot -p1 Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 3 Server version: 5.5.25a-log MySQL Community Server (GPL) Type help; or h for help. Type c to clear the buffer. mysql show databases; +-+ | Database | +-+ | information_schema | | mysql | | performance_schema | | test | +-+ 4 rows in set (0.00 sec) 精彩文档。