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, 1579🔥, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...