Re: Weird Windows SQL

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" <pjln1@sunmaia.net> To: "Michael K. Dolan Jr." <michaelkdolan@hotmail.com>; <php-db@lists.php.net> 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 > info@sunmaia.net > tel. 0121-242-1473 > ----------------------------------------------- > > > -----Original Message----- > > From: Michael K. Dolan Jr. [mailto:michaelkdolan@hotmail.com] > > Sent: 25 April 2002 00:40 > > To: php-db@lists.php.net > > 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 > >