View source for Securing mysql with a script

Reference - https://stackoverflow.com/questions/24270733/automate-mysql-secure-installation-with-echo-command-via-a-shell-script<br>
<source lang="bash">
mysql_secure_installation <<EOF

y
secret
secret
y
y
y
y
EOF

</source>


not tested the sql script below
<source lang="sql">
    #!/bin/bash
    
    # Make sure that NOBODY can access the server without a password
    mysql -e "UPDATE mysql.user SET Password = PASSWORD('CHANGEME') WHERE User = 'root'"
    # Kill the anonymous users
    mysql -e "DROP USER ''@'localhost'"
    # Because our hostname varies we will use some Bash magic here.
    mysql -e "DROP USER ''@'$(hostname)'"
    # Kill off the demo database
    mysql -e "DROP DATABASE test"
    # Make our changes take effect
    mysql -e "FLUSH PRIVILEGES"
    # Any subsequent tries to run queries this way will get access denied because lack of usr/pwd param



</source>
Run the above like this :<br>
mysql -sfu root < "mysql_secure_installation.sql" <br>