MySQL IP is old

Ask questions about dedicated servers here and we and other users will do our best to answer them. Please also refer to the self-help section for tutorials and answers to the most commonly asked questions.
Post Reply
Jamy
A semi-regular
A semi-regular
Posts: 17
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Thu Nov 14, 2013 3:36 am

MySQL IP is old

Post by Jamy »

Hello,

About a week ago, we removed an IP. We did have two, but the one we removed was connected to the MySQL database. When the IP was removed, the MySQL is still using the that old IP.

I thought that using localhost instead of the IP would use the one it is using, but it doesn't work, and when I use the old IP for connecting things up the the database, it works.

Thanks in advance
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: MySQL IP is old

Post by soja »

Using 0.0.0.0 binds to all available ip addresses. Make sure you have manually removed the ip from your network configuration.

Do you keep the ip until your paid time is up?
Not a NFO employee
Jamy
A semi-regular
A semi-regular
Posts: 17
Joined: Thu Nov 14, 2013 3:36 am

Re: MySQL IP is old

Post by Jamy »

soja wrote: Do you keep the ip until your paid time is up?
The IP is completely gone already.
Jamy
A semi-regular
A semi-regular
Posts: 17
Joined: Thu Nov 14, 2013 3:36 am

Re: MySQL IP is old

Post by Jamy »

Ok, I found out that I have to change things in the interfaces file, but do i just remove the old IP listing and it will automatically change the old IP of the MySQL to the new one?
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: MySQL IP is old

Post by soja »

Unless you bind mysql to that IP specifically, it should work.

You might need to restart networking to apply the changes. Be careful when doing this on a dedi, a VDS should be fine. I would just reboot it.
Not a NFO employee
Jamy
A semi-regular
A semi-regular
Posts: 17
Joined: Thu Nov 14, 2013 3:36 am

Re: MySQL IP is old

Post by Jamy »

soja wrote:Unless you bind mysql to that IP specifically, it should work.
What do you mean by this exactly. How would I have "bound" it if I have?
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: MySQL IP is old

Post by soja »

Not a NFO employee
Post Reply