I granted all privileges to [EMAIL PROTECTED], and everything worked well.
thanks a bunch, c. "Land, Christopher" wrote: > [EMAIL PROTECTED] -- perhaps? > > C:~ > > -----Original Message----- > From: Chris Huisman [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 10:51 AM > To: mysql > Subject: SQLState: 28000 > > Hello, > I am having a problem connecting to a mysql database. > My url string is as follows: > private static final String url = "jdbc:mysql://localhost:3306/test"; > > and I call the DriverManager with: > DriverManager.getConnection(url, userName, password); > > The output of this is: > ------SQLException------ > Error message: Invalid authorization specification: Access denied for > user: '[EMAIL PROTECTED]' (Using password: YES) > SQLState: 28000 > Vendor: 1045 > > I have done a: > GRANT ALL PRIVILEGES ON test.* TO chris@localhost IDENTIFIED BY > 'some_pass' > > I log into mysql with; > mysql -u chris -p > > where p is the same password as 'some_pass' > > any ideas??? > Thanks, > chris. > > --------------------------------------------------------------------- > 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