Check your border router access list.
Patrick Sherrill
patr...@coconet.com
Coconet Corporation
SW Florida's First ISP
(239) 540-2626 Office
(239) 770-6661 Cell
Confidentiality Notice. This email message, including any attachments,
is for the sole use of the intended recipient(s) and may cont
- 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 comment :-) What error mess
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
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
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:
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"
Shane Bryldt wrote:
Just a thought, what about encryption of passwords? Shouldn't it be:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD('password');
No, it should not.
Not sure if that is related to the problem, but it may cause an invalid
password error.
However, your probl
"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
Just a thought, what about encryption of passwords? Shouldn't it be:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD('password');
Not sure if that is related to the problem, but it may cause an invalid
password error.
However, your problem is most likely similar to the problem
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
server. Or you are in a private network which must use IP port forwarding to
be reached from the Internet. Talk
> 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 BY 'password';
Edward Dudlik
Becoming Dig
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
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
13 matches
Mail list logo
