Score:0

Change bin-address on mysql ubuntu 18.04

sk flag

I'm trying to change the bin-address of my localhost database instance on a ubuntu 18.04 computer

i went to /etc/mysql/mysql.conf.d and then modified the file mysqld.cnf to assign the ip address i want 192.168.0.100.

From bind-address = 127.0.0.1 to bind-address = 192.168.0.100

When i try telnet 192.168.1.100 3306 after a while is see this message

telnet: Unable to connect to remote host: Connection refused;

Is this the best approach to change the ip address of my localhost instance?

Christopher Martinez avatar
sk flag
From bind-address = 127.0.0.1 to `bind-address = 192.168.0.100`
Michael Hampton avatar
cz flag
Seems reasonable. What is in MySQL's log?
in flag
What does Log show, and does `netstat -anp | grep 3306` show you it is in `LISTEN` state?
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.