MySQL Administration
In this section, you will find a lot of useful MySQL administration tutorials, including server startup and shutdown, user security, database maintenance, and backup & restore.
Section 1. Start, Stop, and Restart MySQL Server
- Start MySQL Server – show you how to start the MySQL Server on Windows and Linux.
- Stop MySQL Server – describe the steps of stopping MySQL Server on Windows and Linux.
- Restart MySQL Server – guide you on how to restart MySQL Server on Windows and Linux.
Section 2. Users, Roles, and Privileges
- Create Users – learn how to create a new user in MySQL Server.
- Grant Privileges – grant privileges to a user account.
- Revoke Privileges – revoke privileges from a user account.
- Manage Roles – manage roles in the database.
- Show Granted Privileges – display privileges associated with a user account or role.
- Drop users – show how to delete a user account.
- Change password – describe ways to change passwords for users.
- Show Users – learn how to show user accounts in MySQL Server.
- Rename users – rename a user to another.
- Lock user accounts – how to lock user accounts.
- Unlock user accounts – how to unlock user accounts.
Section 3. Show commands
- Show Databases – display all databases in the MySQL Server.
- Show Tables – list all tables in a given database.
- Show Columns – list all columns in a table.
- Show Processlist – show the current processes in the MySQL Server.
Section 5. Database maintenance
- Maintain Tables – provide you with commands to maintain tables.