Collections:
Predefined User Accounts in MySQL
What Are the Predefined User Accounts in MySQL?
✍: FYIcenter.com
There is only one predefined user account called "root":
Here is a tutorial exercise to check the "root" user account:
>cd \mysql\bin
>mysql -u root
mysql> USE mysql;
Database changed
mysql> SELECT User, Password, Shutdown_priv, Create_priv
-> FROM user WHERE User = 'root';
+------+----------+---------------+-------------+
| User | Password | Shutdown_priv | Create_priv |
+------+----------+---------------+-------------+
| root | | Y | Y |
+------+----------+---------------+-------------+
1 row in set (0.00 sec)
⇒ Adding a New User Account in MySQL
⇐ What Is a User Account in MySQL
2017-09-08, 3534🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How to obtain the version number of the ICU (International Components for Unicode) library using the...