What's new

Welcome to Onforum.net - Web and gaming resource community

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

Ask question

Ask Questions and Get Answers from Our Community

Answer

Answer Questions and Become an Expert on Your Topic

Contact Staff

Our Experts are Ready to Answer your Questions

Tutorial RESET PASSWORD OF MYSQL USER

Blaze

Elite
Elite
Joined
Jan 28, 2019
Messages
296
Reaction score
2,238
Points
93
Credits
97
It can happen that the data provided in the file base for certain server files is incorrect. Therefore, now I publish instructions on how to reset the password of the MySQL user and replace it with a new one. Although these instructions already exist abundantly on the web, there are always questions about how to do it.



Note: These instructions are general instructions. There is no difference whether you run your server locally or use a vServer or dedicated server. PuTTy can also be used for local instances as an SSH client.



MANUAL


1. Start a PuTTy session and connect to your server.



2. Enter the following commands in the console:

Code:
service mysql-server stop
mysqld_safe --skip-grant-tables

3. Now open a second PuTTy session and connect to your server again.



4. Enter the following commands in the console (without the comments):

Code:
mysql -u root
use mysql
update user set password = PASSWORD ('NEUESPASSWORT') where user = 'root'; // Replace NEW PASSWORD with your desired password
flush privileges;
quit
service mysql-server start
service mysql-server status


command explanation

 
Thread starter Similar threads Forum Replies Date
Vanilla Tutorials 0

Similar threads


shape1
shape2
shape3
shape4
shape7
shape8
Top

Dear User!

We found that you are blocking the display of ads on our site.

Please add it to the exception list or disable AdBlock.

The advertises that you'll see aren't intrusive they just help us to keep the community alive

If you don't want to see those ads just buy an upgrade.

Thank you for understanding!