Howtos / Articles

Delete a user from a MySQL server

This howto outlines the steps to remove a user from a MySQL server. Run the MySQL client: $ mysql -u root -p You will be asked for a password. If you don’t have a password set, simply press enter when prompted. Run the following command to delete the user: DROP USER ‘usertodelete’@'localhost’; This deletes the user called ‘usertodelete’. Change the user name and host values as required. Flush the privileges to make sure the dropped user has been removed: FLUSH…

Read more [...]

Restore MySQL Database on Linux

This howto guide will step you through how to restore a MySQL database from a backup file, using the MySQL client command line tools on a Linux machine. Backing up databases is important, but it is useless if you don’t know how to restore the backup. Regular restores should be done to ensure that your backup is operating correctly. Restoring a MySQL database: To restore a MySQL database from a plain text MySQL backup file, run the following command: $…

Read more [...]

Backup MySQL Database on Linux

This howto guide will step you through how to backup a MySQL database using the MySQL client command line tools on a Linux machine. Backing up databases should be done regularly to prevent any data loss due to disk crashes, data corruption, accidental deletion, etc. The more use the database gets, the more regularly the backups should be done. Backing up a MySQL database: To backup a MySQL database to a plain text file, run the following command: $ mysqldump…

Read more [...]

Optimize MySQL Table and Shrink the File Size

This howto outlines the steps to optimize a MySQL table, and shrink the physical file size of the file. This can be useful if you have removed a large number of records from a table, but the actual file size of that table on the disk hasn’t changed.…

Read more [...]

Allowing remote connections to a MySQL server

A default installation of MySQL server on a Linux machine will only listen for connections on the local interface (localhost or 127.0.0.1), so any remote connections can not be established. This how to article outlines the steps to change the configuration to listen on a specific, or all interfaces on the machine.…

Read more [...]



Page 1 of 3123