Resetting your MySQL database password
There may be instances in which you may not remember your password and this leaves you without the ability to access into your MySQL database. Now, you don’t need to worry about forgetting your password as we now offer you the option to reset and create a new password. Here are the steps that on how you can do so :
1.
Suspend the MySQL
service under Windows Service.
Go into
Control Panel > Select to view Small icon > Select Administrative Tools
Select
Services
Select
MySQL > Right click > Select Stop
2. Next, create a
TXT file with the content below
UPDATE mysql.user SET Password=PASSWORD('root') WHERE User='root';
FLUSH PRIVILEGES;
Exit;
You
can insert your new password to replace the root.
Save
the file into C drive with name MYSQL.txt3. Run COMMAND PROMPT by using your administrator privilege
4.
Now, type the
command below:
C:\>"C:\Program
Files\MySQL\MySQL Server 5.5\bin\mysqld.exe" --defaults-file="C:\Program
Files\\MySQL\\MySQL Server 5.5\\my.ini" --init-file=C:\\MYSQL.txt
In
case you install MySQL into Program Files (x86) folder, please make sure that
you change the command as below:
C:\>"C:\Program
Files (x86)\MySQL\MySQL Server 5.5\bin\mysqld.exe"
--defaults-file="C:\Program Files (x86)\\MySQL\\MySQL Server
5.5\\my.ini" --init-file=C:\\MYSQL.txt
5.
Go into Control
Panel > Select Small icon view > Select Administrative Tools >
Services > MySQL > Right click mouse to select Start service.
نورگیر
ReplyDeletehttp://www.sayenama.com/noorgir.html
نورگیر
ReplyDeleteآبنما
ReplyDeleteآبنما
Deleteآبنما
ReplyDeleteI followed the steps but the mysql service is not starting. How do I resolve it
ReplyDeleteDear Richard,
DeleteGood day to you,
In regards to your inquiry, if you forgot the MySQL database password, you may refer the solution at the new link below from the vendor website on how to reset the MySQL password. You need to ask your programmer or IT personnel to configure the steps for you as you need an IT expertise to help regarding the configuration.
http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
Then, please make sure the services are running accordingly in the background, please close all application > restart MySQL, Ingress Services and Attendance Service > Run Ingress DB Installer > Open the Ingress Software and check whether the problem still appear or not.
To restart MySQL, Ingress service and Attendance service: Start > Control Panel > Administrative Tools > Services > restart MySQL / Ingress Services / Attendance Service
To Run Ingress DB Installer : Start > All Program > FingerTec Ingress > Ingress DB Installer > Key In MySQL password > Test Connection > Update Connection > Upgrade Database.
i get the error message"error 1067: the process terminated unexpectedly" windows is unable to start the mysql service. can you help?
ReplyDelete