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
BrettDashwood replied on at Permalink Reply 1 Attachment
BrettDashwood
This forum post often comes up when I search on MySQL setup privileges.

Even though (I beleive) it is a bit different to the Dreamhost environment, we use cPanel for our domain management and I just wanted to add a reply with details on the cPanel steps.

1. Scroll down to the databases section and click on "MySQL Databases"

2. Enter a database name in the Create a New Database section near the top of the screen. Part is pre-populated with the domain user name, so the resultant database name will then be in the format of {domain username}_{database name}, eg. if your domain username is "google" and the the new database name is "concrete", then the actual database name will be "google_concrete"

3. Scroll down to the MySQL Users section and enter a Username. Again, this is pre-populated with the first part of the name, so presuming the same domain as above, for example if your user name is admin, then the actual database username will be "google_admin".

4. You then Add User and you should then be presented with the Privileges. Here you select:
- ALTER
- CREATE
- DELETE
- DROP
- INDEX
- INSERT
- SELECT
- UPDATE
{see attached JPG for screen shot}

Then press 'Make Changes'

5. You then get a prompt message box (in green) stating that "You have successfully granted privileges on the database..."

6. Press 'Go Back' and job done!