Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
Questions 16.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 What is going on? I can connect just fine ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Server version 8.0.19-commercial Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 11 min 7 sec Threads: 3 Questions: 8 Slow queries: 0 Opens: 146 Flush tables: 3 Open tables: 63 Queries per second avg: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-rpm.html
The components required to install the three major types of NDB Cluster nodes are given in the following list: Management node: management-server Data node: data-node SQL node: server and common In addition, the client RPM should be installed to ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
Consequently, database and table names are case-sensitive in MySQL Server on operating systems that have case-sensitive file names (such as most Unix systems). MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other SQL ...If you add a version number after the ! character, the syntax within the comment is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
This client transaction is assigned a GTID composed of the source's UUID and the smallest nonzero transaction sequence number not yet used on this server. Whenever the binary log is rotated or the server is shut down, the server writes GTIDs for all ...This GTID set contains a representation of the set of all committed GTID transactions, and it is used in replication as a token that represents the server ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Example: "table_access_data": { "db": "test", "table": "t1", "query": "INSERT INTO t1 (i) VALUES(1),(2),(3)", "sql_command": "insert" } time This field is similar to that in the timestamp field, but the value is an integer and represents the UNIX ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
The mysql.user system table indicates for each account when its password was last changed, and the server automatically treats the password as expired at client connection time if its age is greater than its permitted lifetime. In that case, the ...
https://dev.mysql.com/doc/internals/en/memory-allocation-mysql-server.html
The basic logic to use: All things that are used only for the duration of a query are allocated in THD::mem_root through sql_alloc() or thd->alloc() except: Things that may grow, like string buffers of type String. Large blocks of memory used in ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/server-plugin-descriptors.html
mysql_declare_plugin_end; Each server plugin must have a general descriptor that provides information to the server plugin API. The server executes this function when it loads the plugin, which happens for INSTALL PLUGIN or, for plugins listed in ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
If everything else fails, start the mysqld server with a debugging option (for example, --debug=d,general,query). If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can ...