BlogUbuntu 18.04 Change the Root Password of MySQLThe latest MySQL 5.7.1 install without prompting for root password on the Ubuntu 18.04 server. If you use the mysql_secure_intallation it will ask you for setting a new root password, which is perfectly fine. The issue is it will not change the root password, and will leave MySQL unsecured. Changing the root password manually is the right solution. However, it will not be straightforward as some files and folders required by MySQL are not created during the installation. You may need to go through several installation runs. Make sure you clear up the system by purging, autoremoving, and autocleaning every time you start a new MySQL installation attempts. 1. Clean Up the System of MySQL Traces and Update, Upgrade
2. Install MySQL
3. Create Missing Directory
3. Stop and Kill MySQL Service
4. Start MySQL in Elevated Mode and Go in MySQL console
5. Type in the MySQL Console
6. Kill and Start the MySQL Service
If you are lucky now you should have a secured MySQL database ready to work with.
Loading blog_post_recommendations...
|