On Fri, Feb 06, 2004 at 05:06:08PM -0600, Chuck Barnett wrote: > Hi, I am trying to create a script that automatically logs in to mysql and > chooses a db then runs a query. > > I can login fine when doing it this way: > > mysql -u user -p > > it then asks for a pass and it works. > > but if I try this: > mysql -u user -ppassword dbname > > I get an access error. > > any suggestions?
I'd guess the user doesn't have permissions for that dbname. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 145 days, processed 1,515,422,676 queries (120/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]