Mysql HELP

@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>https://www.digitalocean.com/community/articles/how-to-create-and-manage-databases-in-mysql-and-mariadb-on-a-cloud-server <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 --> 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!

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.