:
- Original Message -
From: Rafael Ribeiro rafaelribeiro...@gmail.com
Subject: Remote Access to MySQL
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to connect to mysql remotely, from external IPs.
It doesn't work is not a helpful comment
- Original Message -
From: Rafael Ribeiro rafaelribeiro...@gmail.com
Subject: Remote Access to MySQL
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to connect to mysql remotely, from external IPs.
It doesn't work is not a helpful comment
Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro:
Hello List,
I'm not an expertise on MySQL and we are facing a strange issue:
We had a Virtual Machine, running CentOS + MySQL 5.0 with IP (1.1.1.1).
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to
and also make sure tcp port of your DB instance has been added to firewall
expeption.
check the iptables for this to verify.
On Mon, Mar 9, 2015 at 2:13 PM, Florian Schaal mailingl...@schaal-24.de
wrote:
Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro:
Hello List,
I'm not an expertise on
Hello List,
I'm not an expertise on MySQL and we are facing a strange issue:
We had a Virtual Machine, running CentOS + MySQL 5.0 with IP (1.1.1.1).
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to connect to mysql remotely, from external IPs.
I
On Sat, 07 Mar 2015 21:49:10 -0300, Rafael Ribeiro wrote:
I read a lot of tutorials and tips without success.
What I need to do, to come back to working configuration like oldest
machine, allowing remote connections?
By no means am I an expert, but, while not specific to your question:
root.
It looks that MySQL remote access is blocked. Can someone suggest me which
variable to add or change in my.cnf file? or I have to change something else
so that I can access MySQL databases from other computers using ODBC
signature.asc
Description: OpenPGP digital signature
Hi
I am running mysql 4 on linux server. I want to have a remote access on it. what are
the setting that i need to do this.
--jatin
http://mcabca.cjb.net
-
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Jatin,
I am running mysql 4 on linux server. I want to have a remote access
on it. what are the setting that i need to do this.
You need to log into your MySQL server and grant access to your
databases from wherever you want to grant access, like:
mysql GRANT ALL ON *.* TO 'remoteuser'@'%'
Hi Renato,
I think you should check once more the right sfor the user you have. Log in to
mysql and do:
mysql SHOW GRANS FOR root ;
You will get something like this:
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '17cb702624900fa5'
Check what it says for the combinaion of username
PROTECTED]
Sent: Tuesday, June 17, 2003 9:11 PM
Subject: RES: Remote access to MySQL
I have all privileges to all the databases and tables, with user
'root'.
User 'root' likely doesn't have access from the desired IP.
Users are configured by both name and approved hosts. Try this:
GRANT ALL
recall it was
something commented out, perhaps the port number if I recall correctly.
-Shane
- Original Message -
From: Renato [EMAIL PROTECTED]
To: Becoming Digital [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 12:11 PM
Subject: RES: Remote access to MySQL
I have
: MySQL LIST [EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 12:42 PM
Subject: Re: Remote access to MySQL
Yes, indeed. You don't have a firewall.
But the firewall from the Internet Service Provider's computer prohibits
the
access of the others users from the Internet to the port of your MySQL
: RES: Remote access to MySQL
I have all privileges to all the databases and tables, with user
'root'.
User 'root' likely doesn't have access from the desired IP.
Users are configured by both name and approved hosts. Try this:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED
I have installed MySQL in Win98SE, with connection ASDL and Fixed IP.
In the same machine, works web server (Apache2+PHP) and e-mail e ftp server.
Everything works perfectly accessing from my INTRANET (local network). I
obtain access to MySQL without problems.
In Internet, all servers works
Digital
www.becomingdigital.com
- Original Message -
From: Renato [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 15 June, 2003 19:28
Subject: Remote access to MySQL
I have installed MySQL in Win98SE, with connection ASDL and Fixed IP.
In the same machine, works web server (Apache2
Thomas,
Friday, March 15, 2002, 11:03:25 PM, you wrote:
TS I want to access various databases on a MySQL server remotely. I've set up
TS an entry in the mysql.user table to allow access to mysql for all hosts
TS in subnet 10.2.107.0/255.255.255.0. First this worked fine. Then my server
TS moved
Hi!
An: [EMAIL PROTECTED]
Kopie:
Thema: Remote access to MySQL
Thomas, show me the output of following statement:
SHOW GRANTS FOR 'your_user'@'your_host';
+--+
| Grants for @10.2.107.0/255.255.255.0
Hi!
I want to access various databases on a MySQL server remotely. I've set up
an entry in the mysql.user table to allow access to mysql for all hosts
in subnet 10.2.107.0/255.255.255.0. First this worked fine. Then my server
moved from address 10.2.107.24 to 10.2.107.204. Now I do not have
Mikel King chortled:
Hi Rich,
Just so I understand you correctly;
1. Are you trying to use the replication features of MySql for
this communication?
Or
2. Are you talking on the client side application, like PHP,
Java, Perl...?
How about encrypting the data
Hi there. I have a need to reach into a remote database and write to their
tables from my tables. Or have them reach into my tables and read from
mine. Either way, data will travel over the net. I need that data secure
and I don't know how I can make that secure. It's not a permissions
Hi Rich,
Just so I understand you correctly;
1. Are you trying to use the replication features of MySql for
this communication?
Or
2. Are you talking on the client side application, like PHP,
Java, Perl...?
How about encrypting the data itself and skipping the
Mikel King chortled:
Hi Rich,
Hey there. Thanks for the response.
Just so I understand you correctly;
1. Are you trying to use the replication features of MySql for
this communication?
Nope.
Or
2. Are you talking on the client side application, like PHP,
Java,
04.02.02 15:11:30, Rich Fortnum [EMAIL PROTECTED] wrote:
Hi there. I have a need to reach into a remote database and write to their
tables from my tables. Or have them reach into my tables and read from
mine. Either way, data will travel over the net. I need that data secure
and I don't know
On Mon, 4 Feb 2002 at 18:06:34 +0100, Andreas Schoelver wrote:
04.02.02 15:11:30, Rich Fortnum [EMAIL PROTECTED] wrote:
Hi there. I have a need to reach into a remote database and write to their
tables from my tables. Or have them reach into my tables and read from
mine. Either way,
Andreas Schoelver chortled:
How about using a VPN (virtual private network) ?
regards
Andreas
sql,select,mysql
I want to minimize the network structure on their part because they will
have a minimal DSL system as they are on the outskirts of town. As well, I
don't want the bulk of the
Marcus Collins chortled:
(sorry; missed the original post)
If you have admin access to both machines, then how about using stunnel
URL:http://www.stunnel.org/ to set up an SSL-encrypted connection
between both machines on the ports on which mysqld communicates?
There's an example for
Nicolas Verhaeghe writes:
I am trying to see if I can communicate with a MySQL on Free BSD from the
MySQL GUI client on my Windows NT.
The GUI client cannot connect because the MySQL seems to be refusing this
connection. This does not seem to be server-related, but related to MySQL
itself,
I am trying to see if I can communicate with a MySQL on Free BSD from the
MySQL GUI client on my Windows NT.
The GUI client cannot connect because the MySQL seems to be refusing this
connection. This does not seem to be server-related, but related to MySQL
itself, since, when I try to telnet in
29 matches
Mail list logo