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

MySQL に新しいデータベース ML を作る

# mysqladmin -u root create ML
Database "ML" created.
# ls -l /var/mysql/
total 34
drwx------  2 root  wheel    512 Jun 21 15:21 ML
-rw-rw----  1 root  wheel  29019 Jun 21 15:21 elena.log
-rw-r--r--  1 root  wheel      5 Jun 21 14:21 elena.pid
-rw-r--r--  1 root  wheel     95 Jun 21 14:21 elena.fml.org.err
drwx------  2 root  wheel    512 Jun 21 14:20 mysql
drwx------  2 root  wheel    512 Jun 21 14:20 test
# ls -l /var/mysql/ML
つまり最初はなにもないわけです。

# mysqlshow ML  
Database: ML
+--------+
| Tables |
+--------+
+--------+
この状態で、beth から無理矢理アクセスしてみると
% mysql -h elena -p ML
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 3.22.32-log

Type 'help' for help.

mysql> select * from user
    -> go
ERROR 1146: Table 'ML.user' doesn't exist
mysql> 
こういうエラーになります。

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