[Laravel 6.x]Route::get()で設定したURLパラメーターの取得
Laravel6.xでRoute::get('/path/to/{id}')で設定したidの取得方法について。
HOME>WEBプログラム覚書>[MySQL]ユーザ発行2
[MySQL]ユーザ発行2
MySQLのユーザーに関する操作メモ。
現在のユーザーを確認
MYSQL
- mysql> SELECT user();
- +----------------+
- | user() |
- +----------------+
- | root@localhost |
- +----------------+
- 1 row in set (0.00 sec)
MySQLのユーザー情報はmysqlデータベースのuserテーブルに格納されている。どんな情報を持っているかというと
MYSQL
- mysql> SHOW COLUMNS FROM mysql.user;
- +------------------------+-----------------------------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +------------------------+-----------------------------------+------+-----+---------+-------+
- | Host | char(60) | NO | PRI | | |
- | User | char(16) | NO | PRI | | |
- | Password | char(41) | NO | | | |
- | Select_priv | enum('N','Y') | NO | | N | |
- | Insert_priv | enum('N','Y') | NO | | N | |
- | Update_priv | enum('N','Y') | NO | | N | |
- | Delete_priv | enum('N','Y') | NO | | N | |
- | Create_priv | enum('N','Y') | NO | | N | |
- | Drop_priv | enum('N','Y') | NO | | N | |
- | Reload_priv | enum('N','Y') | NO | | N | |
- | Shutdown_priv | enum('N','Y') | NO | | N | |
- | Process_priv | enum('N','Y') | NO | | N | |
- | File_priv | enum('N','Y') | NO | | N | |
- | Grant_priv | enum('N','Y') | NO | | N | |
- | References_priv | enum('N','Y') | NO | | N | |
- | Index_priv | enum('N','Y') | NO | | N | |
- | Alter_priv | enum('N','Y') | NO | | N | |
- | Show_db_priv | enum('N','Y') | NO | | N | |
- | Super_priv | enum('N','Y') | NO | | N | |
- | Create_tmp_table_priv | enum('N','Y') | NO | | N | |
- | Lock_tables_priv | enum('N','Y') | NO | | N | |
- | Execute_priv | enum('N','Y') | NO | | N | |
- | Repl_slave_priv | enum('N','Y') | NO | | N | |
- | Repl_client_priv | enum('N','Y') | NO | | N | |
- | Create_view_priv | enum('N','Y') | NO | | N | |
- | Show_view_priv | enum('N','Y') | NO | | N | |
- | Create_routine_priv | enum('N','Y') | NO | | N | |
- | Alter_routine_priv | enum('N','Y') | NO | | N | |
- | Create_user_priv | enum('N','Y') | NO | | N | |
- | Event_priv | enum('N','Y') | NO | | N | |
- | Trigger_priv | enum('N','Y') | NO | | N | |
- | Create_tablespace_priv | enum('N','Y') | NO | | N | |
- | ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
- | ssl_cipher | blob | NO | | NULL | |
- | x509_issuer | blob | NO | | NULL | |
- | x509_subject | blob | NO | | NULL | |
- | max_questions | int(11) unsigned | NO | | 0 | |
- | max_updates | int(11) unsigned | NO | | 0 | |
- | max_connections | int(11) unsigned | NO | | 0 | |
- | max_user_connections | int(11) unsigned | NO | | 0 | |
- | plugin | char(60) | NO | | | |
- | authentication_string | text | NO | | NULL | |
- +------------------------+-----------------------------------+------+-----+---------+-------+
- 42 rows in set (0.00 sec)
というかんじ。
登録されているユーザー名とホスト、パスワードを表示
MYSQL
- mysql> SELECT User, Host, Password FROM mysql.user;
- +---------+-----------+-------------------------------------------+
- | User | Host | Password |
- +---------+-----------+-------------------------------------------+
- | root | localhost | |
- | root | 127.0.0.1 | |
- | | localhost | |
- | pma | localhost | |
- | test_db | % | *8D918886CC290839B6B9628AE3737DD292620E06 |
- | test_db | localhost | *8D918886CC290839B6B9628AE3737DD292620E06 |
- +---------+-----------+-------------------------------------------+
- 6 rows in set (0.00 sec)
| 投稿日 | 2011年9月 8日 01:49 |
|---|---|
| カテゴリ | MySQL |
| タグ | SQL | データベース | 構文 |
| トラックバック URL | http://www.kantenna.com/cgi-bin/mt504/mt-tb.cgi/1234 |
コメント