2

More than 5 years have passed since last update.

mysqlに登録されているユーザ一覧を確認したい

MySQL

Last updated at 2015-12-22Posted at 2015-12-22

概要

MySQLに登録されているユーザの一覧を見たい

SQLの例

対象のMySQLサーバへroot権限でログイン後下記のSQLを実行

select User,host from mysql.user;

結果


mysql> select user,host from mysql.user;
+--------------+-----------+
| user         | host      |
+--------------+-----------+
| root         | 127.0.0.1 |
| root         | ::1       |
| root         | localhost |
+--------------+-----------+
3 rows in set (0.00 sec)

2

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

2