I got this working on my local workstation. Now I am trying to set it up from my webhost site. Arrgggh!

I login to my Cpanel for the account. I get an option there for MySQL and PHPAdmin. I went to the MySQL part and created a database. I named it bookmarks and it created the thing as consult_bookmarks where consult is my account login name for cpanel.

So then I have tried to set up a number of users so I can work with it. I put in a name and it pre_pends "consult_" to the name. So I now have:
consult_bmuserlo <was supposed to be 'bmuser'@'localhost'
consult_consult <was supposed to be just consult
consult_root <was supposed to be just root
consult_test <was supposed to be just test

I then set up these users with all rights.

I then opened PHPAdmin version 2.8.02
It shows I am connected as consult@localhost

So from there I tried to execute a grant usage command and got an access denied command.

SQL query:

GRANT USAGE ON bookmarks. * TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';

MySQL said: Documentation
#1044 - Access denied for user 'consult'@'localhost' to database 'bookmarks'

And the php connection stuff I had working locally errors out similarly when I try to hook to the database.

Can anyone point me towards what I am doing wrong?

Thanks

    did you already add those users to the database, meaning the users you set up have permissions to access the database?

    conjurer wrote:

    I got this working on my local workstation. Now I am trying to set it up from my webhost site. Arrgggh!

    I login to my Cpanel for the account. I get an option there for MySQL and PHPAdmin. I went to the MySQL part and created a database. I named it bookmarks and it created the thing as consult_bookmarks where consult is my account login name for cpanel.

    So then I have tried to set up a number of users so I can work with it. I put in a name and it pre_pends "consult_" to the name. So I now have:
    consult_bmuserlo <was supposed to be 'bmuser'@'localhost'
    consult_consult <was supposed to be just consult
    consult_root <was supposed to be just root
    consult_test <was supposed to be just test

    I then set up these users with all rights.

    I then opened PHPAdmin version 2.8.02
    It shows I am connected as consult@localhost

    So from there I tried to execute a grant usage command and got an access denied command.

    SQL query:

    GRANT USAGE ON bookmarks. * TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';

    MySQL said: Documentation
    #1044 - Access denied for user 'consult'@'localhost' to database 'bookmarks'

    And the php connection stuff I had working locally errors out similarly when I try to hook to the database.

    Can anyone point me towards what I am doing wrong?

    Thanks

      Write a Reply...