: Tuesday, August 04, 2009 1:09 PM
To: mysql@lists.mysql.com
Subject: Remote connection
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option on my.cnf file however it
doesn't work.
I have tried to include
, 04 de Agosto de 2009 05:09 p.m.
Para: mysql@lists.mysql.com
Asunto: Remote connection
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option on my.cnf file however it
doesn't work.
I have tried
Are you sure that root has granted access to connect remotely ??
Carlos
On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote:
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option on my.cnf
: Tuesday, August 04, 2009 1:09 PM
To: mysql@lists.mysql.com
Subject: Remote connection
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option on my.cnf file however it
doesn't work.
I have tried to include
I have set up a hosting account on godaddy and they have a ridiculously
old version of mysql so I am trying to set it up to use the my server
instead. But it refuses to connect. I can't figure out what could be
the problem. I have tried connecting to my machine from a few other
servers and
Chris, it's somewhat common for hosting companies to restrict outbound
connections like what you describe. They may have a firewall
preventing what you are trying to do.
From your hosting account, can you telnet to your machine on port 3306 ?
I get something like this:
$ telnet 192.168.2.4
I am having inconsistent behavior maintaining a remote connection with MySql
Administrator/Browser. Brand new installations of clients on Windows XP and
MySql server on Windows 2003 server. It worked fine at first then suddenly I
could no longer connect (Error #1045. Access denied for user
Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15 PM:
I am having inconsistent behavior maintaining a remote connection
with MySql Administrator/Browser. Brand new installations of clients
on Windows XP and MySql server on Windows 2003 server. It worked
fine at first then suddenly
Thanks Shawn. It seems to be just that.
[EMAIL PROTECTED] 08/08/05 03:02PM
Kent Roberts [EMAIL PROTECTED] wrote on 08/08/2005 04:50:15
PM:
I am having inconsistent behavior maintaining a remote connection
with MySql Administrator/Browser. Brand new installations of clients
on Windows XP
hi,
i try to access the MySQL server remotely using Command prompet how can i do
so? i mean i want to run all MySQL command on my hosting server
...
_
Dont just search. Find. Check out the new MSN Search!
-
From: Badr Al-Muzini [mailto:[EMAIL PROTECTED]
Sent: Friday, June 24, 2005 11:51 AM
To: mysql@lists.mysql.com
Subject: MySQL Remote Connection?
hi,
i try to access the MySQL server remotely using Command prompet how can
i do so? i mean i want to run all MySQL command on my hosting server
Hello.
Do you have a shell account on that server? Are you
allowed to connect to your server from remote machines (ask support of your
hosting about this).
Badr Al-Muzini [EMAIL PROTECTED] wrote:
hi,
i try to access the MySQL server remotely using Command prompet how can i do
so?
Hello
I am trying to connect from host 192.168.0.8 on my home network to a
database on 192.168.0.7. When I connect as root on 192.168.0.7 itself,
I can do this
mysql show grants for 'root'@'192.168.0.8';
++
| Grants for [EMAIL PROTECTED]
Hi,
haven't you added identified by * int he grant statement.
I don't see it in your show grants comand.
Mathias
Selon Chris Faulkner [EMAIL PROTECTED]:
Hello
I am trying to connect from host 192.168.0.8 on my home network to a
database on 192.168.0.7. When I connect as root on
Hello.
After checking that MySQL server listens on the interface to which you
are connecting, solve network problems. If you're able to connect
from one host to another it doesn't mean that the opposite is true.
Andy McHargue [EMAIL PROTECTED] wrote:
Here's some more data on this,
Hello.
Your server listens only on a single interface. Options could be given
in different ways, not only from configuration file. If you want
MySQL server to listen on every interface you should find where the
bind option is given and remove it. See:
I'm having trouble connecting remotely from Server A (local) to Server B
(remote). Both Linux.
From Server A, I'm issuing this command
mysql -h [domain.com] -u [user] -p
And I get
ERROR 2003: Can't connect to MySQL server on 'domain.com' (110)
I assume this is a time out.
1. The user on Server
Here's some more data on this, if anyone can help.
--I can connect the other way around ... i.e. I can connect from B to
A. So there's no general connectivity problem.
--did an nmap on B,
$ nmap -sT -T Polite -p3306 xx.com
Starting nmap V. 2.54BETA22 ( www.insecure.org/nmap/ )
Interesting
I have mysql version 4.0.15-nt in a server NT, I can
connecting with mysql localy, but when i try remote
connection the error is:
Error Number 2003 Can't connect to MySQL server on
'IP' (10060) .
I use mysql odbc 3.51
Is necesary the file my.cnf in c:\my.cnf
Regards
Gerardo Campos
:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 4:43 PM
To: mysql@lists.mysql.com
Subject: remote connection problem
I have mysql version 4.0.15-nt in a server NT, I can connecting with mysql
localy, but when i try remote connection the error is:
Error Number 2003 Can't connect to MySQL server
, are
you sure that your remote connection can see the NT server? This may be a
bigger problem, i.e. DNS or IP routing/access lists.
You may also want to check the hostname.err logs on the MySQL server to
see if there is a connection problem there.
J.R.
-Original Message-
From: gerardo
sec)
If the value is ON, you won't be allowed to make connections to the
server via TCP/IP.
On Tue, 2005-03-22 at 15:43 -0600, gerardo Villanueva wrote:
I have mysql version 4.0.15-nt in a server NT, I can
connecting with mysql localy, but when i try remote
connection the error is:
Error
Not necessary to change my.cnf, unless --skip-networking was specified.
Also assuming that you are using port 3306.
mysql show variables like 'port';
+---+---+
| Variable_name | Value |
+---+---+
| port | 3306 |
+---+---+
1 row in set
You can try SQLyog (www.webyog.com), it supports
3.23.x to 5.0.
Lightweight and very fast!
Karam
--- [EMAIL PROTECTED] wrote:
Good good.
On 24 Feb 2005, at 20:46,
[EMAIL PROTECTED] wrote:
BINGO!!!
Thanks Dan!
Kelly
Daniel Walker [EMAIL PROTECTED]
What version of MySQL
Hello,
I have downloaded Toad for MySQL to give it a test run. MySQL 4.1.10 is
on Redhat AS 2.1 and Toad for MySQL is on Win XP. Everytime I attempt to
connect via Toad, I get the following error:
Unable to connect to the database.
Host 'XX.XX.XX.XX' is not allowed to connect to this MySQL
Good good.
On 24 Feb 2005, at 20:46, [EMAIL PROTECTED] wrote:
BINGO!!!
Thanks Dan!
Kelly
Daniel Walker [EMAIL PROTECTED]
What version of MySQL are you using? 4.1.1 uses an enhanced password
hashing system that isn't compatible with clients built for older
versions.
This page on
I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs
correctly (it is a slave member of my domain). But if I try to connect from
a remote client with mysql administrator, I receive this error:
Could not connect to the specified instance
Mysql error number 1130
Host name is not
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Access_denied.html
Massimo Petrini [EMAIL PROTECTED] wrote:
I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs
correctly (it is a slave member of my domain). But if I try to connect from
a remote client with mysql
Hi All
Could someone give me a clue or a snippet of PHP code I can test a romte
connection to my MySQL DB for my website please?
Thank you
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All
Could someone give me a clue or a snippet of PHP code I can test a romte
connection to my MySQL DB for my website please?
Just take the one you're currently using and replace 'localhost' with
'someotherserver.com'
$cnx = mysql_connect('someotherserver.com','uname','pword');
Hi all!
I'm connecting from one server (192.168.0.2; 4.1.1-alpha-log) to another
server (192.168.0.1; 4.1.0-alpha-log) like this:
# mysql -h192.168.0.1 -uusername -ppassword
But all I get is:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 82 to server
Business
-Original Message-
From: Curtis Maurand [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: remote connection
Its a permissions thing on the server end. You have to have set up a
user
account
-
From: Curtis Maurand [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: remote connection
Its a permissions thing on the server end. You have to have set up a
user
account on the server. Very important are hostnames
Business
-Original Message-
From: Curtis Maurand [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: remote connection
Its a permissions thing on the server end. You have to have set up a
user
account
I'm trying to set up a remote connection to a mysql database using Perl
DBI. I have done this without problem on another database. I suspect the
rights are set up differently on this one. I have root access.
When I try to connect, I get the following error (hostname, username,
password have been
Its a permissions thing on the server end. You have to have set up a user
account on the server. Very important are hostnames.
Curtis
John Almberg said:
I'm trying to set up a remote connection to a mysql database using Perl
DBI. I have done this without problem on another database. I
when i try to connect to my mysql database from another machine i get a
error like this
%mysql -h domain.com -u tellus
ERROR 2003: Can't connect to MySQL server on 'domain.com' (61)
The port don't listen
and this is disabled in my.cfg
#
#skip-networking
whats wrong and how do i allow remote
At 22:55 +0200 10/4/03, Ms Carlsson wrote:
when i try to connect to my mysql database from another machine i
get a error like this
%mysql -h domain.com -u tellus
ERROR 2003: Can't connect to MySQL server on 'domain.com' (61)
The port don't listen
Apparently the MySQL server on domain.com is not
I can connect to MySQL through JDBC with the following URL without any
problem:
jdbc:mysql://localhost:3306/mydatabase
However, when I simulate the above URL as though I'm calling from a remote
machine using the following URL,
jdbc:mysql://192.168.0.10:3306/mydatabase
I got the following exception
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Erwin Adi wrote:
I can connect to MySQL through JDBC with the following URL without any
problem:
jdbc:mysql://localhost:3306/mydatabase
However, when I simulate the above URL as though I'm calling from a remote
machine using the following URL,
Hi List,
I'm a newby at MySql. I've setup a server for use with Bugzilla but I am
also trying to connect to an other database on that server. Each time as I
try to connect I get
ERROR 2013: Lost connection to MySQL server during query.
Is there a setting I must change to be allowed to logon
Version: 4.0.8, installed from the RPMs downloaded from the mysql.com
webpages. The server runs RedHat 8.0, all updates installed. The hardware
is a Dell 2650.
Problem: Any connection, using the command line client for example, from
any other node fails even though the access should be allowed.
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using the
following code for simple remote
=
DriverManager.getConnection(jdbc:mysql://localhost/myTable, username, password);
Works like a charm. Give it a try...
-Pete
-Original Message-
From: Muhammad Salman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 11:36
To: [EMAIL PROTECTED]
Subject: Remote Connection
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Muhammad Salman wrote:
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
first a note: this is a topic best discussed on
[EMAIL PROTECTED]
* On Thu, Dec 12, 2002 at 08:35:40AM -0800, Muhammad Salman wrote:
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
Subject: Remote Connection, please help
I am using the official type 4 mysql driver from
www.mysql.com but unable to make a remote connection
with the mysql database running on our companie's
remote server. I mailed some mailing mailing lists but
didnt find out the right answer yet. I am using
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Muhammad Salman wrote:
Dear Mark, real thanks , Are you refering to this
issues:
Issue:
When I try to connect to the database with MySQL
Connector/J , I get the
following exception:
Yes.
[snip]
Thanks Mark for your real quick response.
On Wed, Dec 04, 2002 at 12:21:06PM -0500, Jason Hall wrote:
I have a problem here.
I cannot connect to a particular server remotely at certain times.
I get the error remote connection is blocked because of many
connection errors. I can login locally on the box.
Ok.
To resolve
I have a problem here.
I cannot connect to a particular server remotely at certain times. I get
the error
remote connection is blocked because of many connection errors. I can login
locally on the box.
To resolve this problem i would run FLUSH HOST and i can connect remotely.
But say about
I have a few servers running MySQL and regularly (almost every web page!)
connect from one to the other to update or query a remote database. I have
never had any problems (love that mySQL) until I upgraded one of the systems
and re-loaded the websites etc.
Now, when I try to connect to the new
-To-Repeat:
Connect from another computer on the internet. Use the mysql
client. This syntax does it for us:
mysql -hhostname -ppassword
Fix:
Unknown
Submitter-Id: W_DW
Originator:root
Organization:
sqlcoders
MySQL support: none
Synopsis: Remote connection crash server (also
On Fri, Nov 08, 2002 at 10:25:01PM -0500,
[EMAIL PROTECTED] [EMAIL PROTECTED] is thought to have said:
Description:
MySQL crashes when a remote computer attempts to make a standard
connection. Making a local connection does not cause this problem,
connecting to other systems does not
I would like to know if this is at all possible using MySQL 4.0.4 in
Windows.
We want to be able to host our web site using either Windows and ASP or
Linux and PHP in our service provider server. All the scripts will be in
their machine away from our network. Then I would like for those
-
From: Ronald Petty [EMAIL PROTECTED]
To: Stefan Kuss [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 10:59 PM
Subject: Re: Remote Connection Probem
Try this
telnet yourmachine 3306
If you do not get something like
Trying yourmachine
Conneced to yourmachine
Escape
, October 08, 2002 11:04 AM
To: Ronald Petty
Cc: [EMAIL PROTECTED]
Subject: Re: Remote Connection Probem
Thanks for your response.
I tried to connect to the server via telnet as you suggested
with the following result.
telnet my.machine.ip 3306
Trying my.machine.ip...
Connected
Hi,
I am running MySQL 3.23 on Redhat 8.0. I can connect to MySQL from the local
machine without any problem and I created a user with remote login
privileges. Trying to connect to it from another machine (on the same
network as well as the same subnet) gives ERROR: 10061 Connection to mysql
will be sitting next to you in the holding cell, laughing and saying
-'That was fucking awesome!'
-Original Message-
From: Stefan Kuss [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 7:41 PM
To: [EMAIL PROTECTED]
Subject: Remote Connection Probem
Hi,
I am running MySQL 3.23
Hello,
I'm having a problem connecting to a remote MySQL database and was
hoping someone could give me a pointer on where to look. Both machines
are running Red Hat Linux 7.2 and MySQL version 3.23.52. I have it
compiled and running succesfully on each machine as long as I log in to
the database
Hi Gokce,
You can check the following (especially the second one);
1. Make sure that you have provided a password to root account on the server
box;
grant all on * to 'root'@'%' identified by 'your_root_password';
% here means that you can login to your server box as root from
Dear all
check this new tool at
http://amr.activechannel.net
http://amr.activechannel.net/setup.zip
SQL server users will love it , same query analyzer but more powerful
Amr Salah
_
Get your FREE, Private email today - [EMAIL
I am new with mysql. I have the latest version installed on a win2k =
machine. I am trying to access mysql DB from another machine. It =
returns invalid username/password, but if i connect locally with the =
same login info it connects fine. What do i have to do to allow any =
remote host
Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Lee Connell [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 13, 2002 9:05 AM
To: [EMAIL PROTECTED]
Subject: remote connection/users
I am new with mysql. I have the latest version installed
Hi,
Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I
can connect to a remote MySQL database.
I have tried putting an IP address in that I found by lookup of the
domain name, and I entered the database name and password, but I get an
error saying connection from
There are other windows front ends to mysql, but this one is the best:
http://ems-hitech.com/mymanager/
Are you sure the server allows remote connections?
Ken
Charles McGrotty wrote:
Hi,
Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I
can connect to a remote MySQL
Hi,
How do I configure mysql so that it will accept remote connections because I
get the error message Host 192.168.1.253 is not allowed to connect to this
MySQL Server
Can someone help me with this.
Delz
-
Before posting,
Your problem is probably due to not having a grant entrry in the user table
that allows your user name to log in from 192.168.1.253.
Try GRANTing either that IP, or all IP's (%) access with that user name.
This link should help you out.
http://www.mysql.com/doc/G/R/GRANT.html
Cary
At
Hello,
Can anybody provide input on commandline tool on solaris to connect to
mysql server running on linux. And possibly configuring procedure if any
involved.
Thanks,
Prabhu
---
Beauty is bought by judgement of the eye.
Hown do I connect to a MySql database that is outside the firewall with
mysqlgui?
Jens Erik
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi everybody,
I've installed MySQL 3.23.38 on a RedHat 6.0 system with php 3.0.18.
When I want to connect to the server with phpMyAdmin, it returns the following message
:
Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
a remote connection is made. Any
clues? If so, please send a CC to my email address. TIA :-]
- anatole
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
I'm trying to use a remote telnet connection to access a mysql
server. Anyone know where I could find protocols to connect to
a mysql server, with telnet? Thanks.
Bob Feldbauer
[EMAIL PROTECTED]
-
Before posting, please
72 matches
Mail list logo