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