How can I reset my MySQL password? Following this procedure, you will disable access control on the MySQL server. All connexions will have a root access. It is a good thing to unplug your server from the network or at least disable remote access. To reset your mysqld password just follow these instructions : Stop […]

Backup Mysql Database: you can use mysqldump to backup a database. If i want to backup the database mileage into the sql file mileage.sql. $mysqldump -u root -p mileage > mileage.sql You will be prompted to enter the password for the root. This will dump the data and the commands to create the table in […]

There are a couple of ways to change a user password including root for the mysql databases. one is using mysqladmin(which i’m not that fluent with) the other is directly go into mysql and change the password. $mysql -u root – p Now enter password (your old password for root) mysql > use mysql; mysql> […]