방명록 소스를요... (PHP3으로 된...) 구해서 하라는대로 해서 깔려고 하다가 문제가 발생했는데요... table이 작성된 install.sql파일을 GB_DB라는 데이터 베이스에다가 만들라는 것이었는데 아래와 같이 하라고 해서 했는데 옵션이 필요하다더군요... 어떻게 해야할 지 좀 가르쳐 주세요...
[mysql@dp guestbook]$ mysql GB_DB < install.sql
/usr/local/mysql/bin/mysql Ver 9.32 Distrib 3.22.22, for pc-linux-gnu (i686)
By TCX Datakonsult AB, by Monty
This software comes with ABSOLUTELY NO WARRANTY.
Usage: /usr/local/mysql/bin/mysql [OPTIONS] [database]
-A, --no-auto-rehash No automatic rehashing. One has to use 'rehash' to
get table and field completion. This gives a quicker
start of mysql.
-B, --batch Print results with a tab as separator, each row on
a new line. Doesn't use history file
-C, --compress Use compression in server/client protocol
-T, --debug-info Print some debug info at exit
-e, --execute=... Execute command and quit.(Output like with --batch)
-f, --force Continue even if we get an sql error.
-i, --ignore-space Ignore space after function names
-?, --help Display this help and exit
-h, --host=... Connect to host
-n, --unbuffered Flush buffer after each query
-O, --set-variable var=option
Give a variable an value. --help lists variables
-o, --one-database Only update the default database. This is useful
for skipping updates to other database in the update
log.
-p[password], --password[=...]
Password to use when connecting to server
If password is not given it's asked from the tty.
-P --port=... Port number to use for connection
-q, --quick Don't cache result, print it row by row. This may
slow down the server if the output is suspended.
Doesn't use history file
-r, --raw Write fields without conversion. Used with --batch
-s, --silent Be more silent.
-L, --skip-line-numbers Don't write line number for errors
-N, --skip-column-names Don't write column names in results
-S --socket=... Socket file to use for connection
-t --table=... Output in table format
-u, --user=# User for login if not current user
-v, --verbose Write more (-v -v -v gives the table output format)
-V, --version Output version information and exit
-E, --vertical Print the output of a query (rows) vertically
-w, --wait Wait and retry if connection is down
Possible variables for option --set-variable (-O) are:
max_allowed_packet current value: 25165824l
net_buffer_length current value: 16384l
그래서 이번엔 mysql로 들어가서 database를 만들려했더니만 ... 아래처럼 나오네요...
설정파일을 고쳐줘야 되는 것 같은데.. 어떤 파일을 건드리면 되죠?
mysql> create database GB_DB;
ERROR 1044: Access denied for user: '@localhost' to database 'GB_DB'
아시는 분 부디 부탁합니다.... 감사합니다.
|