Re: Newbie question on creating a database

day, October 06, 2003 4:17 PM Subject: Newbie question on creating a database > When I type the command: > CREATE DATABASE testing; > > I get a 1044 access denied error, stating that access is denied for user > '[EMAIL PROTECTED]' to database 'testing' > > Why

Newbie question on creating a database

When I type the command: CREATE DATABASE testing; I get a 1044 access denied error, stating that access is denied for user '[EMAIL PROTECTED]' to database 'testing' Why cant i create a database? I made one before, so why not now? thanks, dan -- MySQL General Mailing List For list archives:

Re: How to prevent a user from dropping/creating a database

Jeremy Zawodny wrote: On Wed, Apr 02, 2003 at 01:46:00PM -0800, Chris Jaeger wrote: Hi all, I'm wondering if there is some way to setup privileges in the grant tables such that a user can create or drop any arbitrary table in databases that user is associated with, but be unable to create or

Re: How to prevent a user from dropping/creating a database

On Wed, Apr 02, 2003 at 01:46:00PM -0800, Chris Jaeger wrote: > Hi all, > > I'm wondering if there is some way to setup privileges in the grant > tables such that a user can create or drop any arbitrary table in > databases that user is associated with, but be unable to create or drop > t

How to prevent a user from dropping/creating a database

Hi all, I'm wondering if there is some way to setup privileges in the grant tables such that a user can create or drop any arbitrary table in databases that user is associated with, but be unable to create or drop the databases themselves. I was hoping the tables_priv table would come to my r

Re: RE: creating a database without being an administrator

Josh, Friday, August 16, 2002, 12:18:46 AM, you wrote: JZ> is there a way to give certain users rights to create and drop mysql JZ> databases JZ> without being administrators? JZ> I'd like to create a new database every time a user runs my code on a JZ> new set of data. To create and drop datab

RE: creating a database without being an administrator

is there a way to give certain users rights to create and drop mysql databases without being administrators? I'd like to create a new database every time a user runs my code on a new set of data. thanks Josh - Before po

Re: Creating a database

Andrew, What you have done is correct. A database is merely a container. A container which is empty until you fill it will tables and then populate those tables with data. Regards, Jonathan Duncan Andrew Conkling <[EMAIL PROTECTED]> said: > I am trying to host a message board through a se

Creating a database

I am trying to host a message board through a service from www.phpbb.com. To install it, I need to create a blank mySQL database. I've perused the documentation and have not been able to figure out how. When I have "succeeded", it seems all that is created is an empty folder with the name I gave t

Re: Problem creating a database with my ISP

On 13 Aug 2001 21:36:47 -0700, Manuel Velasco wrote: > I am trying to create a database in my account at an > ISP with a Unix Solaris server. > > The error message: > > mydomain.com% mysqladmin create newdb > /usr/local/mysql/bin/mysqladmin: create of 'newdb' > failed > error: 'Access denied for

Problem creating a database with my ISP

I am trying to create a database in my account at an ISP with a Unix Solaris server. The error message: mydomain.com% mysqladmin create newdb /usr/local/mysql/bin/mysqladmin: create of 'newdb' failed error: 'Access denied for user: '@localhost' to database 'newdb'' mydomain.com% Could someone h