Mysql HELP

Hi! <br> <br>Could you explain what exactly you are trying to accomplish? If you simply want to start the MySQL service, you can use: <br> <br><pre> <br>sudo service mysql start <br></pre> <br>

I want to reset all of my Mysql info ~! I am trying to Reinstall xenforo forums here --> http://mcnserver.info/forums/ <br> <br>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!

To reset the root MySQL password, we first need to stop the normal service and restart it with <code>–skip-grant-tables</code> Run: <br> <br><pre> <br>service mysql stop <br>mysqld_safe --skip-grant-tables & <br></pre> <br> <br>If it seems to hang here, press enter again and you should return to the command prompt. Then run: <br> <br><pre> <br>mysql -u root <br></pre> <br> <br>You should now be at the MySQL prompt. Run: <br> <br><pre> <br>FLUSH PRIVILEGES; <br>SET PASSWORD FOR root@‘localhost’ = PASSWORD(‘new-password’); <br>FLUSH PRIVILEGES; <br>exit; <br></pre> <br> <br>You should now be back at the normal command line. Now restart MySQL: <br> <br><pre> <br>/etc/init.d/mysql stop <br>service mysql start <br></pre> <br> <br>Your password should now be set to “new-password”