Database will not accept connection

[archprime]

Hi - sorry, I did not receive notification of the previous reply to this issue, and that thread was closed - however, issue is not resolved:

I set up a database and user in Cpanel, but my PhPGedView website script reports that the database is refusing connection even though I am using using the correct credentials as shown in your knowledgebase article on databases.

I get error
SQLSTATE[42000] [1044] Access denied for user 'archprim_king'@'boru.x10hosting.com' to database 'archprim_Kingfamily'

What might be going wrong?

I note that in its documentation, PHP Gedview expects all MySQL databases to include "PDO drivers" - is this the case with databases hosted by you?

I tried using "localhost" as server host, and I created the database through wizard

 

[descalzo]

Try dropping the user and then re-creating it with same password. Then add back onto database, making sure to enable all permissions.

And make sure the host is set to 'localhost'

 

[archprime]

Try dropping the user and then re-creating it with same password. Then add back onto database, making sure to enable all permissions.

And make sure the host is set to 'localhost'

Hi - thanks - I tried, but it made no difference - though I cannot see anywhere to enable permissions?

 

[descalzo]

When you add a db user to a database, a screen comes up where you check off (or just use 'All' ) the permissions you want. The 'default' is no permissions.

 

[archprime]

Thanks - that is what I was not doing! Working now!

 

[Zubair]

Problem Solved

***Thread Closed***