Re: [PHP-DB] Weird Windows SQL

2002-04-24 Thread Michael K. Dolan Jr.

I can create new databases if I create them from the command line logging
into mysql as root. However, I'm new to the GUI and I guess I would like to
login to the GUI as root. Do you know how to do this?


- Original Message -
From: "Peter Lovatt" <[EMAIL PROTECTED]>
To: "Michael K. Dolan Jr." <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2002 7:55 PM
Subject: RE: [PHP-DB] Weird Windows SQL


> have you set up permissions for the user you are connecting as?
> see  GRANT in the MySql manual. The test bit is a default setting for
users
> with no privileges (from my slightly rusty memory)
>
> HTH
>
> Peter
>
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> www.sunmaia.net
> [EMAIL PROTECTED]
> tel. 0121-242-1473
> ---
>
> > -Original Message-
> > From: Michael K. Dolan Jr. [mailto:[EMAIL PROTECTED]]
> > Sent: 25 April 2002 00:40
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Weird Windows SQL
> >
> >
> > Hi, I just installed MySQL on Windows XP.
> >
> > The winmysqladmin GUI only allows me to create databases that
> > start with "test". So, I can create a database called
> > "testmydata" but I cannot create a database named "mydata". This
> > is driving me nuts. Any ideas?
> >
> > Thanks,
> >
> > Mike
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Weird Windows SQL

2002-04-24 Thread Peter Lovatt

have you set up permissions for the user you are connecting as?
see  GRANT in the MySql manual. The test bit is a default setting for users
with no privileges (from my slightly rusty memory)

HTH

Peter

---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---

> -Original Message-
> From: Michael K. Dolan Jr. [mailto:[EMAIL PROTECTED]]
> Sent: 25 April 2002 00:40
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Weird Windows SQL
>
>
> Hi, I just installed MySQL on Windows XP.
>
> The winmysqladmin GUI only allows me to create databases that
> start with "test". So, I can create a database called
> "testmydata" but I cannot create a database named "mydata". This
> is driving me nuts. Any ideas?
>
> Thanks,
>
> Mike
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php