MySQL Permissions

[Christine]

Hi all,

I created a database and added a user with 'all' permissions to it via cPanel, but vB is not accepting that user/pass in config.php.

vB will accept the main account login, but for security reasons, I don't want to put the domain's login/pass in the config file -- I want that to be the login/pass for the database user account.

What am I missing here?

Thanks!

[Steve Machol]

You need to make sure that db user is assigned to that database.

[Christine]

It is. :)

I am getting this error: Link-ID == false, connect failed
mysql error:

mysql error number: 0It goes like this in a 10 minute span:

1. Upload config.php with the domain's login and pass -- works fine
2. Upload config.php with MySQL user login and pass -- error
3. Reload config.php from #1 -- works fine
4. Retry config.php from #2 -- error

I have about 12 various databases (2 vB ones) and have never had a problem connecting with the user I have assigned to each of them.

/me confused

[Steve Machol]

If you are sure you have the correct db info in config.php, then this is a server issue. For some reason it's not accepting MySQL connections. You need to contact your host about this.

[Christine]

Thats the thing -- the vB configs are accepting it, but only with the default login information. If I try to use the user assigned to it, I get the error.

[Steve Machol]

Sorry I didn't understand this. Can you please clarify?

[Christine]

Bless your heart, Steve -- you are so patient! :)

I am not having any trouble connecting to the database as long as I use the main account login and password.

I attached a screenshot from my test environment cPanel, database name is XXXXX_test. The user that is attached with all privs is floridac_u1. It is the floridac_u1 account (username and pass) that vB is not allowing me to connect with.

BUT, if I change config.php back to the main domain login (the login with rights to create users like floridac_u1), it connects like a champ.

For security reasons, I really need for the config.php to use the username/pass that I have assigned to the database and not the main login information.

Does this make sense?

[Steve Machol]

You need to add the floridac_u1 user to this vB database.

[Christine]

I am not following you? That is the vB RC3 database that the user is attached to.

Is there a step I am missing?

:confused:

[Steve Machol]

I don't know how else to say it. You need to add the floridac_u1 user to this vB database. You can do this from withing the page where your screenshot came from.

[Christine]

I only have one database on that domain -- it is my RC3 test database (the one in the screen shot). The only user I have added to MySQL is the user attached to the database.

I have done this oddles of times before on other accounts without problem, so I do understand -- I just don't know why this one isn't working.

Thanks for your help (and patience!) I think I may just blow it all away and create a new database/user and restore again. :(

[Steve Machol]

What is the latest error you are getting?

[Christine]

It was the same as before.

I blew it all away and set it up again from scratch and all is working fine now.

No clue as to what was happening, but at least it is working!!

Thanks for your help.

:)