Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Prithwi Thakuria: "I have been in the database field for eons. This is one the best suite of tools I have found in terms of cost, functionality and performance. Ever since we bought this array of products, life with databases have been a breeze and the productivity has soared immensely. Keep up the good work".
Kym Harper : "Beautifully presented tools (and web site) and great service. I will be sending links to many other individuals who should be interested. Wishing you every continued success and thank you again".


Add your opinion

SQL Maestro for MySQL online help

Prev Return to chapter overview Next

Create User Wizard

Create User Wizard guides you through the process of creating a new user. See How To Create User to learn how to run this wizard.


The basic principles of Create Object Wizards in SQL Maestro for MySQL are explained in a separate topic. Below you will find a description of wizard steps that are unique for the current object.


The field Name contains the new user name as it was set on the previous wizard step. Use it to edit the name of user being made.


Use this step also to specify the new user Password and confirm it.


The Max queries per hour count, Max updates per hour count, and Max connection per hour count options limit the number of queries, updates, and logins a user can perform during any given one-hour period. (Queries for which results are served from the query cache do not count against the Max queries per hour limit.) If count is 0 (the default), this means that there is no limitation for that user.


The Max connection per hour count option limits the maximum number of simultaneous connections that the account can make. If count is 0 (the default), the max_user_connections system variable determines the number of simultaneous connections for the account.


MySQL can check X509 certificate attributes in addition to the usual authentication that is based on the username and password. To specify SSL-related options for a MySQL account, use the following Require options.


Authentication (None, SSL, X509)

Use None to indicate that the account has no SSL or X509 requirements. Select SSL option to allow only SSL-encrypted connections for the account. X509 means that the client must have a valid certificate but that the exact certificate, issuer, and subject do not matter. The only requirement is that it should be possible to verify its signature with one of the CA certificates.


Cipher is needed to ensure that ciphers and key lengths of sufficient strength are used. SSL itself can be weak if old algorithms using short encryption keys are used. Using this option, you can ask that a specific cipher method is used to allow a connection.


Issuer places the restriction on connection attempts that the client must present a valid X509 certificate issued by CA 'issuer'. If the client presents a certificate that is valid but has a different issuer, the server rejects the connection. Use of X509 certificates always implies encryption, so the SSL option is unnecessary in this case.


Subject places the restriction on connection attempts that the client must present a valid X509 certificate containing the subject subject. If the client presents a certificate that is valid but has a different subject, the server rejects the connection.




User permission

The wizard step allows you to define actions the user can do with database objects. Just check the necessary box to set the corresponding permission. Actions are arranged alphabetically.


MySQL allows to set following user permissions: Alter, Alter routine, Create, Create routine, Create temporary tables, Create view, Create user, Delete, Drop, Execute, File, Grant option,Index, Insert, Lock tables, Process, References, Reload, Replication client, Replication slave, Select, Show databases, Show view, Shutdown, Super, and Update.

Prev Return to chapter overview Next