MySQL - Managing User Accounts and Access Privileges in MySQL

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing User Accounts and Access Privileges in MySQL. Clear answers are provided with tutorial exercises on creating and deleting user accounts; setting and changing passwords; giving and removing user privileges; showing granted privileges and levels.

What Is a User Account in MySQL

Predefined User Accounts in MySQL

Adding a New User Account in MySQL

Testing New User Account and Password in MySQL

Changing Your Own Password in MySQL

Chaning Other User's Password in MySQL

Deleting a User Account in MySQL

Listing All User Accounts in MySQL

Rename an Existing User Account in MySQL

What Are User Privileges in MySQL

Scope Levels of User Privileges in MySQL

Giving Privileges at Server Level in MySQL

Giving Privileges at the Database Level in MySQL

Viewing User Privileges in MySQL

Revoking User Privileges in MySQL

Giving User Read-only Access in MySQL

User Privilege Tables in MySQL

Please note that all answers and tutorials are based on MySQL 5.0. Sometimes you may need to run previous tutorials in order to continue a later tutorial.

⇒⇒MySQL Database Tutorials

2017-12-13, 387👍, 0💬