[前][次][番号順一覧][スレッド一覧]

mysql:938

From: "Akinobu Yamamoto" <"Akinobu Yamamoto" <ayamamot@xxxxxxxxxx>>
Date: Fri, 4 Jun 1999 13:59:00 +0900
Subject: [mysql 00938] Re: 新規ユーザとその Database を設定したいのですが ...

民斗さん、初めまして。山本@inet-osakaです。
どうもありがとうございます。

とりあえずやってみたのですが、このような現象が起きてしまいます。
-----------------------------------------------------
$ su
Password:
# cd /usr/local/mysql/bin
# ls -al
total 4060
drwxr-xr-x   2 root     root         512 Apr 29 04:27 .
drwxr-xr-x  11 root     root         512 Jun  4 00:33 ..
-rwxr-xr-x   1 root     root       32632 Apr 29 04:27 comp_err
-rwxr-xr-x   1 root     root      167088 Apr 29 04:27 isamchk
-rwxr-xr-x   1 root     root        1474 Apr 29 04:27 msql2mysql
-rwxr-xr-x   1 root     root      243504 Apr 29 04:27 mysql
-rwxr-xr-x   1 root     root        4400 Apr 29 04:27
mysql_fix_privilege_tables
-rwxr-xr-x   1 root     root       15264 Apr 29 04:27 mysql_setpermission
-rwxr-xr-x   1 root     root        3024 Apr 29 04:27 mysql_zap
-rwxr-xr-x   1 root     root      105582 Apr 29 04:27 mysqlaccess
-rwxr-xr-x   1 root     root        1702 Oct  6  1997 mysqlaccess.conf
-rwxr-xr-x   1 root     root       71712 Apr 29 04:27 mysqladmin
-rwxr-xr-x   1 root     root        9192 Apr 29 04:27 mysqlbug
-rwxr-xr-x   1 root     root      962132 Apr 29 04:27 mysqld
-rwxr-xr-x   1 root     root       79992 Apr 29 04:27 mysqldump
-rwxr-xr-x   1 root     root      105628 Apr 29 04:17 mysqlimport
-rwxr-xr-x   1 root     root       68656 Apr 29 04:27 mysqlshow
-rwxr-xr-x   1 root     root       33528 Apr 29 04:27 perror
-rwxr-xr-x   1 root     root       41800 Apr 29 04:27 replace
-rwxr-xr-x   1 root     root       63852 Apr 29 04:19 resolveip
-rwxr-xr-x   1 root     root        4414 Apr 29 04:27 safe_mysqld
# ./mysql mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 77 to server version: 3.22.22

Type 'help' for help.

mysql>select * from db;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql>select * from user;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql>select * from host;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql>
-----------------------------------------------------
この場合、どうすればよろしいでしょうか?
ちなみにサーバはSun Solalis2.5.1だそうです。

    【山本 明信/ayamamot@xxxxxxxxxx】



[前][次][番号順一覧][スレッド一覧]

->     938 1999-06-04 13:59 ["Akinobu Yamamoto" <] Re: 新規ユーザとその Database  を設定したいのですが ...
       939 1999-06-04 15:12 ┣[民斗 <tommy@xxxxxxxx]                                       
       941 1999-06-04 15:51 ┗[Tomohiro Kato <tomop]                                       
       944 1999-06-04 16:53  ┗[Tomohiro Kato <tomop]