You can use vi, vim or nano to edit the file. Lastly, you need to update the MySQL root password in the file /etc/mysql/my.cnf (as shown in Pic2) or you might not be able to add new database or user.If you disable incoming traffic for the mysql port, please remember to enable it again. Verify that you are able to connect to MySQL by running the command mysql again.Before the MySQL server shuts down, you will be prompted to key in the root password. Stop the MySQL server using the following command.At the MariaDB> prompt, run the following commands.UPDATE er SET Password=password('NEWSTRONGPASSWORD') WHERE User='root' Replace the NEWSTRONGPASSWORD with your chosen new strong password.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |