0

Has anybody else had a error message like this in webmin?

Failed to save MySQL server options : Missing or invalid IP address to listen on
terdon
  • 100,812
Sam
  • 1
  • I understand that but its kind of rude that you just jump on peoples post and start making changes without giving them the reason first :/ – Sam Apr 24 '17 at 14:00
  • But I added the text as well. Im not looking to argue but it would be nice to be told why the change has been made the first time, instead of just making the change and not explaining why. – Sam Apr 24 '17 at 14:02
  • I didnt disagree I just said it was rude that I was told, I actually was thinking I was doing something wrong but had no idea what. – Sam Apr 24 '17 at 14:03
  • Please read this: https://askubuntu.com/help/editing. And take it up on https://meta.askubuntu.com/ if you disagree with how this site works. Again: no. Comments are also NOT for discussions. – Rinzwind Apr 24 '17 at 14:04
  • You're quite right that edits with no explanation are confusing. Sorry about that! In this case, the edit is done to conform with site policy as explained here. We prefer text over screenshots since i) it is searchable; ii) it can be copied; iii) it takes less time to load and iv) it can be read by screen readers and so be accessible to blind users. – terdon Apr 24 '17 at 14:15
  • Thank you for being more understanding Terdon :) il keep that in mind for the future. – Sam Apr 24 '17 at 14:21

1 Answers1

2

Edit the /etc/mysql/my.cnf file to configure the basic settings such as TCP/IP port, IP address binding, and other options. In Ubuntu 16.10, which you are using (see Problems with the modification of Apache2), the MySQL database server configuration file is located at /etc/mysql/mysql.conf.d/mysqld.cnf. To edit it open the terminal and type:

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

The instructions for using nano editor are always found at the bottom of every page. The only two nano keyboard shortcuts that you need to know are for WriteOut and Exit. Press the keyboard combination Ctrl+O and after that press Enter to save the file being edited. Press the keyboard combination Ctrl+X to exit nano.

Then restart the MySQL server:

sudo systemctl restart mysql.service
karel
  • 114,770