mysql远程无法登录_Mysql远程账户无法登录处理

1、进入MYSQL

输入命令： mysql -P3306 -uroot -p123456

说明：3306 为端口，root为数据库用户名，123456为数据库密码

成功进入后显示：

Welcome to the MySQL monitor.  Commands end with ; or g.Your MySQL connection id is 4Server version: 5.1.63-log Source distribution

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.

2、查看下数据库

mysql> show databases;

显示：

+--------------------+| Database           |+--------------------+| information_schema || mysql              || test               |+--------------------+3 rows in set (0.00 se

c)

3、使用数据库mysql

mysql> use mysqlDatabase changedmysql> show tables;+---------------------------+| Tables_in_mysql           |+---------------------------+| columns_priv              || db                        || event                     || func                      || general_log               || help_category             || help_keyword              || help_relation             || help_topic                || host                      || ndb_binlog_index          || plugin                    || proc                      || procs_priv                || servers                   || slow_log                  || tables_priv               || time_zone                 || time_zone_leap_second     || time_zone_name            || time_zone_transition      || time_zone_transition_type || user                      |+---------------------------+23 rows in set (0.03 sec)

4、查看下数据库表结构

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       |       || 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       |       || 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       |       || 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_user_priv      | enum('N','Y')                     | NO   |     | N       |       || Event_priv            | enum('N','Y')                     | NO   |     | N       |       || Trigger_priv          | enum('N','Y')                     | NO   |     | N       |       || ssl_type              | enum('','ANY','X509','SPECIFIED') | NO   |     |         |       || ssl_cipher            | blob                              | NO   |     | NULL    |       || x509_issuer           | blob                              | NO   |     | NULL    |       || 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       |       |+-----------------------+-----------------------------------+------+-----+---------+-------+39 rows in set (0.00 sec)

5、查询下记录

mysql> select Host,User,Password from user;+-----------+------+-------------------------------------------+| Host      | User | Password                                  |+-----------+------+-------------------------------------------+| localhost | root | *D62D55684130064FEAE65A809A6FC756F6503C83 |+-----------+------+-------------------------------------------+1 row in set (0.00 sec)

6、直接修改该条记录

mysql> update user set Host='%' where Host='localhost';Query OK, 1 row affected (0.00 sec)Rows matched: 1  Changed: 1  Warnings: 0

7、可以通过远程连接看看，可以用客户端navicat