Initial setup error: Insufficient privileges


#1

Hi, in step 3, Database Setup, I have an error message:

Please fix the following errors:

Insufficient privileges. Database user must have following privileges: CREATE
ALTER
SELECT
INSERT
UPDATE
DELETE
LOCK TABLES
DROP
CREATE TEMPORARY TABLES

You can add these privileges by using a tool such as phpMyAdmin or by executing the right SQL queries. If you don't know how to do these things, please ask your sysadmin to grant these privileges for you.

Is it possible for me to fix that from MYSQL or must it be change my the server hosting service?

Please advice


#2

It seems you may have your MYSQL user privileges incorrectly set-up.
http://dev.mysql.com/doc/administrator/en/mysql-administrator-user-administration.html

Did you set-up the user account? Did your hosting provider?

Are you using MYSQL CLI (command line interface), PHPMyAdmin, MYSQL Administrator,… there are all sorts of interfaces and flavours… http://www.veign.com/blog/2010/05/03/top-15-mysql-managers-and-tools/.