Once MySQL launches, and you’ve confirmed the password change, delete the C:\myswl-init.txt file.Īt this stage, you have successfully reset the root password for your MySQL database. If you have unique configuration options (such as launching MySQL with a -defaults-file option), go ahead and do so. Now, you can log into your MySQL server as root using the new password. Note that there are two slashes after the C: prompt.Īlso, if you chose a different name in Step 2, use the same name after the double slash.
Use the File > Save As menu to save the file to the root of your hard drive (C:\ ).Replace NewPassword with the password of your choice. Make sure you keep the quote marks and semicolon.
MySQL Workbench is available on Windows, Linux and Mac OS X. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.
It can be because you forgot your password or you need to change the password for security reasons. There might arise a situation where you need to reset the root password for your MySQL database. Introduction of 3-Tier Architecture in DBMS | Set 2.Difference between DELETE, DROP and TRUNCATE.Difference between Primary key and Unique key.Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign).Difference between Clustered and Non-clustered index.Difference between Primary Key and Foreign Key.Commonly asked DBMS interview questions.Introduction of DBMS (Database Management System) | Set 1.SQL query to find second highest salary?.
SQL | Join (Inner, Left, Right and Full Joins).ISRO CS Syllabus for Scientist/Engineer Exam.ISRO CS Original Papers and Official Keys.GATE CS Original Papers and Official Keys.