How to fix an open vulnerability in Oracle MySQL 7.1, the latest version of the company’s MySQL database management system

By default, Oracle MySQL will log you out of the MySQL console if you open it to access its security settings page.

That’s fine, and you can disable this behaviour by editing the MySQL.ini file in your home directory.

This file will be located in the root of the current directory on the server and can be found in the /etc/mysql directory on all Unix-based systems.

Open that file and add the following line:  [mysql] login_password = admin login_host = 127.0.0:9200 password_alg = SHA1 password_file = /etc.dbname