----- Original Message ----- From: "sreedhar" <[EMAIL PROTECTED]> To: "Ryan Booker" <[EMAIL PROTECTED]> Sent: Friday, November 02, 2001 12:24 PM Subject: Re: Can't connect to new databases
> hi ryan, > > check the privileges you had given to the users, test and mysql databases > are default databases which can access by any user. > > if you want to connect as local user you can give grant command as > > GRANT ALL PRIVILEGES ON *.* / (databases) TO sreedhar@localhost IDENTIFIED > BY 'some_pass'; > > if you want to connect as remote user you can give grant command as > > GRANT ALL PRIVILEGES ON *.* / (databases) TO sreedhar@"%" IDENTIFIED BY > 'some_pass'; > > "%" means you can connect from any host or simply you can give single host. > > This will make you connect any database by specified user. > > Go through MySQL Documentation > > 4.3.4 Setting up the intial MySQL Privileges. > > hope this will help you. > > regards, > sreedhar > > > > > ----- Original Message ----- > From: "Ryan Booker" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, November 01, 2001 5:51 AM > Subject: Can't connect to new databases > > > > I have recently installed mySQL 3.23.43. I will be using it to run a > > website (php/mysql). Using my php scripts I can connect to the server and > > the default test database and select information from the table I created > in > > the test database. However, if I create a new database, not matter what > > it's called, I can not connect to it from the php. I can however connect > to > > it directly in mysql and perform any actions on it (eg create tables, > insert > > rows, select data). > > > > Any help would be greatly appreciated. > > > > Thanks in advance, > > Ryan > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php