Mysql HELP

  • Posted June 4, 2014

Ive done Stop mysql mysqld_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 &


mysqld_safe --skip-grant-tables


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

@meloncraftnetwork: <pre>sudo apt-get purge mysql-server <br>sudo apt-get autoremove --purge <br>sudo apt-get install mysql-server</pre>

How can i simply delete it then make a new one , and i dnt know my db username or db name

There’s a basic overview of MySQL commands that might be helpful to you: <br> <br> <br> <br>Do you need to retain the info in the database, or are you starting fresh? It’s much simpler to delete the old one and create a new.

OMG ! It has been reset thank you so freaking much man , but how can i change the data base name and username

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”

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

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>

Running <pre>mysqld_safe --skip-grant-tables &</pre> will cause the command to run in the background, so once you’ve run that you can just run any other command you want.