Hi,
I've installed MySQL 5.0.27, but can't create databases.
I get ERROR 1006 (HY000): Can't create database 'contineo' (errno: 28)
In the log file i have this:
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified
/Eastern
Subject: Can't create database
Hi,
I've installed MySQL 5.0.27, but can't create databases.
I get ERROR 1006 (HY000): Can't create database 'contineo' (errno: 28)
In the log file i have this:
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded
Mário Gamito wrote:
Hi,
I've installed MySQL 5.0.27, but can't create databases.
I get ERROR 1006 (HY000): Can't create database 'contineo' (errno: 28)
In the log file i have this:
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB
to
phpAdmin and reset that password so that I know what it is from now on?
Thanks again!
Jordan
Tom Crimmins wrote:
[snip]
I'm using version 3.23.58. I tried to create a database foo using
phpAdmin(logged in as root) and got:
ERROR 1006: Can't create database 'foo'. (errno: 13)
...
drwx--x--x 2
[snip]
How can find the user mysql password? The hosting company which I got the
dedicated server package from set that up of course. Should I go to phpAdmin
and reset that password so that I know what it is from now on?
[/snip]
The mysql linux user should not be able to login interactivly, just
Thanks! That makes senses. And once I chmod as instructed, I can create
directory in the mysql folder.
Tom Crimmins wrote:
[snip]
How can find the user mysql password? The hosting company which I got the
dedicated server package from set that up of course. Should I go to phpAdmin
and reset that
Hi,
I'm really stuck here. I'm using version 3.23.58. I tried to create a
database foo using phpAdmin(logged in as root) and got:
ERROR 1006: Can't create database 'foo'. (errno: 13)
I checked [EMAIL PROTECTED] in the user table and it has all priviledges.
Went to linux and logged in as root
[snip]
I'm using version 3.23.58. I tried to create a database foo using
phpAdmin(logged in as root) and got:
ERROR 1006: Can't create database 'foo'. (errno: 13)
...
drwx--x--x 2 mysql root 4096 Sep 15 10:34 mysql
[/snip]
perror 13
Error code 13: Permission denied
File permissions look ok
ERROR 1006: Can't create database 'foo'. (errno: 13)
errno 13 is 'Permission denied'
drwx--x--x 2 mysql root 4096 Sep 15 10:34 mysql
locate the directory that contains the 'test' and 'mysql' databases.
This will be the directory that you do not have permission to
write in for mysql
Ok got MySQL running and I have MyODBC installed as well. In any event. I
have the test database and I can see it. I need to create a new database
and it is not letting me do that. It tells me access denied for user ' ' @'
localhost. I used the syntax mysqladmin create database databasename.
It looks like you didn't specify a user. Try this:
mysql -u root -p
It will prompt you for the password that you set up for the root account. After you
enter it you will get a mysql prompt.
Now type:
create database newdatabase;
This will create a new database called newdatabase. You can
data to data in the other volume
and not anymore
as it was to var in the same volume before. I copied
all files and
directories of var in this new directory -data-. I
changed with mysql
mysql all this file and directories (group and owner).
And I made :
create database X;
ERROR 1006: Can't create
and
directories of var in this new directory -data-. I
changed with mysql
mysql all this file and directories (group and owner).
And I made :
create database X;
ERROR 1006: Can't create database 'X'. (errno: 13)
I hope what I explain is clear!
What did I forget ?
Do I have to put also var in this new other
All:
I have been trying to just simply create a database
and I receive the following error:
mysql create database MyCollection;
ERROR 1006: Can't create database 'MyCollection'. (errno: 13)
I know it is a privilege problem but I cannot figure out where
it is located. i have tried creating
What does df show?
-Original Message-
From: John Lepone [mailto:[EMAIL PROTECTED]]
Sent: 17 December 2001 20:41
To: '[EMAIL PROTECTED]'
Subject: Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
I don't think I'm out of room on the volume. Below is the directory
listing
;
ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
mysql
Likewise, if I try to add a table to an existing DB I get the following:
mysql use test;
Database changed
mysql CREATE TABLE mynewtable (mycolumn int
mysql CREATE DATABASE mynewdb;
ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
mysql
[carsten@tsort carsten]$ perror 28
Error code 28: No space left on device
- Maybe clearing up some disk space would help???
/ Carsten
--
Carsten H
CREATE DATABASE mynewdb;
ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
mysql
Likewise, if I try to add a table to an existing DB I get the following:
mysql use test;
Database changed
mysql CREATE TABLE
' to clear the
| buffer.
|
| mysql CREATE DATABASE mynewdb;
| ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
| mysql
|
|
| Likewise, if I try to add a table to an existing DB I get the following:
|
| mysql use test
I don't think I'm out of room on the volume. Below is the directory
listing:
-rw-rw1 mysqlmysql 0 Dec 13 07:09 mandrake-bin.001
-rw-rw1 mysqlmysql 0 Dec 13 07:12 mandrake-bin.002
-rw-rw1 mysqlmysql 0 Dec 13 07:17 mandrake-bin.003
Hi John,
Just listing the files and directories in your data directory won't
tell you (or anyone else here) if you're out of disk space.
Try:
$ df -k
to show your disk free space in K.
or, if you're in a directory, try
$ du -sk *
to show you a disk usage summary, in K, of the things in the
the error:
mysqladmin: Create failed; error: 'Can't create database 'dbName'. (errno:
13)'
Has anyone run into this? I am making a beginner mistake? I would
appreciate any one to point me in the right direction.
Thanks,
Brent
. I try to do this in
mysql and using mysqladmin create dbName. I get the error:
mysqladmin: Create failed; error: 'Can't create database 'dbName'. (errno: 13)'
Has anyone run into this? I am making a beginner mistake? I would
appreciate any one to point me in the right direction
23 matches
Mail list logo