On an unmodified MySQL install, the root user account does not have a password. MySQL is an open-source relational database, made famous by its ease-of-use and simple setup on modern Linux and Windows operating systems. If you've made a mistake, or need to change the root password use the following: Change root password: cd /usr/local/mysql/bin/./mysql -u root -p Enter password: type old password invisibly use mysql update user set password=PASSWORD('NEWPASSWORDHERE') where User='root' flush. Up vote, subscribe or even support this channel at. Author: Jeremy Druin Twitter: Thank you for watching. Changing the MySQL password for the root user was straightforward enough, but locating and editing the files to reflect the new password was a different story. Having recently changed my local testing server environment from XAMPP to MAMP v2.0.5 I wanted to change the password for the MySQL root user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |