MySql Setup

Permalink
I am pretty new to this mysql thing..

Create a new MySQL database and a MySQL user account with the following privileges on that database: INSERT, SELECT, UPDATE, INDEX, DELETE, CREATE, DROP, ALTER

^
I have PhpMyAdmin on my server, with dreamhost.
I created mysql.domain.com
created a new database
monsterkrumain
user/pass

But I am unsure how I add those privileges to the database from my admin?

Can anyone help?

thank you

View Replies:
MysteriousCleon replied on at Permalink Reply
MysteriousCleon
In your cpanel where databases are, you have database users - click on your user and there are priviliges.
MHo replied on at Permalink Reply
Not sure if you have solved your problem, but Dreamhost has a one-click install that sets up the database for you. Very easy to use.
CygnetMidwest replied on at Permalink Reply
CygnetMidwest
Hi,

We have all our sites on Dreamhost. When you create a database with them, the admin user you create with database has all of those permissions. (the admin user is the user you created when you set-up the database in the panel).

Just enter the user credentials that you created in the panel in the C5 installer and you should be good to go.

Alternately, as @MHo says, Dreamhost has a one-click Concrete5 install that will setup the database for you.

Colin