このページの翻訳:
ソースの表示
最近の変更サイトマップ

MySQLメモ

パスワード変更

SET PASSWORD FOR 'username'@'hostname' = PASSWORD('password');

ユーザー削除

DROP USER 'username'@'hostname';

ユーザー情報取得 mysql.userからSELECTする

> SELECT user,host,password FROM mysql.user;
+------------+-----------+-------------------------------------------+
| user       | host      | password                                  |
+------------+-----------+-------------------------------------------+
| root       | localhost | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| root       | 127.0.0.1 | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| root       | ::1       | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
+------------+-----------+-------------------------------------------+
11 rows in set (0.001 sec)
freebsd/db/mysql_tips.txt · 最終更新: 2019-08-19 11:03 by Decomo
CC Attribution-Noncommercial-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0