Re: automate mysql_secure_installation

[Jay Alverson]

Actually, you just need to remove the prompts and make sure it
calls the SUBs you want to execute.

OR

Go thru all the SUBs and make the equivalent SQL statements into
a .sql file which you execute as part of your install.

C:\xampp\mysql\scripts>grep -i "^sub" mysql_secure_installation.pl

sub write_file {
sub prepare {
sub do_query {
sub make_config {
sub get_root_password {
sub set_root_password {
sub remove_anonymous_users {
sub remove_remote_root {
sub remove_test_database {
sub reload_privilege_tables {
sub interrupt {
sub cleanup {

Thanks, Jay