Re: Remote Access to MySQL

2015-03-09 Thread patrick
wrote: - Original Message - From: "Rafael Ribeiro" 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 comm

Re: Remote Access to MySQL

2015-03-09 Thread Johan De Meersman
- Original Message - > From: "Rafael Ribeiro" > 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"

Re: Remote Access to MySQL

2015-03-09 Thread Pothanaboyina Trimurthy
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 wrote: > Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro: > >> Hello List, >> >> >> I'm not an expertise on MySQL and we are

Re: Remote Access to MySQL

2015-03-09 Thread Florian Schaal
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 co

Re: Remote Access to MySQL

2015-03-07 Thread Thufir
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:

Remote Access to MySQL

2015-03-07 Thread 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 connect to mysql remotely, from external IPs. I r

Re: Remote access to MySQL

2003-06-21 Thread Nils Valentin
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"

Re: Remote access to MySQL

2003-06-17 Thread gerald_clark
t;[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 12: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

Re: Remote access to MySQL

2003-06-17 Thread Shane Bryldt
"Renato" <[EMAIL PROTECTED]> Cc: "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 p

Re: Remote access to MySQL

2003-06-17 Thread Shane Bryldt
configuration, as I 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, J

Re: Remote access to MySQL

2003-06-17 Thread Primaria Falticeni
ming Digital" <[EMAIL PROTECTED]>; <[EMAIL 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 a

Re: Remote access to MySQL

2003-06-15 Thread Becoming Digital
assword'; Edward Dudlik Becoming 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 connecti

Remote access to MySQL

2003-06-15 Thread Renato
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 perf

Re: Remote access to MySQL

2002-03-16 Thread Thomas Schweikle
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

Remote access to MySQL

2002-03-16 Thread Egor Egorov
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> m

Remote access to MySQL

2002-03-15 Thread Thomas Schweikle
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 ac

Re: Remote access to MySQL with MySQLGUI on Win32

2001-05-22 Thread Sinisa Milivojevic
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 > it

Remote access to MySQL with MySQLGUI on Win32

2001-05-21 Thread Nicolas Verhaeghe
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 p