Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: MySQL Secure Installation  (Read 3433 times)

0 Members and 1 Guest are viewing this topic.

Jithin

  • Guest
MySQL Secure Installation
« on: November 08, 2013, 09:01:27 pm »
Hi Guys,

To install MySQL in a secured way, the delevopers provide a tool that ship with the base MySQL source.

After compiling or installing  the MySQL, just execute the command "mysql_secure_installation" and that will walk you through some basic and secure way to setup MySQL.

Sample Executing :

# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):

Give it a try!