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
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
Hi
Look at the sample database.
try this
create.sql==
# Change user and password to add privileges for different user.
# Note that user with no hostname given is equivalent to specifying
# "%" as the hostname.
GRANT ALL ON pool.* TO contact;
DROP DATABASE IF EXI
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
