MySQL connection error

Discussion in 'Databases' started by phayes, Nov 15, 2011.

  1. I am trying to get a MySQL database working with a web app.
    I have installed phpMyAdmin.
    I have created the database.
    I have added the user.

    When I try to connect (using MySQL connector 6.2.6, dll located in my bin dir), I get a privileges error.
    The privs error indicates the user does not have Select privs on the database.
    It is (so far as I can tell) the same user I log in to phpMyAdmin with (where I can indeed view tables and such).

    What boneheaded thing am I likely doing?

    Thanks in advance.

    Paul Hayes
     
  2. Note: One additional factoid.
    This is the message I am getting back:
    SELECT command denied to user 'myusername'@'209.169.26.31' for table 'bouldertestdata'

    where 'myusername' represents the username I use to log in to phpMyAdmin (and looks correct).
     

Share This Page