systems.com.br]
Sent: 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'
systems.com.br]
Sent: 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 w
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 fi
, 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.
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 the bind_address = 0.0.0.0 but it still doesn't
work. Sure I have commented the s
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 33
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 t
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/Bro
"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 wor
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
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
ver.
-Original Message-
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
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!
http://sear
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
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]
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:
http://dev.mysql.com/doc/mysql/en/pr
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,
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 po
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 B
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 (0.0
1 row in set (0.00 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 remo
your error message says that you cannot see the 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 .err logs on the MySQL server to
see if there is a connection problem there.
J.
:[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
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
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 vers
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 MyS
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 s
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 mysq
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 allo
> 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');
mysql_s
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!
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 vers
uilding You A Better Online Business
<><><><><><><><><><><><><><><><><><><><><><><><>
-Original Message-
From: Curtis Maurand [mailto:[EMAIL PROTEC
<>
>Visit us at: www.identry.com
>Building You A Better Online Business
> <><><><><><><><><><><><><><><><><><><><><><><><>
>
>
;><><><><><><><><><><><><><><><><><><>
Visit us at: www.identry.com
Building You A Better Online Business
<><><><><><><><><><&g
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
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
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 r
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 con
-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,
jdbc:mysq
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
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 from
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. T
-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 quic
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
-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
>
-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 ou
, 2002 11:36
To: [EMAIL PROTECTED]
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
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 r
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.
&g
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 sy
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 doe
mysqld restarted
>How-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
>S
David Lloyd wrote:
How do you mean not able to "see it"? Under the control panel there
should be an "ODBC Data Source Administrator"...
(mysql, query)
DSL
The driver is not listed in the driver. I cannot select
it from the list of drivers as it is not there.
Jerry
Jerry,
> I have some questions on using ODBC with My SQL.
:-)
> I have a MySQL on on an ISPs database server. I'd like to
> pull data from it into Excel. It appears that I need to
> use ODBC to do this. Do the server need to have ODBC
> installed or do I just need it installed on the PC I wa
I have some questions on using ODBC with My SQL.
I have a MySQL on on an ISPs database server. I'd like to
pull data from it into Excel. It appears that I need to
use ODBC to do this. Do the server need to have ODBC
installed or do I just need it installed on the PC I want
to connect from?
I
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 scripts
Kuss [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 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 follow
al Message -
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
of jail...but a true friend
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]
>
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
ser
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
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 PR
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 a
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
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 to
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 M
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 ~db_name~@~
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 08:59
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,
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 arch
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) i
d what is going on when 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
You don't.
You can use telnet to connect and run mysql on that machine, displaying
on yours.
You can use mysql on your machine to connect to mysqld on the remote
machine using the -h
option to mysql. This requires that the grant command has been run on
the server to allow you to connect, and tha
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 check:
Hi,
I am using the MySQL server and it's myodbc_mysql client programme.
When i connect to the local machine, it works perfectly. But i don't
know how do i connect to remote machine when using it in pure ODBC
fashion.
--
Available way is like follwi
78 matches
Mail list logo
