Marty,
I've copied the list on this reply. I hope you don't mind. It's a good
idea to keep the discussion on the list. There are a lot of experts
there, so the speed and quality of your answers is improved when you
send to the list rather than to an individual. Plus, others may benefit
fro
mysql wrote:
HI everyone:
I am using a dual 800 MHz power mac G4 in which I have installed MySQL.
When ever I try to create a new database in MySQL, I receive the
following error
"mysql> create database dogs;
ERROR 1044 (42000): Access denied for user: ''@'localhost' to database
'dogs'"
You a
Make sure that you have persmission to create database.
Check MySQL manual:
http://www.mysql.com/doc/en/index.html
From: mysql <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Error creating database
Date: Sat, 7 Feb 2004 19:00:54 -0500
HI everyone:
I am using a dual 800 MHz power mac
HI everyone:
I am using a dual 800 MHz power mac G4 in which I have installed MySQL.
When ever I try to create a new database in MySQL, I receive the
following error
"mysql> create database dogs;
ERROR 1044 (42000): Access denied for user: ''@'localhost' to database
'dogs'"
Can anyone assist
lol mysqladmin -u root -p create database desenv ??
> Hi,
>
> I was received a error when I was trying to create a new database on
> freebsd 5.1, mysql 4.0.14. The "test" database is working well.
>
> COMMAND:
> mysqladmin create desenv
> or
> mysql
> create database desenv;
>
> ERROR:
> mysqladmi
"Paulo Fonseca Jr." <[EMAIL PROTECTED]> wrote:
>
> I was received a error when I was trying to create a new database on freebsd
> 5.1, mysql 4.0.14. The "test" database is working well.
>
> COMMAND:
> mysqladmin create desenv
> or
> mysql
> create database desenv;
>
> ERROR:
> mysqladmin: CREA
Hi,
I was received a error when I was trying to create a new database on freebsd
5.1, mysql 4.0.14. The "test" database is working well.
COMMAND:
mysqladmin create desenv
or
mysql
create database desenv;
ERROR:
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
'@localhost' t
/User_Account_Management.html
HTH
Peter
-Original Message-
From: Ed Dulaney [mailto:[EMAIL PROTECTED]
Sent: 22 July 2003 23:50
To: Mysql
Subject: Error creating database
I get the following error when trying to create a database. Being a total
newbie to MySQL I would appreciate any help I
I get the following error when trying to create a database. Being a total
newbie to MySQL I would appreciate any help I can get!
---
[EMAIL PROTECTED] bobo]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 129 to s
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
rdkurth,
Tuesday, September 17, 2002, 9:43:37 AM, you wrote:
rasdn> I have a brand new install of mysql . I have set every thing up just
rasdn> like I have on many Linux server but this one I am getting an error
rasdn> when I try to create a database from the Command line from and PHP
rasdn> scri
I have a brand new install of mysql . I have set every thing up just
like I have on many Linux server but this one I am getting an error
when I try to create a database from the Command line from and PHP
script or from phpMyAdmin. Could somebody tell me what this error
is and how I can fix it. I
Yes, it is possible unless you insist on using an unimaginative, strict,
interpretation of what Info wrote.
Mechanism 1: Create a separate database server for each database. You
can create servers wherever you want.
Mechanism 2, which might not work, but might be worth a try: assuming a
si
Sure it is. It's just TRICKY. :)
step 1. Create database.
step 2. Move database to users' homedir
step 3. Symlink $USERHOME/databasedir/ to $MYSQLDATADIR
Alexander Barkov wrote:
> This is not possible.
>
> Info wrote:
>
>> sql,query
>>
>> How can i have each users database to be stored i
This is not possible.
Info wrote:
> sql,query
>
> How can i have each users database to be stored in it's home dir ?
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists
Setup a user level my.cnf file and make sure the data dir isn't overriden by
the other levels of my.cnf
Just a theory, I haven't tested it !
-Original Message-
From: Info [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2002 15:17
To: [EMAIL PROTECTED]
Subject: Re: creating database
As i selling web hosting with mysql as a package, and i like to restrict on
the amount of space used. I had setup quotas on the plans. How can i create
databases to the user's account, home dir, so that the customer can check
his quota.
Or how should i go about restricting?
sql,query
-
sql,query
How can i have each users database to be stored in it's home dir ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Jeremy Morano writes:
> GRANT ALL ON pool.* TO contact
>
> CREATE DATABASE pool;
>
> The result was access denied...
>
> What do I do?
A user can of course not grant himself access to things.
You need to do those things as a user with global CREATE
and GRANT privileges. Read the manual on ho
ginal Message -
From: "Jeremy Morano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 25 September 2001 16:38
Subject: creating database
>
> Hi there,
>
> I'm having a hard time creating a databae...
>
> My db name is pool and my mySql username
Hi there,
I'm having a hard time creating a databae...
My db name is pool and my mySql username is contact.
This is what I did...
GRANT ALL ON pool.* TO contact
CREATE DATABASE pool;
The result was access denied...
What do I do?
-
I created a script to create a table.
The script is as follows:
===
use Contacts;
CREATE TABLE Lead (lastname varchar(50), firstname
varchar(50), title varchar(200), company
varchar(200),
telephone_work varchar(15), telephone_home
varchar(15),
fax varchar(15), email varchar(100), a
Hai,
i want to create database in mysql with user permission,pls. help me out.
Regards
sakthi.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
ROTECTED]>
> To: "Ana Elisa Martinez" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, May 15, 2001 10:57 PM
> Subject: Re: Error creating database
>
>
> > I also get somthing like that,
> > much mor productive
dont you mean:
create database gnudip2;
create table table1 (id int(10),some_colum varchar(255));
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Ana Elisa Martinez" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 10:57 PM
I also get somthing like that,
much mor productive to do somthing like
create database gnudip2(id int(10),some_colum varchar(255));
Trying to show that you add columns with the same command.
Darrell
On Tue, 15 May 2001, Ana Elisa Martinez wrote:
> When i try to create a database with the
create database gnudip2;
make sure you have the right permissions as well!
- Original Message -
From: "Ana Elisa Martinez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 9:09 PM
Subject: Error creating database
When i try to crea
mysql> create database gnudip2;
> When i try to create a database with the command :
>
> mysql> create gnudip2;
>
> Told me an error :
>
> ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1
>
> Why this error ??, What is wrong ??
>
> Thanks
> Ana Elisa Martinez
>
>
>
>
--
try:
mysql>CREATE DATABASE gnudip2;
>From: "Ana Elisa Martinez" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Error creating database
>Date: Tue, 15 May 2001 16:09:09 -0400
>
>When i try to create a database with the command :
>
>mysq
how 'bout read manual
create database a
- Original Message -
From: "Ana Elisa Martinez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 15, 2001 4:09 PM
Subject: Error creating database
When i try to create a database with the command :
mysq
When i try to create a database with the command :
mysql> create gnudip2;
Told me an error :
ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1
Why this error ??, What is wrong ??
Thanks
Ana Elisa Martinez
Am 17:44 30.03.2001 schrieb Herman Pool:
>Hi out there,
>
>I'm new with MySQL.
>I have installed Linux 6.0 and MySQL 3.23.33
>
>This happens when I want to create a database:
>
>[mysql@nestorix mysql]$ mysql
>Welcome to the MySQL monitor. Commands end with ; or \g.
>Your MySQL connection id is 49
On Fri, 30 Mar 2001, Herman Pool wrote:
> Hi out there,
>
> I'm new with MySQL.
> I have installed Linux 6.0 and MySQL 3.23.33
>
> This happens when I want to create a database:
>
> [mysql@nestorix mysql]$ mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection
Hi out there,
I'm new with MySQL.
I have installed Linux 6.0 and MySQL 3.23.33
This happens when I want to create a database:
[mysql@nestorix mysql]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49 to server version: 3.23.33
Type 'help;' or '\h' for
37 matches
Mail list logo
