Search Results
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
Note The accounts that are listed in the MySQL grant tables initially have no passwords. To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-local-connections.html
In addition to the CREATE USER statement, you can issue GRANT statements that give specific privileges to the account, although that is not necessary for the remaining steps in this procedure. The following procedure shows how to configure MySQL to ...
https://dev.mysql.com/doc/refman/8.4/en/lock-instance-for-backup.html
The BACKUP_ADMIN privilege is automatically granted to users with the RELOAD privilege when performing an in-place upgrade to MySQL 8.4 from an earlier version. LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
If a session issues a LOCK TABLES statement to acquire a lock while already holding locks, its existing locks are released implicitly before the new locks are granted. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. While held by one session, other sessions cannot obtain a lock of the same name.
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
Example: “To reload the grant tables, use the FLUSH PRIVILEGES statement.” Text in this style indicates input that you type in examples. This is the Reference Manual for the MySQL Database System, version 8.4, through release 8.4.6. Differences ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-windows-command-line-servers.html
Use this procedure: Make sure that each data directory exists, including its own copy of the mysql database that contains the grant tables. The procedure for starting a single MySQL server manually from the command line is described in Section ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-single-user-mode.html
Once the cluster has entered single user mode, only the designated API node is granted access to the database. Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-multi.html
For example, you might set up a common multi_admin account by executing the following commands for each server: $> mysql -u root -S /tmp/mysql.sock -p Enter password: mysql> CREATE USER 'multi_admin'@'localhost' IDENTIFIED BY 'multipass'; mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-admin.html
Access to this table should never be granted to any nonadministrative accounts. Database administrators should use the following guidelines to keep passwords secure. MySQL stores passwords for user accounts in the mysql.user system table. Account ...