Mysql HELP

June 4, 2014 1.6k views
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 & or mysqld_safe --skip-grant-tables
8 Answers
mysqld_safe --skip-grant-tables &
will cause the command to run in the background, so once you've run that you can just run any other command you want.

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

I want to reset all of my Mysql info ~! I am trying to Reinstall xenforo forums here -->

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 --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:

SET PASSWORD FOR root@'localhost' = PASSWORD('new-password');

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"
OMG ! It has been reset thank you so freaking much man , but how can i change the data base name and username
There's a basic overview of MySQL commands that might be helpful to you:

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.
by Justin Ellingwood
MySQL and MariaDB are database management software that use the SQL querying language. In this guide, we will discuss how to create and manage databases from within the MySQL or MariaDB interface. This guide will cover how to create, view, switch to, and delete databases.
How can i simply delete it then make a new one , and i dnt know my db username or db name
sudo apt-get purge mysql-server

sudo apt-get autoremove --purge
sudo apt-get install mysql-server
Have another answer? Share your knowledge.