Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-other-changes.html
Here are other changes with Connector/J 8.0 and beyond: Removed ReplicationDriver. Instead of using a separate driver, you can now obtain a connection for a replication setup just by using the jdbc:mysql:replication:// scheme. See Chapter 4, ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements.html
To create a Statement instance, you call the createStatement() method on the Connection object you have retrieved using one of the DriverManager.getConnection() or DataSource.getConnection() methods described earlier. Statement objects allow you to ...
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
If a client attempts to connect to a locked account, the attempt fails. The server increments the Locked_connects status variable that indicates the number of attempts to connect to a locked account, returns an ER_ACCOUNT_HAS_BEEN_LOCKED error, and ... MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new ...
https://dev.mysql.com/doc/refman/8.4/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. The user name part of an account name is either a nonblank value that ...
https://dev.mysql.com/doc/refman/8.4/en/activestate-perl.html
If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ... On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install ...
https://dev.mysql.com/doc/refman/8.4/en/assigning-passwords.html
Required credentials for clients that connect to the MySQL server can include a password. If the read_only system variable is enabled, use of account-modification statements such as CREATE USER or ALTER USER additionally requires the ...MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log.html
MySQL Enterprise Audit uses the open MySQL Audit API to enable standard, policy-based monitoring, logging, and blocking of connection and query activity executed on specific MySQL servers. The log contents include when clients connect and ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/binlog-replication-configuration-overview.html
This means that multiple replicas can be connected to the source and executing different parts of the same binary log. Because the replicas control this process, individual replicas can be connected and disconnected from the server without affecting ... This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes take place) writes updates and changes as “events” to the binary ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
The problem may be that all connections are in use, or there may be some internal lock problem. mysqladmin -u root processlist usually is able to make a connection even in these cases, and can provide useful information about the current number of ... Each MySQL version is tested on many platforms before it is ...