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, 1809🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...