Nov 24, 2022
Click on Database users then Add New Database User.
Enter in the username you wish to use. It should actually be something that is not too easy to guess, meaning you should add a capital letter, followed by some lowercases, a number and a symbol.
Use our password generator to ensure your absolute and guaranteed protection with the recommendation of a 32 random character password. You can set this lower or higher if you prefer.
Afterward, click Add mydbuser1 User.
Navigate to Databases then click on Add New Database.
Enter your database name (must be at least 5 characters) followed by collation (optional) and assign a database user which is the user you have created before. Then, hit the Save Database button.
Once added, the database will show a primary user attached to it.
You also can click the ellipses (3 dots) and assign a user to add a system user to a database.
You can also revoke a user from the database: