• 本文
• リロード
• 差分
• バックアップ
• 名前変更
• リファラ
• 新規ページ
• 編集

MySQL/テーブル

mysql.user

Top / mysql.user

ユーザの作成とか

• CREATE USER
• ALTER USER

初期データ

Ubuntu Server 20.04

• mysql> status
  --------------
  mysql  Ver 8.0.33-0ubuntu0.20.04.2 for Linux on x86_64 ((Ubuntu))
  
  Connection id:          15
  Current database:
  Current user:           root@localhost
  SSL:                    Not in use
  Current pager:          stdout
  Using outfile:          ''
  Using delimiter:        ;
  Server version:         8.0.33-0ubuntu0.20.04.2 (Ubuntu)
  Protocol version:       10
  Connection:             Localhost via UNIX socket
  Server characterset:    utf8mb4
  Db     characterset:    utf8mb4
  Client characterset:    utf8mb4
  Conn.  characterset:    utf8mb4
  UNIX socket:            /var/run/mysqld/mysqld.sock
  Binary data as:         Hexadecimal
  Uptime:                 2 hours 13 min 35 sec
  
  Threads: 3  Questions: 33  Slow queries: 0  Opens: 153  Flush tables: 3  Open tables: 72  Queries per second avg: 0.004
  --------------
  
  mysql> select user,host,plugin,authentication_string from mysql.user;
  +------------------+-----------+-----------------------+------------------------------------------------------------------------+
  | user             | host      | plugin                | authentication_string                                                  |
  +------------------+-----------+-----------------------+------------------------------------------------------------------------+
  | debian-sys-maint | localhost | caching_sha2_password | $A$005$&.04CJDi%M=uZmQ#1tzCM2VYxaaPMUudMo46ZalHwepin8Malqm7QW632tD.... |
  | mysql.infoschema | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
  | mysql.session    | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
  | mysql.sys        | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
  | root             | localhost | auth_socket           |                                                                        |
  +------------------+-----------+-----------------------+------------------------------------------------------------------------+
  5 rows in set (0.00 sec)

• debian-sys-maintのパスワードはLinux/etc/mysql/debian.cnfで定義されている

RHEL 9

• rootはパスワード空なのでmysql_secure_installationでセットする

  mysql> status
  --------------
  mysql  Ver 8.0.32 for Linux on x86_64 (Source distribution)
  Connection id:		8
  Current database:	
  Current user:		root@localhost
  SSL:			Not in use
  Current pager:		stdout
  Using outfile:		''
  Using delimiter:	;
  Server version:		8.0.32 Source distribution
  Protocol version:	10
  Connection:		Localhost via UNIX socket
  Server characterset:	utf8mb4
  Db     characterset:	utf8mb4
  Client characterset:	utf8mb4
  Conn.  characterset:	utf8mb4
  UNIX socket:		/var/lib/mysql/mysql.sock
  Binary data as:		Hexadecimal
  Uptime:			14 min 22 sec
  
  Threads: 2  Questions: 8  Slow queries: 0  Opens: 120  Flush tables: 3  Open tables: 39  Queries per second avg: 0.009
  --------------
  
  mysql> select user,host,plugin,authentication_string from mysql.user;
  +------------------+-----------+-----------------------+------------------------------------------------------------------------+
  | user             | host      | plugin                | authentication_string                                                  |
  +------------------+-----------+-----------------------+------------------------------------------------------------------------+
  | mysql.infoschema | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
  | mysql.session    | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
  | mysql.sys        | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
  | root             | localhost | caching_sha2_password |                                                                        |
  +------------------+-----------+-----------------------+------------------------------------------------------------------------+
  4 rows in set (0.00 sec)

メモ

• MySQL ユーザのホストをワイルドカードで指定してもlocalhostは含まれない
• http://b.l0g.jp/mysql/user-at-localhost/