由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Cannot connect to the mysql server insid
相关主题
MySQL: cannot connectMySQL向远程服务器的查询是明文传输的吗?
getting connected to Oracle in PerlHow to know which database I am connected?
Recover postgresql 的问题求救,咋样架起来自己的database?
MySQLinstall mysql
mysql high hand please help!!!!how to deny a user to use mysql
help: questions about MySqlanonymous login in mysql?
Problem in installing DBI?2 questions on MySQL privileges
MySQL configuration file in windows?Help: 如何在oracle 9i 中添加1 个user?
相关话题的讨论汇总
话题: mysql话题: connect话题: server话题: machine话题: client
进入Database版参与讨论
1 (共1页)
e********t
发帖数: 3
1
Hi, I have intalled MySQL on one of my computer and try to access it using
another machine inside the same LAN. Some info about the setup:
* The MySQL server's IP is 192.168.0.3 while the client machine is 192.168.0.6
* Both machine running WinXP Pro
* On the client machine, I am using PHPED's embedded MySQL support to try to
access the database on the server.
But it keeping telling me that I can not connect the server, and I have tried
the following things which didn't work:
* Add host address
c**t
发帖数: 2744
2
Co-ask:
mysql is installed on FC2; tried to use DBI to access the db.
can't connect to it.
Is there any port needed be opened on FC2?

【在 e********t 的大作中提到】
: Hi, I have intalled MySQL on one of my computer and try to access it using
: another machine inside the same LAN. Some info about the setup:
: * The MySQL server's IP is 192.168.0.3 while the client machine is 192.168.0.6
: * Both machine running WinXP Pro
: * On the client machine, I am using PHPED's embedded MySQL support to try to
: access the database on the server.
: But it keeping telling me that I can not connect the server, and I have tried
: the following things which didn't work:
: * Add host address

c**t
发帖数: 2744
3
Starting nmap 3.50 ( http://www.insecure.org/nmap/ ) at 2004-10-27 20:12 CDT
Interesting ports on localhost.localdomain (127.0.0.1):
(The 1648 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE
22/tcp open ssh
3306/tcp open mysql
my $dbh = DBI->connect("DBI:mysql:database=mydb;
host=192.168.0.10;port=3306",
"root", "",
{'RaiseError' => 1});

【在 c**t 的大作中提到】
: Co-ask:
: mysql is installed on FC2; tried to use DBI to access the db.
: can't connect to it.
: Is there any port needed be opened on FC2?

c**t
发帖数: 2744
4
Host ... is not allowed to connect to this MySQL server
You can fix this by setting up an account for the combination of client
hostname and username that you are using when trying to connect. If you
don't know the IP number or hostname of the machine from which you are
connecting, you should put an entry with '%' as the Host column value in
the user table and restart mysqld with the --log option on the server
machine. After trying to connect from the client machine, the information in
the MySQL
c**t
发帖数: 2744
5
Summary:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username@client_pc_ip' IDENTIFIED BY
'password';
the you can use username, password to connect back from the client_pc.

【在 c**t 的大作中提到】
: Host ... is not allowed to connect to this MySQL server
: You can fix this by setting up an account for the combination of client
: hostname and username that you are using when trying to connect. If you
: don't know the IP number or hostname of the machine from which you are
: connecting, you should put an entry with '%' as the Host column value in
: the user table and restart mysqld with the --log option on the server
: machine. After trying to connect from the client machine, the information in
: the MySQL

1 (共1页)
进入Database版参与讨论
相关主题
Help: 如何在oracle 9i 中添加1 个user?mysql high hand please help!!!!
[转载] connect mysql remotelyhelp: questions about MySql
问个问题: Can't connect to MySQL server on 'dbhost' (10061) ( 2003 )Problem in installing DBI?
求助:SQL SETUP过程中的问题MySQL configuration file in windows?
MySQL: cannot connectMySQL向远程服务器的查询是明文传输的吗?
getting connected to Oracle in PerlHow to know which database I am connected?
Recover postgresql 的问题求救,咋样架起来自己的database?
MySQLinstall mysql
相关话题的讨论汇总
话题: mysql话题: connect话题: server话题: machine话题: client