![]() | CREATE USER IDENTIFIED WITH 'caching_sha2_password' AS '$A$005IwwzH/s]6F. Mysql> SHOW CREATE USER CREATE USER for | Mysql> CREATE USER IDENTIFIED BY 'MyPassword' PASSWORD EXPIRE įollowing is the SHOW CREATE USER query for the above created user − x.ycpOwCHw4U5DkqKEHmlbAB3QrvgjthpimTebHdY2' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK PASSWORD HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT PASSWORD REQUIRE CURRENT DEFAULT | | CREATE USER IDENTIFIED WITH 'caching_sha2_password' AS '$A$005eiknGyZ r]L◄T☻. For each account, CREATE USER creates a new row in er (until MariaDB 10.3 this is a table, from MariaDB 10.4 it's a view) or mysql.globalprivtable (from MariaDB 10.4) that has no privileges. To use it, you must have the global CREATE USER privilege or the INSERT privilege for the mysql database. Your database needs to be created only once, but you must select it for use each time you begin a mysql session. To make menagerie the current database, use this statement. Mysql> CREATE USER exampleUser IDENTIFIED BY '123456' įollowing query is retrieves/displays the CREATE statement used to create the above user. The CREATE USER statement creates new MariaDB accounts. Creating a database does not select it for use you must do that explicitly. ExampleĪssume we have created a user using the CREATE statement as shown below − Where, name is the name of the user for which you need the create statement. ![]() Syntaxįollowing is the syntax of the SHOW CREATE USER Statement. The SHOW CREATE USER Statement is displays the CREATE statement used to create the specified user. To create a user account, the current account needs to have CREATE USER privilege, or the INSERT privilege for the MySQL system schema. You can create a new user account in MySQL using the CREATE USER Statement.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |