The exact meaning of the additional argument would depend on the specific authentication plugin. For example, the PAM authentication plugin accepts a service name: CREATE USER foo2 test IDENTIFIED VIA pam USING 'mariadb' Some authentication plugins allow additional arguments to be specified after a USING or AS keyword. If it doesn't show up in that output, then you will need to install it with INSTALL PLUGIN or INSTALL SONAME.įor example, this could be used with the PAM authentication plugin: CREATE USER foo2 test IDENTIFIED VIA pam The plugin name must be an active authentication plugin as per SHOW PLUGINS. The optional IDENTIFIED VIA authentication_plugin allows you to specify that the account should be authenticated by a specific authentication plugin. You can view EDUCBA’s recommended articles for more information.Syntax CREATE USER We hope that this EDUCBA information on “MySQL Users” was beneficial to you. We have also seen how to list users in the present server. We have also seen how to grant privileges to users and revoke privileges and different types of privileges granted to the users in a MySQL database. In this article, we saw how to create and delete new users. So, after the deletion of the root user, we are left with only three users. Where username is the name of the user which we want to delete.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |