Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Torstein Krogh: "Some time ago, I tested all available tools on the market for maintaining MySQL and MySQL Maestro came up on top. My opinion is that MySQL should offer it as a free tool for all paying customers! They have nothing today, and doing MySQL DOS commands is not getting any new customers".
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".

More

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