AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Lost phpmyadmin password ubuntu11/19/2023 ![]() ![]() You tried to login to MySQL using what you thought was the right password for the root account and saw this ominous message: ![]() This guide will help you get started on any system to reset your lost root password for MySQL. You just realized that you’ve forgotten your MySQL root password on your Amazon Web Services (AWS) EC2 Linux instance, or anywhere for that matter. ![]() Make sure to notedown your password! Thanks to Illuvator for posting this method in the ubuntu forum.Uh-oh. Mysqladmin -u root password your-new-password In the next step be sure to chance the your-new-password with the password you want! Sudo apt-get install mysql-server mysql-common mysql-client Sudo apt-get -purge remove mysql-server mysql-common mysql-client USE THIS AS A LAST RESORT METHOD, YOU WILL LOSE ALL YOUR MYSQL DATA Depending on your installation the packages might be diffrent, mysql-server in 6.10 is called mysql-server-5.0 as an example. This removes every file related to mysql. If this is also your case you may opt for the PURGE way. I had not been able to use mysql so it was empty anyway. I tried the other way as well and it just ended up being difficult. I also had some problems with mysql just not accepting my password. To install phpmyadmin on you server you will need to have 4 things:Īll packages can be found browsing synaptic. An easy way to have a full control of your mysql server is phpmyadmin (software made in php that can give you a web interface that can be very usefull to people that havent got a lot of confidence with bash. When you have completed all this steps ,you can easily access to your mysql server with the password you have set in the step before. Then stop the mysqld process and relaunch it with the classical way: sudo /etc/init.d/mysql stop
0 Comments
Read More
Leave a Reply. |