Hi Andrew,
You can do this with MySQL Administrator, but you have to look for
Catalogs in the left pane. After that right click in the bottom part of
the left pain and select 'Create Schema'. Provide a database name and
click on ok. That should do the trick.
Arjan
On Sun, 2008-09-21 at 21:26 -0
-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2007 7:09 AM
To: Lopez, Denise; mysql@lists.mysql.com
Subject: Re: Database creation question
You might try issueing a FLUSH PRIVILEGES command instead of restarting.
This is supposed to be implicit when you use the GRANT
OTECTED]>
To:
Sent: Tuesday, March 20, 2007 7:55 PM
Subject: RE: Database creation question
That still didn't work. I think I just need to restart the mysql
service.
Denise Lopez
UCLA Center for Digital Humanities
Network Services
Systems Engineer
337 Charles E. Young Drive East
PPB
Subject: Re: Database creation question
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create user use :
mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%"
IDENTIFIED BY 'PASSWORD
uardo Moreno [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 20, 2007 4:03 PM
To: Lopez, Denise
Cc: mysql@lists.mysql.com
Subject: Re: Database creation question
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create use
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create user use :
mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%"
IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
Regards,
Juan Eduardo
On 3/20/07, Lopez
> -Original Message-
> From: Tim Traver
> Sent: Tuesday, February 15, 2005 19:30
> To: mysql@lists.mysql.com
> Subject: Database creation privileges
>
> Hi all,
>
> ok, I thought I had it figured out.
>
> I am using 4.1.9 now, and it looks like it behaves a little bit
> differently (or
