产品服务AMH 免费服务器主机面板SSL证书 免费SSL证书申请 担保单 免费安全、零费率交易平台编程助手免费智能写代码、翻译AMYSQL 免费MySQL管理工具

AMH 社区首页

 AMH社区 - 开放自由有价值的社区

[求助帖] 我的后台root怎么找不到用户呢?见下图

早起的鸡儿
铁牌会员
63.00 价值分

早起的鸡儿 发表于 2014-11-20 22:51:04
怎么会这样。,该怎么解决。


2014-11-20 22:51:04 1

7683002
银牌会员
1695.49 价值分

你删除了?
  支持 (0分)  反对 (0分)
回复  2014-11-21 11:22:12 2

早起的鸡儿
铁牌会员
63.00 价值分

没有啊。如果删除了。怎么可能登陆呢?
  支持 (0分)  反对 (0分)
回复  2014-11-21 14:08:49 3

早起的鸡儿
铁牌会员
63.00 价值分

引用:
7683002 发表于 2014-11-21 11:22
你删除了?


没有啊。如果删除了。怎么可能登陆呢?
  支持 (0分)  反对 (0分)
回复  2014-11-21 14:09:05 4

xyy666
银牌会员
1013.00 价值分

select * from user;试试
  支持 (0分)  反对 (0分)
回复  2014-11-21 15:43:21 5

早起的鸡儿
铁牌会员
63.00 价值分

引用:
xyy666 发表于 2014-11-21 15:43
select * from user;试试


mysql> select * from user;
+-----------+------+-------------------------------------------+-------------+----- --------+-------------+-------------+-------------+-----------+-------------+------ ---------+--------------+-----------+------------+-----------------+------------+-- ----------+--------------+------------+-----------------------+------------------+- -------------+-----------------+------------------+------------------+------------- ---+---------------------+--------------------+------------------+------------+---- ----------+------------------------+----------+------------+-------------+--------- -----+---------------+-------------+-----------------+----------------------+------ --+-----------------------+
| Host | User | Password | Select_priv | Inse rt_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutd own_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | A lter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_pr iv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Tri gger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_sub ject | max_questions | max_updates | max_connections | max_user_connections | plugi n | authentication_string |
+-----------+------+-------------------------------------------+-------------+----- --------+-------------+-------------+-------------+-----------+-------------+------ ---------+--------------+-----------+------------+-----------------+------------+-- ----------+--------------+------------+-----------------------+------------------+- -------------+-----------------+------------------+------------------+------------- ---+---------------------+--------------------+------------------+------------+---- ----------+------------------------+----------+------------+-------------+--------- -----+---------------+-------------+-----------------+----------------------+------ --+-----------------------+
| localhost | root | *E5D907fdsfadsfsdfsadfsdfasdf56BA2E | N | N | N | N | N | N | N | N | N | N | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | | NULL |
+-----------+------+-------------------------------------------+-------------+----- --------+-------------+-------------+-------------+-----------+-------------+------ ---------+--------------+-----------+------------+-----------------+------------+-- ----------+--------------+------------+-----------------------+------------------+- -------------+-----------------+------------------+------------------+------------- ---+---------------------+--------------------+------------------+------------+---- ----------+------------------------+----------+------------+-------------+--------- -----+---------------+-------------+-----------------+----------------------+------ --+-----------------------+
1 row in set (0.00 sec)

mysql>
  支持 (0分)  反对 (0分)
回复  2014-11-21 15:46:55 6

7683002
银牌会员
1695.49 价值分

引用:
早起的鸡儿 发表于 2014-11-21 14:09
没有啊。如果删除了。怎么可能登陆呢?


phpmyadmin
  支持 (0分)  反对 (0分)
回复  2014-11-22 11:46:16 7

xyy666
银牌会员
1013.00 价值分

| localhost | root | *E5D907fdsfadsfsdfsadfsdfasdf56BA2E | N | N | N | N | N | N
  支持 (0分)  反对 (0分)
回复  2014-11-23 09:02:49 8
 1  (总1页)
AMH社区列表
用户服务中心