In this section, you will find a lot of useful MySQL administration tutorials including MySQL server startup and shutdown, MySQL server security, MySQL database maintenance, backup and replication.
Getting Started with MySQL Access Control System
MySQL implemented a sophisticated access control and privilege system to allow you to create comprehensive access rules for handling client operations and prevent unauthorized clients from accessing the database system.
MySQL Create User
In this tutorial, you will learn how to create user in MySQL by using CREATE USER and INSERT statements.
MySQL Changing Password for Accounts
In this tutorial you will learn how to change or reset password for MySQL account in various ways by using the UPDATE, SET PASSWORD and GRANT statements.
How to Use MySQL GRANT to Grant Privileges to Account
In this tutorial, you will learn how to use MySQL GRANT statement to grant privileges to accounts.
Revoking Privileges from Users Using MySQL REVOKE
In this tutorial, you will learn how to use MySQL REVOKE statement to revoke privileges from MySQL accounts.
Maintaining MySQL Database Tables
MySQL provides several useful statements that allows you to maintain database tables to increase the efficiency of table access. Those statements includes analyze, optimize, check, and repair tables.
How to Backup Databases Using mysqldump Tool
In this tutorial you will learn how to use mysqldump tool back up MySQL databases.