Search Results
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers-windows.html
Microsoft Windows XP and newer includes at least one ODBC driver for Microsoft SQL Server, so additional actions are likely not required on your system. Multiple SQL Server driver options exist, as described in this section. You can check your ODBC ...
https://dev.mysql.com/doc/workbench/en/wb-migration-install-odbc-libraries.html
In the pyodbc source directory, edit the setup.py file and around line 157, replace the following line: settings['libraries'].append('odbc') with settings['libraries'].append('iodbc') Execute the following command as the root user: ... Note This ...
https://dev.mysql.com/doc/internals/en/creating-binary-packages.html
Another way to build packages is by calling the cpack executable directly: cpack -G TGZ --config CPackConfig.cmake Use -G TGZ to produce a .tar.gz archive, -GZIP for a .zip file. A package can be created in the form of a .tar.gz archive or .zip ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
The log_timestamps system variable controls the time zone of timestamps in messages written to the general query log file (as well as to the slow query log file and the error log). The general query log can be very useful when you suspect an error ... The general query log is a general record of what mysqld is ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface.html
Then it is executed one or more times at a later time, using the statement handler returned by the initialization function. In the case of direct execution, the query is parsed every time it is executed. Prepared execution is an efficient way to ...
https://dev.mysql.com/doc/internals/en/mysql-test-directory.html
The directory has a README file which explains how to run the tests, how to make new tests (in files with the filename extension *.test), and how to report errors. Primarily these are SQL scripts which try out a feature, output a result, and compare ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-19.html
When retrieving TIME values using ResultSet.getTimestamp(), the fractional seconds are truncated when useCursorFetch=true. It also corrects some inconsistencies in formatting the fractional seconds when returning the TIME values as strings. (Bug ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
For example, if mysql is the firewall database: CALL mysql.sp_set_firewall_group_mode(group, mode); In MySQL 8.4, firewall stored procedures are transactional; if an error occurs during execution of a firewall stored procedure, all changes made by ...If an account profile has an empty allowlist, its mode cannot be set to PROTECTING because the profile would reject every statement, effectively prohibiting the account from executing ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-permissions.html
The exceptions are the data directory, the error log file, the mysql-files directory, the pid file, and the socket file, to which the mysql user must have write access. The following table shows directory and file permissions for the generic binary ...
https://dev.mysql.com/doc/internals/en/preventing-use-of-optimizer-trace.html
If for some reason, as DBA of a MySQL Server, you wish to prevent all users from seeing traces of their queries, start the server with these options: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum ...