MariaDB 10.3 ¥æ¡¼¥¶´ÉÍý
http://extstrg.asabiya.net/pukiwiki/index.php?MariaDB%2010.3%20%A5%E6%A1%BC%A5%B6%B4%C9%CD%FDÌܼ¡ †
³µÍ× †
MariaDB¤Ë¤ª¤±¤ë¥æ¡¼¥¶´ÉÍý¤ÎTips
¥æ¡¼¥¶ºîÀ® †
create user [USER]@[HOST] identified by '[PASSWORD]';
¥æ¡¼¥¶¤Ø¤Î¸¢¸ÂÉÕÍ¿ †
grant [¸¢¸Â] privileges on [DB NAME].* to [USER]@[HOST];
¥æ¡¼¥¶ºï½ü †
drop user [USER]@[HOST]
¥æ¡¼¥¶°ìÍ÷ †
select user,host from mysql.user;
- ½ÐÎÏ·ë²Ì
+--------+-----------+ | user | host | +--------+-----------+ | root | 127.0.0.1 | | root | ::1 | | root | localhost | +--------+-----------+
Last-modified: 2022-07-18 (·î) 16:28:38 (646d)