[Solved] Cannot connect to database - Unable to grant all privileges

[Msbiz]

Hi,

I am trying to install Version: 1.9.1, but I am having a problem when it comes to connecting to the database.
Just realised that my hosting provider will not allow me to 'grant all privileges' on the database. The only permissions I can use are:
# ALTER

# CREATE

# DELETE

# DROP

# INDEX

# INSERT

# SELECT

# UPDATE

# CREATE VIEW

# SHOW VIEW

# CREATE ROUTINE

# ALTER ROUTINE

# EXECUTE

# LOCK TABLES

Is this sufficient to be able to install CMS version 1.9.1? If so, how do I do it?
If not, what is the alternative other than changing hosting?

Thanks a lot in advance.

Liz.

[Wishbone]

What's your exact error message? If it's "cannot connect to the database", it probably has nothing to do with permissions.

[Msbiz]

Hi,

Thanks for the reply.

The message is:

Could not connect to the database. Verify that username and password are correct, and that the user has access to the given database

I have used the username and password that I was given when I made the database. I left database host as localhost and left the database port blank.

Liz

[Wishbone]

I always screw up the database name... The default is "cms" which I confuse with the table prefix.. Did you get the database name correct? and is localhost correct for the host?

[Msbiz]

Yes, you're right it was the hostname that was wrong. The database is run from a different server or something.

Fixed the problem and finally installed it. And here I was all night looking up MySQL permissions

Thanks for your help.