Mysql HELP

Question

Ive doneStop mysqlmysqld_safe --skip-grant-tables & After you’re returned to the bash prompt: The bash prompt never comes up , it just does nothing when i run mysqld_safe --skip-grant-tables & or mysqld_safe --skip-grant-tables

Andrew SB · Answer

Hi!

Could you explain what exactly you are trying to accomplish? If you simply want to start the MySQL service, you can use:


sudo service mysql start

meloncraftnetwork · Answer

I want to reset all of my Mysql info ~! I am trying to Reinstall xenforo forums here --> http://mcnserver.info/forums/

I forgot all of my login info ~! I want to reset the password and username and db name if i can , Im trying my best but its not working so can somebody please help me , made a ticket they sent me to websites and stuff , but i still cannot do it so can i please have some help ? Step by step and backup if the step by step does not work!

Andrew SB · Answer

To reset the root MySQL password, we first need to stop the normal service and restart it with –skip-grant-tables Run:


service mysql stop
mysqld_safe --skip-grant-tables &

If it seems to hang here, press enter again and you should return to the command prompt. Then run:


mysql -u root

You should now be at the MySQL prompt. Run:


FLUSH PRIVILEGES;
SET PASSWORD FOR root@‘localhost’ = PASSWORD(‘new-password’);
FLUSH PRIVILEGES;
exit;

You should now be back at the normal command line. Now restart MySQL:


/etc/init.d/mysql stop
service mysql start

Your password should now be set to “new-password”

Become a contributor for community

DigitalOcean Documentation

Resources for startups and AI-native businesses

The developer cloud

Start building today

Report this

Mysql HELP

Report this

Mysql HELP