What is a User Account and Predefined User Accounts in MySQL?
A user account in MySQL is assigned a username and password to access MySQL databases. This user is also assigned some add on privileges like:
1. Insert data
2. Update data
3. Shutdown database etc
4. Restrictions to max connections that can be made and so on.
MySQL has one predefined user account “ROOT”. This account is created during installation without any password. Once installation finishes, a password is promoted. ROOT, by default has ALL privileges.
SELECT User, Password, Shutdown_priv, Create_priv
-> FROM user WHERE User = 'root';
