In this section you will find a lot of useful MySQL administration tutorials including MySQL server startup and shutdown, MySQL server security, MySQL database maintainance, backup and replication.
-
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.
-
In this tutorial, you will learn how to create user in MySQL by using CREATE USER and INSERT statements.
-
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.
-
In this tutorial, you will learn how to use MySQL GRANT statement to grant privileges to accounts.
-
In this tutorial, you will learn how to use MySQL REVOKE statement to revoke privileges from MySQL accounts.
-
MySQL provides a several useful commands to allow you to maintain database tables to make the access more efficiently. Those commands enable you to analyze, optimize, check, and repair the database tables.
-
In this tutorial, you will learn how to backup databases by using mysqldump client tool provided by MySQL.