PDF (US Ltr)
- 27.1Mb
PDF (A4)
- 27.2Mb
HTML Download (TGZ)
- 7.2Mb
HTML Download (Zip)
- 7.2Mb
次のエラーが表示される場合は、通常、指定された名前のデフォルトデータベースにテーブルが存在しないことを意味します。
Table 'tbl_name' doesn't exist Can't find file: 'tbl_name' (errno: 2)
テーブルは存在しているが、誤った名前で参照している場合もあります。
MySQL はディレクトリおよびファイルを使用してデータベースおよびテーブルを格納しているため、大文字/小文字が区別されるファイル名を持つファイルシステムにデータベースおよびテーブルがある場合は、データベース名およびテーブル名で大文字/小文字が区別されます。
Windows などの大文字/小文字が区別されないファイルシステムの場合でも、クエリー内の特定のテーブルへのすべての参照で同じ表記を使用する必要があります。
デフォルトデータベースにあるテーブルを確認するには、SHOW TABLES を使用します。セクション13.7.5「SHOW 構文」を参照してください。
Can't open privilege tables, table 'mysql.host' doesn't exist
please read on.
On Window's systems, if you decide to save your data to a different directory than \mysql\data be sure to save the contents of the \your-mysql-base-dir\data to the directory you specified in your my.ini or my.cnf file. For example, I installed MySQL in C:\Program Files\MySQL. Therefore the original data directory was saved at C:\Program Files\MySQL\data. But I wanted the data to be saved in C:\My Documents\MySQL Data Files. So I modified the my.ini file to reflect this, but I was still having a problem trying to start the mysqld server. The error log kept saying: Can't open privilege tables, table 'mysql.host' doesn't exist. I had no idea what this ment. After hours of searching I decided to read further on in the MySQL manual. It says you need to save the contents of the original data directory to your new data directory. So I copied ...\data\mysql and its contents to my new data directory and everything works fine.
Hope this helps anyone with the same problem.
I was getting "Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist".
I set the following in D:\windows\my.ini
basedir=d:/programs/mysql/
datadir=d:/data/mysql/
I then copied the mysql directory from D:\programs\mySQL\data\ to d:\data\mysql, so I now have the original mysql data files in d:\data\mysql\mysql
It seems that d:\data\mysql is the base for all databases, and each directory below that is a database. MySQL expects to find a databse named mysql, which contains the privelege tables.
shell> bin/mysqld_safe --user=mysql --datadir=/usr/local/mysql/data &
Of course, if you use a different data path, then please replace that. I believe this is caused by a lack of /etc/my.conf file (I don't seem to have that file at all, perhaps part of my problem?). It took me a goodly amount of time to figure this out, and I don't think that I found any documentation anywhere that suggested it. By all accounts this is a very common problem, that many people don't seem to be able to fix.
Cheers,
Travis
mysql_install_db --basedir=/usr/local/mysql --user=mysql --ldata=/usr/local/mysql/var
then you can use
mysqld_safe --datadir=/usr/local/mysql/var --user=mysql
to resolve this, otherwise, the message is still there
After reading all the tips regarding a) moving the data files, and b) creating a dedicated user (MySQLservice) to log on to the MySQL service (which I did with no results), I found my problem was not renaming the default [mysqld] to [mysqld-nt] in my "my.ini" file. This solved it for me as I am using "mysqld-nt.exe and not mysqld.exe.
just wanted to add: I had the same problem on HP-UX 11.11. After creating the tables with "scripts/mysql_install_db" i then received "could not open and lock proc.frm" (Or was it user.frm?).
The db was created with the userrights "root:sys" on all files, so I had to change them to "mysql:mysql" and after that the DB is running perfectly.
Greetings from Germany,
Roy
Odd. If anyone has an explanation, I'd love to hear it.
Hope this helps someone else.
-Kevin
In dir "/var/lib/mysql" I had run the following commands:
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> mysql_install_db --user=mysql
It solved my problem.
130314 19:07:18 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
It means that this table was deprecated and your really cannot start MySQL 5.5 with data directory from MySQL 5.6.
Even if you copy necessary files from another MySQL 5.5 data directory, the MySQL 5.6 is not going to start, but will report different error.
However, you can start MySQL 5.6 server out of the MySQL 5.5 data directory.
Jacob Nikom