MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 16 of 16 total results

« Previous
1
2
Next »

https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html

If you used --initialize-insecure to initialize the data directory, connect to the server as root without a password: mysql -u root --skip-password After connecting, use an ALTER USER statement to assign a new root password: ALTER USER ... After ...

2.9.4 Securing the Initial MySQL Account

https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html

Connect to the server as root using no password: $> mysql -u root --skip-password Assign a password: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password'; After assigning the root account a password, you must supply that password ...

8.4.1.11 FIDO Pluggable Authentication

https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html

Suppose that you execute a statement like this: CREATE USER 'u2'@'localhost' IDENTIFIED WITH authentication_fido; Subsequent attempts to use the account to connect fail like this: $> mysql --user=u2 --skip-password Failed to open FIDO device. Note ...

6.6.8 mysql_migrate_keyring — Keyring Key Migration Utility

https://dev.mysql.com/doc/refman/8.0/en/mysql-migrate-keyring.html

To explicitly specify that there is no password and that mysql_migrate_keyring should not prompt for one, use the --skip-password option. The mysql_migrate_keyring utility migrates keys between one keyring component and another. Invoke ...

6.4.5 mysql_upgrade — Check and Upgrade MySQL Tables

https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html

To explicitly specify that there is no password and that mysql_upgrade should not prompt for one, use the --skip-password option. Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, ...

6.6.9 mysqlbinlog — Utility for Processing Binary Log Files

https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html

To explicitly specify that there is no password and that mysqlbinlog should not prompt for one, use the --skip-password option. The server's binary log consists of files containing “events” that describe modifications to database contents. To ...