CMS Made Simple Forums

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.

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

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

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?

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.