"MySQL Learning"--0x03. SQL create users and their corresponding databases

------Create a database (slightly)------------

---------Creating user mysql5.6 The user with insert is problematic ---------GRANTUSAGE on *.*  to 'User01'@'localhost'Identified by '123456'  with GRANT OPTION;-----------Authorization-----------------Here I created a library database for User01-----------Grant  All Privileges  onLibrary.*  toUser01@localhostIdentified by '123456';--you can log in-------------after exiting----------------

Because it is version 5.6 MySQL, you cannot create a user by using the Insert method.

GRANT USAGE on *. User01 ' @ ' localhost ' identified by ' 123456 ' with GRANT OPTION;

"MySQL Learning"--0x03. SQL create users and their corresponding databases