MySQL backup and restore

MySQL backup and restore Backing up MySQL   mysqldump is an easy to use tool for creating MySQL backups. This tool will create a text file full of the sql statements needed to create your database as it was at the time of executing mysqldump. Please note that these files can get very big so it’s not recommended to open the backup in a text edit...

Read more

Resetting a forgotten MySQL server passwords

Change MySQL password for other users To change a normal user password you need to type: mysqladmin -u user-name -p old password newpass Resetting forgotten root password Step # 1 : Stop the MySQL service: /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld.   Step # 2: Start the MySQL server w/o password: mysqld_safe --sk...

Read more