PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-debian.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press OK; in that case, root access to the server is authenticated using the MySQL Socket Peer-Credential Authentication Plugin for connections ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-pkg.html
After a successful installation, the installer displays a window with your temporary root password. This cannot be recovered so you must save this password for the initial login to MySQL. For example: Figure 2.17 MySQL Package Installer Wizard: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
To run queries from the command line, you first need to log in to the MySQL Monitor in the usual way (specify the root password at the Enter password: prompt): $> mysql -u root -p Enter password: Welcome to the MySQL monitor. mysql> We simply use ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-logging.html
By default, the pattern list is "*IDENTIFIED*:*PASSWORD*", to ignore statements that refer to passwords. The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file.
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
PROCESS can be used to view the plain text of currently executing statements, including statements that set or change passwords. Privileges granted for the mysql system database itself can be used to change passwords and other access privilege ...
https://dev.mysql.com/doc/refman/5.7/en/test-pluggable-authentication.html
For example: $> mysql --user=testuser --password Enter password: testpassword The plugin fetches the password as received from the client and compares it with the value stored in the authentication_string column of the account row in the mysql.user ... MySQL includes a test plugin that checks account credentials and logs success or failure to the server error ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
For example: mysqld --initialize --datadir=/path/to/5.7-datadir Copy the temporary 'root'@'localhost' password displayed to your screen or written to your error log for later use. For example: mysqld_safe --user=mysql --datadir=/path/to/5.7-datadir ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/5.7/en/access-control.html
To control which users can connect, each account can be assigned authentication credentials such as a password. MySQL access control involves two stages when you run a client program that connects to the server: Stage 1: The server accepts or ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
All credentials are stored in the authentication_string column, including those formerly stored in the Password column. Before downgrading from MySQL 5.7, review the information in this section. System Table Changes InnoDB Changes Logging Changes ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
In this case, connect to s2 and issue: SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; SET SQL_LOG_BIN=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' \\ ...