Can't start MySQL when bound to private ip

243
May 31, 2017, at 06:39 AM

My vps is on Linode. For example's sake, let's say my public IP is x.x.x.x and my private IP is y.y.y.y/Z. In my.cnf, if I set

bind-address = x.x.x.x

and restart MySQL, everything is fine and works just fine. However, if I do

bind-address = y.y.y.y

MySQL is unable to start back up at all. Is there some step I'm skipping?

READ ALSO
MySQL-Update inserted auto increment primary key to custom value

MySQL-Update inserted auto increment primary key to custom value

When I insert a new row, an auto increment ID will be saved like 1,2,3I need to custom it using a Trigger so it will be saved like 20171,20172,20173

313
Adding DELETE CASCADE to established foreign constraints

Adding DELETE CASCADE to established foreign constraints

I'm working on a project and just realized that I needed to add "DELETE CASCADE" on all the foreign key constraintsThanks to this post I was able to list all of them and find out that there are over 20 constraints to update

213
MySQL: How to join data from 2 MySQL tables into 1 single HTML table

MySQL: How to join data from 2 MySQL tables into 1 single HTML table

I have two MySQL tables that are basically in these formats:

246
Creating SSIS package for XML file for required data in Database

Creating SSIS package for XML file for required data in Database

Developers, I am working on SSIS and I want to create package to populate the XMLdata in the database from an XML source file and my source file sample data is here:

249