Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    13

    Unanswered: jdbc syntax problem

    When logging into mysql, I can do a:
    ./mysql -u mysql -p

    ... then when it prompts me for a password, I just hit enter and it logs me in without a problem.
    I can then do a:
    use test;

    ... and I'm in the test database.


    I can also do a:
    ./mysql -u mysql

    ... and it logs me in fine.
    I can then do a:
    use test;

    ... and I'm in the test database.


    In thew up a page on my server, and I'm connecting like this:
    jdbc:mysql://xxx.xxx.x.xxx/test?user=mysql

    ... but it gives me this error:
    Invalid authorization specification, message from
    server: "Access denied for user: 'mysql@xxx.xxx.x.xxx' (Using password:
    NO)"


    Question is, why won't it let me in ?

  2. #2
    Join Date
    Oct 2003
    Posts
    13

    Exclamation ps

    when i say i'm "loggin in", this is straight from the command line.

  3. #3
    Join Date
    Oct 2003
    Posts
    13
    any insight on this database masters ?
    using the mysql driver, is the password required ?

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Perhaps you try to connect from an other computer so it does't work cause MySql identify user by their login and their host name.
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  5. #5
    Join Date
    Oct 2003
    Posts
    13

    solved

    omiossec, you are good
    i didn't have the specific user set to be accepted to the correct domain.
    i had to do an update to have the user to have permissions from any domain... ie:
    grant all prvilidges... etc 'user'@'%'...etc

    many thanks !!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •