![]() Now you need to specify which database you’re giving the user permissions to.Make sure to leave the checkboxes unticked in order to not create a new database with the new user. If you wish to Generate a password, this will automatically fill in the Password and Retype fields with the newly generated password for you once you click Generate. Adding a New User to an Existing Database Once you have followed the steps above, you should have successfully added a new user and also created a new database for the user to use. It may be a good idea to keep a copy of this for future reference. This will also be followed by a copy of the query used to create this user. After you have clicked Go, you should be greeted by a You have added a new user message.Once you’ve finished click the Go button. ![]() There’s a section below this one that covers Global Privileges and Resource Limits if you wished to make any changes to these. Make sure to tick the Create database with the same name and grant all privileges box to create a new database linked to the new user. If you wish to Generate a password, this will automatically fill in the Password and Retype fields with the newly generated password once you click Generate. You just need to input the information that you wish to use for the new user into the appropriate fields. There should be separate fields corresponding with different details for a New User.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |