remcy007 said:
I am getting this error in MySQL when we try to create table in it.
ERROR:
DBI/DBD Error:
Can't execute SQL statement:
Can't create table 'MASTER1' (errno: 13)
DBI/DBD Error:
Can't execute SQL statement:
Can't create table 'ABMASTER1' (errno: 13)
Any clues??
MySQL version is 4.1.21
ok i hv come accross this issue before hand and you wont beleive what was causing this.
a previous installation in the same location.
i had selected InnoDB as my storage engine and it creates transaction logs (files basically which store the transaction data since InnoDB is a Transaction enabled DBMS) which persisted through to my next installation.
And I got these errors + many more (like authentication error, et cetera.)
My first line of attack towards this issue would be a uninstallation followed by deletion of the directory in which MySQL was installed. Then download latest version of MySQL from
MySQL AB :: The world's most popular open source database and install it (i believe its 5.1, much better and scalable compared to 4.x and has support for triggers, stored procedures and many more)
However, if this is not the issue, I beleive you dont have read access to the "sys" tables. As "METADATA" about the tables you create (like information about the columns, the datatypes, the primary + foreign keys, indices etc) also need to be stored in some table, the problem could be manifesting itself because the engine (same as the MySQL backend) is unable to create the requisite meta data to describe the table and thus you are not able to create the tables.
Any ways, try boh approaches and report back.