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 [...]

Installing NGINX, PHP, and MySQL on Ubuntu 13.04

This “how to” guide will step you through the process of setting up Nginx, PHP, and MySQL on Ubuntu 13.04.…

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 [...]

Installing NGINX, PHP, and MySQL on CentOS 6

This “how to” guide will step you through the process of setting up Nginx, PHP, and MySQL on CentOS 6.…

Read more [...]



Page 1 of 41234