![]() Log into your server via SSH as the root user, and stop MySQL by typing: sudo service mysql stop This during off-peak hours, when your users will be least affected. Warning! This process will take MySQL offline for a short period of time it's best to perform Next, you'll need to update the file that contains the MySQL root user's password so youĬan SSH into your server as root and run the mysql command witout typing a password. SET PASSWORD FOR = PASSWORD('put-your-new-password-here') ![]() Please make a note of the password, as you will need to put it into a file in the next step. You do need to leave the single quotes around the new Log into SSH as the root user, then log into MySQL by typing: mysqlĪt the MySQL prompt, type the following, but replace put-your-new-password-here with theĪctual password you want to use. Will not be any downtime for this process if these steps are followed. You can log into MySQL as the root user by simply typing mysql at the SSH prompt. This section covers changing a MySQL root password that is working, meaning Warning! We recommend taking a server snapshot before performing tasks such as these.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |