Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config.html
For example, to configure a connection to a MySQL server supporting the world sample database, you might use: <util:map id="dbProps"> <entry key="db.driver" value="com.mysql.cj.jdbc.Driver"/> <entry key="db.jdbcurl" ... The Spring Framework is a ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-17.html
Version 8.0.17 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. (WL #12247) The README and LICENSE files are now included ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-1-0.html
Version 9.1.0 is a new GA release of MySQL Connector/J. MySQL Connector/J 9.1.0 supersedes 9.0 and is recommended for use on production systems. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. Functionality ...This release can be used against MySQL Server version 8.0 and ...
https://dev.mysql.com/doc/refman/9.7/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. To determine the invoking user, you can call the USER() function, which returns a value indicating the actual user name provided by the ...
https://dev.mysql.com/doc/refman/9.7/en/charset-literal.html
For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system variables. If _charset_name is not specified but COLLATE ... Every ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-files-using-openssl.html
A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/9.7/en/data-directory-initialization.html
If you used --initialize-insecure to initialize the data directory, connect to the server as root without a password: mysql -u root --skip-password After connecting, use an ALTER USER statement to assign a new root password: ALTER USER ... After ...
https://dev.mysql.com/doc/refman/9.7/en/default-privileges.html
If the root account has an empty password, your MySQL installation is unprotected: Anyone can connect to the MySQL server as root without a password and be granted all privileges. Choose whichever of the following procedures applies: If the root ...
https://dev.mysql.com/doc/refman/9.7/en/expired-password-handling.html
For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects the client or restricts the client to “sandbox mode,” in which the server permits the ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-secure-user.html
To secure the user credentials, you can require SSL for connections with the user account, and provide the user credentials when Group Replication is started, rather than storing them in the replica status tables. Important When using the MySQL ...