Set up access to mysql database

[jondrew]

Hi I've nearly installed CMS ms on my clients server but I'm stuck at step 3. I get this error message:

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

In the instructions it says to do this:

Make sure you have created your database and granted full privileges to a user to use that database.

For MySQL, use the following:

Log in to mysql from a console and run the following commands:

  1. create database cms; (use whatever name you want here but make sure to remember it, you'll need to enter it on this page)
  2. grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass';


I don't know where to do this - i can log into my database through my hosting companies site - it goes to a admin page called starfield technologies inc. Where I can enter SQL queries etc.

When i try to enter number 2 'grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass';' I get this error: '#1142 - GRANT,REFERENCES command denied to user 'cms_u5er'@'68.178.254.44' for table 'cms_u5er' '

Please help I'm totally lost!

Thanks

Jon

[Dr.CSS]

When you made the DB did it ask for a user name and password or just make it then you have another page to add user with a password and set privileges?...

[jondrew]

Hi Mark,

Thanks for the answer I set up the databsse through my hosting companies website they asked me to enter username and password but not to set permissions?

I don't know how to access my SQl through a console? Do I need to do this?

[Dr.CSS]

Most of my host have had a Myphpadmin link of some sort, I've worked on some that didn't but the user they were asked to set up in the first run of the DB had full permissions so no need to go back and change anything...

[jondrew]

yep I've got a mysqladmim from the host's site. Anyone else help?

[Pierre M.]

Can you use MySqlAdmin with the provided database user/password ?
You provider should have given you 4 db parameters :
-db engine host (or IP)
-db name
-db user id
-db user password
Ask your host support about this.

Pierre M.