Search Results
https://dev.mysql.com/doc/internals/en/authentication-method.html
For earlier servers it is always Secure Password Authentication or Old Password Authentication depending on the CLIENT_SECURE_CONNECTION flag. Client and server negotiate what types of authentication they support as part of the connection phase.
https://dev.mysql.com/doc/internals/en/client-wants-native-server-wants-old.html
$ mysql --default-auth=mysql_native_password ## against a mysql_old_password user Initial Handshake Packet: 50 00 00 00 0a 35 2e 36 2e 34 2d 6d 37 2d 6c 6f P....5.6.4-m7-lo 67 00 5d 0a 00 00 66 5c 7b 74 55 2d 7b 4b 00 ff g.]...f\{tU-{K.. Handshake ...ff 08 02 00 0f c0 15 00 00 00 00 00 00 00 00 00 ...
https://dev.mysql.com/doc/internals/en/client-wants-old-server-wants-native.html
$ mysql --default-auth=mysql_old_password ## against a mysql_native_password user Initial Handshake Packet: 50 00 00 00 0a 35 2e 36 2e 34 2d 6d 37 2d 6c 6f P....5.6.4-m7-lo 67 00 5b 0a 00 00 6c 2e 3e 2f 6c 55 44 36 00 ff g.[...l.>/lUD6.. Handshake ...ff 08 02 00 0f c0 15 00 00 00 00 00 00 00 00 00 ...
https://dev.mysql.com/doc/internals/en/connection-phase-packets.html
username (string.fix_len) -- name of the SQL account which client wants to log in -- this string should be interpreted using the character set indicated by character set field. It is like Handshake Response Packet but is truncated right before ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-performanceschema-category.html
Table 7.27 Performance Schema Configuration Metrics NameDescriptionAccounts Size The number of rows in the accounts table. Lists the Performance Schema configuration metrics and provides a brief description of each. Digests Size The maximum number ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-oracle-mysql-discovery.html
If the permissions are incorrect, or the process is running under another user's account, some of these values do not auto-populate. Note The Properties section is auto-populated if the permissions and users are set up correctly. It is possible to ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/main-queries-reference.html
The following example is used by the Server Has Anonymous Accounts advisor: <class> <namespace>mysql</namespace> <classname>anonymous_user</classname> <query><![CDATA[SELECT COUNT(*) AS user_count FROM mysql.user WHERE user='']]></query> </class> In ... The main queries enable you to retrieve data from the monitored ...
https://dev.mysql.com/doc/connector-j/en/connector-j-using-mfa.html
When authenticating user accounts that require multiple passwords, up to three passwords can be specified using the Connector/J connection properties password1, password2, and password3 . This is a sample connection string that uses the three ...
https://dev.mysql.com/doc/workbench/en/wb-generating-php.html
The example scenario that follows demonstrates how to create PHP code. After combining the two, the generated PHP code will look like this: <?php $host = "localhost"; $port = 3306; $socket = ""; $user = "nobody"; $password = ""; $dbname = "sakila"; ... MySQL Workbench can be used to generate PHP code with the bundled PHP plugin, by using the Tools, Utilities, Copy as PHP Code menu ...
https://dev.mysql.com/doc/workbench/en/wb-linux-uninstalling.html
Note By default, the Workbench configuration directory is ~username/mysql/workbench/ where "~username" is the path to your user's home directory. Also, uninstalling Workbench does not remove the .mysqlworkbench schema that Workbench creates when ...