下边的是my.cnf (我加了几条,不行又注释掉了) #[client] #port=3306 #socket=/var/lib/mysql/mysql.sock [mysqld] port=3306 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock #set-variable = key_nuffer=16M #set-variable = max_allowed_packet=1[mysql.server] user=mysql basedir=/var/lib[safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid 以下是USER表: --+-------------+-------------+-----------+-------------+---------------+------ -------+-----------+------------+-----------------+------------+------------+ | Host | User | Password | Select_priv | Insert_priv | Update_pr v | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Proce s_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +------------+-------+------------------+-------------+-------------+---------- --+-------------+-------------+-----------+-------------+---------------+------ -------+-----------+------------+-----------------+------------+------------+ | localhost | root | 52e750db38b26a4f | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | info-2000 | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | admin | 52e750db38b26a4f | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | 10.70.13.% | down | 1d782e5a21ec71a4 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | +------------+-------+------------------+-------------+-------------+---------- --+-------------+-------------+-----------+-------------+---------------+------ -------+-----------+------------+-----------------+------------+------------+ 以下是DB: | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete _priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Al ter_priv | +------------+---------+------+-------------+-------------+-------------+------- ------+-------------+-----------+------------+-----------------+------------+--- ---------+ | % | test | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | % | test\_% | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | 10.70.13.% | db_down | down | Y | Y | Y | Y | Y | Y | N | N | N | N |HOST表是空的
你的root@'%' 这条记录在哪里??? 怎么没有? 只有一个root@'info-2000'的纪录,而且也没有设定密码! 所以你当然在远程连部上啊! 加一个root@'%'地记录 用下面的语法: GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;然后使用 set password for root@'%' = password ('your new password'); 来设定新的密码,密码就是引号里面的内容。弄好之后,最好是重新启动以下mysql服务,用mysqld来重启。 一定会成功的!!
把USER, DB, HOST贴出来
#[client]
#port=3306
#socket=/var/lib/mysql/mysql.sock
[mysqld]
port=3306
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#set-variable = key_nuffer=16M
#set-variable = max_allowed_packet=1[mysql.server]
user=mysql
basedir=/var/lib[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
以下是USER表:
--+-------------+-------------+-----------+-------------+---------------+------
-------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_pr
v | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Proce
s_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+------------+-------+------------------+-------------+-------------+----------
--+-------------+-------------+-----------+-------------+---------------+------
-------+-----------+------------+-----------------+------------+------------+
| localhost | root | 52e750db38b26a4f | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
| info-2000 | root | | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
| % | admin | 52e750db38b26a4f | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
| 10.70.13.% | down | 1d782e5a21ec71a4 | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N |
+------------+-------+------------------+-------------+-------------+----------
--+-------------+-------------+-----------+-------------+---------------+------
-------+-----------+------------+-----------------+------------+------------+
以下是DB:
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete
_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Al
ter_priv |
+------------+---------+------+-------------+-------------+-------------+-------
------+-------------+-----------+------------+-----------------+------------+---
---------+
| % | test | | Y | Y | Y | Y
| Y | Y | N | Y | Y | Y
|
| % | test\_% | | Y | Y | Y | Y
| Y | Y | N | Y | Y | Y
|
| 10.70.13.% | db_down | down | Y | Y | Y | Y
| Y | Y | N | N | N | N
|HOST表是空的
怎么没有?
只有一个root@'info-2000'的纪录,而且也没有设定密码!
所以你当然在远程连部上啊!
加一个root@'%'地记录
用下面的语法:
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;然后使用 set password for root@'%' = password ('your new password'); 来设定新的密码,密码就是引号里面的内容。弄好之后,最好是重新启动以下mysql服务,用mysqld来重启。
一定会成功的!!
版本不行,我的是3.23.52,安装方法是装LINUX系统时自动装的,我也不知道是原代码分发还是二进制分发,还有你们除了用TELNET来探测端口以外,还有什么其他命令用来探测端口是否打开,