The *.* in the output denotes that the âgfguser1â user account can only login to the database server and has no other privileges. Viewing permissions of an User Account: The âShow Grantsâ statement is used to view the permissions of a user account.The show grants statement is used in the following way:.To allow the user account to connect to the database server from any subdomain of the ââ host, then the percentage wildcard % should be used as follows: Allowing a user account to connect from any host: To allow a user account to connect from any host, the percentage (%) wildcard is used in the following way. The above code creates two new users with username âgfguser2â and âgfguser3â with passwords âefghâ and âuvxyâ respectively.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |