mysql:mysql $datadir
I honestly cannot think of a scenario where the datadir should be
permissioned any other way.
On 2012-10-29 6:26 AM, "javad bakhshi" wrote:
Hi,
I get an Unknown database error when I am trying to connect to mysql using
C API.
I have created the database in mysql prom
Hi,
I get an Unknown database error when I am trying to connect to mysql using C
API.
I have created the database in mysql prompt as root:
CREATE DATABASE Lr0;
I am pretty sure that the problem is a ownership issue, because when I do
ls -l in my datadir I get:
[javad64@udbl64 data]$ ls -l
We are getting a weird DROP DATABASE error
>>>>>>>>>
2007-06-10 11:25:41 db 527 DEBUGDROP DATABASE BCS
OperationalError: (1051, "Unknown table
'assignments,chemo,choicelists,dia,forms
,horm,id,permissions,qhistory,qnotes,qstates,questionnaires,r'
[EMAIL PROTECTED] wrote:
(response interspersed)
Boris Villazon <[EMAIL PROTECTED]> wrote on 10/14/2005
08:30:13 AM:
Hi
I am working with MySql 4.1.14 under Windows XP.
I am trying to do a database import from a file.
I have the following table definiton
CREATE TABLE attribute_instan
(response interspersed)
Boris Villazon <[EMAIL PROTECTED]> wrote on 10/14/2005
08:30:13 AM:
> Hi
>
> I am working with MySql 4.1.14 under Windows XP.
>
> I am trying to do a database import from a file.
>
> I have the following table definiton
>
> CREATE TABLE attribute_instance (
> name v
Hi
I am working with MySql 4.1.14 under Windows XP.
I am trying to do a database import from a file.
I have the following table definiton
CREATE TABLE attribute_instance (
name varchar(200) NOT NULL default '',
id int(11) NOT NULL default '0',
PRIMARY KEY (id,name),
KEY id (id,name),
KEY
AM
To: [EMAIL PROTECTED]
Subject: can't drop database: ERROR 1217
version: mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686)
mysql> DROP DATABASE xxx;
ERROR 1217: Cannot delete or update a parent row: a foreign key
constraint fails
what is this all about? how the heck can I drop the
version: mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686)
mysql> DROP DATABASE xxx;
ERROR 1217: Cannot delete or update a parent row: a foreign key
constraint fails
what is this all about? how the heck can I drop the database?
Dean Hoover
--
MySQL General Mailing List
For list archives: ht
I'm getting the following error while trying to install PostNuke ver.726 on
a w2k3 server that's running IIS6, MySQL 5 and PHP4.3.4. I've used both
MySQLCC and MySQLAdmin to create users with the necessary permissions to
connect to the databases. I even tried the command line using GRANT ALL
PRIVIL
Might sound like a silly question, but have you checked the write
permissions to the data dir? Am not sure if it is the mysql daemon that
needs write access or if it is the user logged on
"Colin O'Connor" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> I'm bundling My
Colin O'Connor wrote:
Hi,
I'm bundling MySQL with a Java app, and it is currently working on Windows
and Mac OS X. Right now I'm porting it to Solaris.
The problem I'm having is when I try to create a database ("CREATE DATABASE
mydb") I get the error: "ERROR 1006: Can't create database 'mydb'. (er
Hi,
I'm bundling MySQL with a Java app, and it is currently working on Windows
and Mac OS X. Right now I'm porting it to Solaris.
The problem I'm having is when I try to create a database ("CREATE DATABASE
mydb") I get the error: "ERROR 1006: Can't create database 'mydb'. (errno:
2)"
Using perro
Hi
I am trying to insert a record to SQLServer database and gettign the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
The name 'Mr' is not permitted in this context. Only constants, expressions, or
variables allowed here. Column names are not permitted
Any idea ?
Admin-Stress,
Tuesday, November 05, 2002, 12:41:08 AM, you wrote:
AS> After playing around with 'test' database, then I would like to create my own
database.
AS> I logged in into mysql using root account and created a database.
AS> But, when I logged in using regular user, I got his error :
AS
Try using
shell>mysqladmin -u root -p -h hostname databasetobecreated
password:
~Kelly W. Black
-Original Message-
From: Admin-Stress [mailto:meerkapot@;yahoo.com]
Sent: Monday, November 04, 2002 2:41 PM
To: [EMAIL PROTECTED]
Subject: newbie: creating database error
After play
try www.mysql.com, i heard they have docs there you can read...:)
-Original Message-
From: Admin-Stress [mailto:meerkapot@;yahoo.com]
Sent: Monday, November 04, 2002 1:41 PM
To: [EMAIL PROTECTED]
Subject: newbie: creating database error
After playing around with 'test' databa
After playing around with 'test' database, then I would like to create my own database.
I logged in into mysql using root account and created a database.
But, when I logged in using regular user, I got his error :
ERROR 1044: Access denied for user: '@localhost' to database 'card'
What necessar
n this email in no more than 24 hours
stating the reason of disagreement.
-Oorspronkelijk bericht-
Van: Chuck Amadi [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 9 juli 2002 10:38
Aan: [EMAIL PROTECTED]
Onderwerp: Access a M$ Access 2000 db with MySql-front - could not open
database error
Hi all im aware this might not be the correct forum but i believe it's
the same beast and it should be ansewered quite easily .
I have been creating a M$ Access Front-end database with a MySql
Back-end that im about to upload onto a ISP that supports Mysql/Php thus
i have just downloaded MySql-
Uhm, get a bigger HD stop
and move all DB/Files to that
and edit your my.cnf file
and restart?
:)
- Original Message -
From: "[EFR]The HEAD" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 11, 2002 5:38 PM
Subject: Database Error
> Hi,
&g
Hi,
the harddisk of the mysql server ran out of space. As it did so somebody
tried to write into some tables via the forum. Now there are three tables
marked as "still in use".
Everything we tried did not work - they are definitely not in use any more.
Even the debug mode we could do nothing to
18 Apr 2002 12:41:31 -0500
> To: MySQL <[EMAIL PROTECTED]>
> Subject: BSD: Random unknown database error
>
> All:
>
> Recently I've run into a problem where I intermittently receive an "Unknown
> database" error while attempting to communicate with
All:
Recently I've run into a problem where I intermittently receive an "Unknown
database" error while attempting to communicate with a local MySQL server.
I read through the mail list archives and discovered that others reported
similar problems under BSD, but I didn
Good Day:
Could someone help me and tell me which direction to
go to see why I'm getting unknown database error
caught by the SQLException catch. I checked to make
sure that the Class.forName was being executed and it
was. Just need a little helping hand. Thanks...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
With a bad syntax, i create a database named : Ysa2E3iU
mysql create it, but i can't drop it...?
there's a bug?
How can i do to drop it?
Thank's..
Davy
Azevedo
La Vie est l'art d'apprendre à mourir dignement
La Naissance est son Apothéose.
---
At 20:45 26/04/01 -0700, Brent and Maria wrote:
Hi,
I guess that your problem is the permission of the user that
you made the login. Take a look to permission properties
in the \mysql\data directory.
Regards,
Miguel
>Hello List,
> I have recently installed mysql 3.23.33 on my windows 200
Hello List,
I have recently installed mysql 3.23.33 on my windows 2000 machine. I
don't see anything in the documentation that I need to do to my machine for
setup (after the installation). I can run mysql fine, but it seems to be
only able to read. I want to create a new database.
I know you people are busy but I have seen this question a few times on the lists to
no avail. *see below*
It has been figured out by my admin.
It appears that one or more entries in the ACL tables is corrupt, when this happens so
its preventing logins.
So you have to replace the ACL with a f
Jason Guritz wrote:
>
> mysql> show databases;
> +---+
> | Database |
> +---+
> | directory |
> | mysql |
> | phpBB |
> | testdb |
> | trial |
> +---+
> 5 rows in set (0.00 sec)
>
> mysql> use testdb;
> ERROR 1049: Unknown database 'testdb'
>
> Keep
mysql> show databases;
+---+
| Database |
+---+
| directory |
| mysql |
| phpBB |
| testdb |
| trial |
+---+
5 rows in set (0.00 sec)
mysql> use testdb;
ERROR 1049: Unknown database 'testdb'
Keeps happening to me too.
It was working the day before :
30 matches
Mail list logo
