[HOME] [github] [twitter] [blog] [fml4] [fml8] [北海道] Powered by NetBSD and [nuinui.net] .

MySQL で ユーザ fukachan を作る

#cat adduser.sql
INSERT INTO user
VALUES ('beth.fml.org','fukachan',Password('uja'),'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N');
# cat adduser.sql | mysql -u root mysql
# mysqldump -u root mysql|tail
#
# Dumping data for table 'user'
#

INSERT INTO user VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','\
Y');
INSERT INTO user VALUES ('elena.fml.org','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'\
,'Y','Y','Y','Y');
INSERT INTO user VALUES ('localhost','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO user VALUES ('elena.fml.org','','','N','N','N','N','N','N','N','N','N','N','N'\
,'N','N','N');
INSERT INTO user VALUES ('beth.fml.org','fukachan','67f2c39a3eec9f4f','Y','Y','Y','Y','N',\
'N','N','N','N','N','N','N','N','N');

変更後は mysql の reload が必要であることに注意して下さい。

# mysqladmin reload
reload しないと beth.fml.org からアクセスすると弾かれます。
% mysql -h elena.fml.org
ERROR 1130: Host 'beth.fml.org' is not allowed to connect to this MySQL server

では、アクセスしてみよう

% mysql -h elena.fml.org -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 23 to server version: 3.22.32-log

Type 'help' for help.

mysql> 
OK アクセスできた。

[HOME] [github] [twitter] [blog] [fml4] [fml8] [北海道] Powered by NetBSD and [nuinui.net] .
Copyright (C) 1993-2022 Ken'ichi Fukamachi mail:< fukachan at fml.org >