Running

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.

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

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!

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"

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:

https://www.digitalocean.com/community/articles/how-to-create-and-manage-databases-in-mysql-and-mariadb-on-a-cloud-server

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.

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

@meloncraftnetwork:

sudo apt-get purge mysql-server

sudo apt-get autoremove --purge

sudo apt-get install mysql-server