Re: Help With Myqsl/jdbc/RedHat

[Mark Matthews]

Frank LaLone wrote:

Actually, I did see the Read Me file that came with the driver.  I spent so
much time on this myself, I wanted to start fresh on here. :)

I am still unable to get mysql to connect to the jdbc driver.  Here is the
latest what I did and the resulting errors that came up:

#######################################################################

GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password';


SQLException: Invalid authorization specification: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)
SQLState: 28000
VendorError: 1045

Did you 'flush privileges;' afterwards? Also, you might consider trying only one database, and surrounding your username and host by single quotes, like:

'GRANT ALL PRIVILEGES ON dbname.* to 'user1'@'127.0.0.1' IDENTIFIED BY 'password'


[snip]

##############################################

I must point out, mysql will connect using these parameters from the command
line.

Because it is not using a TCP/IP socket, MySQL will connect in this case, as the grants work differently if you're connecting via a Unix domain socket.

Have you worked through the troubleshooting section at:

http://www.mysql.com/doc/en/Access_denied.html

Also, what does your URL look like? Maybe you're not specifying it correctly.

-Mark
--
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com


---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php