You can change it as per your requirement.Ĭopy those SQL queries and save it to a new file mysql_secure_installation.sql. In the above example, we have set root password as ‘root’. You can modify these lines as per your requirements. Lastly, we issue FLUSH PRIVILEGES to apply changes. Next DELETE command removes access to test database. Next DELETE command disabled remote root logins. Next DELETE command disables anonymous users. It is basically a set of SQL queries to be executed by mysql_secure_installation to make your installation secure. UPDATE er SET Password=PASSWORD(' root') WHERE User='root' ĭELETE FROM er WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1') ĭELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%' Here you will find the following SQL queries. Please note, it will have a space after do_query not a ( which indicates a function. Look for the line that starts with do_query. It is located in mysql/scripts/mysql_secure_installation.sh. First of all take a backup of the mysql_secure_installation script on your system. In this case, we basically open the original mysql_secure_installation to find the lines that run SQL queries and copy them to another file, which we will execute later. There are a couple of ways to automate this script. Enter current password for root (enter for none): Here’s the default list of prompts you get to see on your screen when you run mysql_secure_installation, along with sample user inputs.
Mysql_secure_installation is basically a script that gets executed when you call the command on your terminal.
#Hostbuddy mysql scripts how to
How to Automate mysql_secure_installation Script In this article, we will learn how to automate mysql_secure_installation script in Linux. But answering these prompts can be tedious every time, and prevents automation. For example, it asks you want to set root password, remove anonymous users, disable remote root login, and remove test databases and access to them. Mysql_secure_installation is a script that helps database administrators make their MySQL installation secure using a series of prompts to customize your installation.
0 kommentar(er)
