Online Documentation for SQL Manager for MySQL

User Editor


The User Editor dialog allows you to create/edit a user and specify its properties.

 

Name

Enter a name for the new user, or modify the name of the user being edited.

 

Host

Specify the host from which the user is allowed to access the server.

Note: The % character can be used to indicate that the user is allowed to access the server from any host.

 

Password / Confirm password

Set a password by which the user will be identified in the server.

 

User Editor

 

 

SSL Require

This section allows you to define additional user authentication parameters.

 

Note: This section is active only when server is running with SSL.

 

Require By

MySQL server can check the X509 certificate attributes additionally to common authentication based on user name and password.

Select authentication method from the drop-down list.

 

SSL

Allow only SSL-secured connections for the account.

 

X509

Client must have valid certificate. The only requirement for the certificate is that it should be possible to verify its signature with one of the CA certificates.

 

Require By Cipher

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.

Example: EDH-RSA-DES-CBC3-SHA

 

Require By Subject

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

Example: C=EE, ST=Some-State, L=Tallinn, O=MySQL demo client certificate, CN=Tonu Samuel/Email=tonu@mysql.com

 

Require By 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.

Example:C=FI, ST=Some-State, L=Helsinki, O=MySQL Finland AB, CN=Tonu Samuel/Email=tonu@mysql.com

 

Global privileges

This group allows you to specify the global privileges for the user being created/edited.

 

Extended user properties

This area allows you to define additional properties pertaining MySQL users: Max. queries per hour, Max. updates per hour, Max. connections per hour, Max. users connection. Use the spinner controls to set the required values for the properties.

 

Hint: The Global privileges and Extended user properties can also be specified in Grant Manager.