![]() ![]() Step 1: Stop mysql service open taskmanager -> select services tab -> find wampmysqld64 service or wampmysqld if you use 32 bit version -> right click -> choose stop. PS: reinstalling wamp will not harm your www data directory. In some case, we forgot the root password in wampserver and we want to reset root password, in this article, i will show you to to reset password for root account in mysql. You can also use Xmapp instead of wamp!I guess that can help to reset the mysql automatically. If you have some strange error like Plugin 'FEDERATED' is disabled which you dont have any clue then reset the arch google with my.cnf and mysql reset If you can get access mysql for the first time when install wamp go to mysql console and when ask password simply press enter.This will enable the option for phpmysqladmin to log in straighaway. If it denies to log in and says access denied using password.Use this link: ![]() Start the MySQL server with the special -init-file option. Open a console window to get to the command prompt: run cmd. For this example, the file will be named C:\mysql-init.txt. On the wamp menu go to MySQL > MySQL console. UPDATE er SET PasswordPASSWORD ('MyNewPass') WHERE User'root' FLUSH PRIVILEGES Save the file. The 3 ways I will be discussing here are, 1) by going to the MySQL console and typing the appropriate commands, 2) via the GUI (graphical user interface) using SQL Buddy and 3) via PHPMyAdmin. Then, run the next command on Windows Command Line: C:\wamp64\bin\mysql\mysql5.7.21\bin\mysqld.exe wampmysqld -init-fileC:\\wamp64\\mysql-init. Replace the password with the password that you want to use. Then you have the change the following entry to the new password of the root user. Try this: Create a file C:\wamp64\mysql-init.txt with this content: UPDATE er SET PasswordPASSWORD ('1234') WHERE User'root' FLUSH PRIVILEGES This will reset password to 1234 for user root. How to determine if a port is open on a Windows server? If you have installed WAMP, go to the wamp root\appsphpmyadmin installation and find the file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |