Online Documentation for SQL Manager for MySQL
The User Editor dialog allows you to create/edit a user and specify its properties.
Enter a name for the new user, or modify the name of the user being edited.
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.
This section allows you to define additional user authentication parameters.
Note: This section is active only when server is running with SSL.
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.
Allow only SSL-secured connections for the account.
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.
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/Emailemail@example.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/Emailfirstname.lastname@example.org
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.