MySQL 5.7+ Initial SetUp for the Root User on Linux/Unix Easy Guide

March 9th, 2014 by thelinuxevangelist

MySQL 5.7+ Root User Initial SetUp




The Tip Show the Initial SetUp for the Root User on the MySQL 5.7+ Database.

The Configuation come from the New Security Features that Require the Encryption the Root Credentials.

This Step is Necessary to Successfully Creating New Databases on MySQL 5.7 and Above Server.

MySQL 5.7+ Root User Initial SetUp - Featured
  1. MySQL Database Secure Installation

    sudo mysql_secure_installation

    Set the root User Password.

    Then Follow workflow and perhaps confirm all the defaults…

    Troubleshooting MySQL Can’t connect to local MySQL server through socket:

    MySQL Server Socket Troubleshooting

    Troubleshooting Access Denied for User root:

    Resetting MySQL root Password
  2. Then Repeat SetUp with Encryption MySQL Prompt

    mysql -uroot -p
    SET PASSWORD = PASSWORD('[new_password]');

    Then You can Finally Getting-Started with a Safer MySQL Database!

Tags: , , , , , , , , , ,