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