It´s working.
The problem was related to grant permission.
Thank you.
Cheers,
Hugo
-Mensagem original-
De: Gavin Towey [mailto:gto...@ffn.com]
Enviada em: terça-feira, 4 de agosto de 2009 19:46
Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com
Assunto: [SPAM] RE: Remote
1.) remove bind-address= and skip-networking from my.cnf
2.) grant permission to the external 'user'@'host'
3.) remove any firewall rules blocking port 3306
4.) make sure no overrides on the mysqld commandline.
See http://hashmysql.org/index.php?title=Remote_Clients_Cannot_Connect
If you cont
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
May not have root access to remotely!
Try to reconfigure the parameters of the engine.
although it is not good idea to allow remote access to the root user!.
Greetings,
Pablo
-Mensaje original-
De: Hugo Leonardo Ferrer Rebello [mailto:hugo.rebe...@t-systems.com.br]
Enviado el: Martes, 0
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
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
> o
"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 s
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.
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
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
One other thing to check, make sure --skip-networking isn't specified in
your configuration.
mysql> show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
| skip_networking | OFF |
+-+---+
1 row in set (0.00
R.
-Original Message-
From: gerardo Villanueva [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 5:03 PM
To: [EMAIL PROTECTED]
Subject: RE: remote connection problem
1.- Yes I have a firewall but the port 3306 is open
2.- Mysql is running in the server
3.- I connecting with use
1) Are you running a firewall? If so, make sure that port 3306 is open.
2) Is your MySQL server is up and running?
3) Do you have the correct permissions to connect to the server via your
mysql.hosts table?
Just some thoughts.
J.R.
-Original Message-
From: gerardo Villanueva [mailto:[E
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
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
> 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
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 database. I susp
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
-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
-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 using
-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
> with the m
-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 the ri
I've never connected your way before. I'm using J/Connector from the MySQL site
(http://www.mysql.com/downloads/api-jdbc-stable.html). That way I have no problems
connecting. I do it this way:
// connect to the database
Class.forName("com.mysql.jdbc.Driver");
Connection dbConnection =
Drive
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 this p
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
I have the exact same problem. Nothing has changed other than I upgraded
from RH7.3 to RH8.0. I've tried at least five (5) different mySQL
windows clients and all refuse to connect. However I can use phpMyAdmin
locally (via web) and also all my web based database pages work fine
too. I've tried ad
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
Check the docs on GRANT. Sounds like you have an incorrect host. Either
set the host to % on your current record (manually and then FLUSH
PRIVILEGES) or figure out the hostname from the machine you are trying to
connect from and grant yourname@hostname the necessary privileges.
=C=
*
* Cal Eva
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
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
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
39 matches
Mail list logo
