|
由于开始对LuManager面板不熟悉,设置了后台限制IP访问,导致访问后台http://ip:8888时会出现“你的ip(...)不能访问,请联系你的服务商”类似提示。
这时候,看起来很难解决这个问题,VNC可以进入,安装myphpadmin也解决不了,ssh可以进入,也无法很好处理。
下面是解决办法:
1、进入mysql管理
[root@localhost bin]# /usr/local/mysql/bin/mysql -u root -p
密码如果是自动安装luManager面板的话,应该是zijidelu.
2、可以试下简单的命令,例如查看现有用户:
- [root@localhost bin]# /usr/local/mysql/bin/mysql -u root -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 14736
- Server version: 5.1.56-log Source distribution
- Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
- This software comes with ABSOLUTELY NO WARRANTY. This is free software,
- and you are welcome to modify and redistribute it under the GPL v2 license
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> select * from mysql.user ;
复制代码 3、关键的当然是查看现有数据库:
- mysql> show databases;
- +---------------------------------+
- | Database |
- +---------------------------------+
- | information_schema |
- | LuManager |
- | #mysql50#LuManager.bak.%Version |
- | 123_com
复制代码
4、我们知道Lumanager是设置保存的数据库,用以下代码查看和修改原有设置:
- mysql> select * from LuMangger.lu_settings;
- ERROR 1146 (42S02): Table 'LuMangger.lu_settings' doesn't exist
- mysql> select * from LuManager.lu_settings;
- +----+---------------+---------------+------------+--------+---------+
- | id | allow_ip | LuManager_GID | api_switch | api_ip | api_key |
- +----+---------------+---------------+------------+--------+---------+
- | 1 | 129.39.146.70 | 1500 | | | |
- +----+---------------+---------------+------------+--------+---------+
- 1 row in set (0.00 sec)
- mysql> use LuManager
- Database changed
- mysql> UPDATE lu_settings SET allow_ip = '';
- Query OK, 1 row affected (0.00 sec)
- Rows matched: 1 Changed: 1 Warnings: 0
- mysql> select * from LuManager.lu_settings;
- +----+----------+---------------+------------+--------+---------+
- | id | allow_ip | LuManager_GID | api_switch | api_ip | api_key |
- +----+----------+---------------+------------+--------+---------+
- | 1 | | 1500 | | | |
- +----+----------+---------------+------------+--------+---------+
- 1 row in set (0.00 sec)
复制代码 罪魁祸首是您在设置中设定了只允许某IP访问你后台,所以导致问题的存在,重新将其设置为空,然后一切太平了。
|
|