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

March 9, 2014 | By the+gnu+linux+evangelist.

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 Requires 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!

QuickChic Theme • Powered by WordPress