Search Results
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-apt-repo.html
You can check the status of the MySQL server with the following command: $> systemctl status mysql If the operating system is systemd enabled, standard systemctl (or alternatively, service with the arguments reversed) commands such as stop, start, ...First, add the MySQL APT repository to your system's software repository ... This ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-enterprise-backup.html
This is for preserving the server's UUID and Section 7.1.9.3, “Persisted System Variables” (if used), which are needed in the steps below. This is for preserving the server's Section 7.1.9.3, “Persisted System Variables”, which are needed ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/problems-connecting.html
If the server was started with the skip_networking system variable enabled, no TCP/IP connections are accepted. If the server was started with the bind_address system variable set to 127.0.0.1, it listens for TCP/IP connections only locally on the ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...To correct this when you ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-upgrade.html
removedSysLogVars: Checks for old system variables used to configure system logging. sysvar: Performs the following checks: Checks for system variables with different default values in the target version. Checks for system variables which are in use ... The util.checkForServerUpgrade() function is an upgrade checker utility that enables you to verify whether MySQL server instances are ready for ...The upgrade checker utility ...
https://dev.mysql.com/doc/refman/9.7/en/sha256-pluggable-authentication.html
RSA support has these characteristics: On the server side, two system variables name the RSA private and public key-pair files: sha256_password_private_key_path and sha256_password_public_key_path. The database administrator must set these variables ...For Group Replication, the group_replication_recovery_get_public_key system variable serves the same ...caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-configurator-cli.html
config-type N/A configuration-type list Developer, Server, Dedicated, Manual development configure, reconfigure N/A Optimizes system resources depending on the intended use of the server instance. WIN_SERVICE_ACCOUNT_PWD: This environment variable ...Executing MySQL Configurator requires a Windows user with administrative privileges, as otherwise the system prompts for the ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html
System variables and status variables specific to the firewall plugin enable firewall configuration and provide runtime operational information, respectively. For descriptions of these variables, see MySQL Enterprise Firewall Component System ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/plugin-types.html
The parser is influenced by certain system variables that cause words shorter or longer to be excluded, and by the stopword list that identifies common words to be ignored. This parsing is affected by the innodb_ft_xxx or ft_xxx system variables and ...Loadable Function (UDF) Plugins Storage Engine Plugins Full-Text Parser Plugins Daemon Plugins INFORMATION_SCHEMA Plugins Semisynchronous Replication Plugins Audit Plugins Authentication Plugins Password-Validation Plugins Protocol Trace Plugins Query Rewrite Plugins Keyring Plugins Loadable Function (UDF) Plugins Loadable functions can be included in component or plugin library files and installed on the ...
https://dev.mysql.com/doc/refman/9.7/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. To establish ...