Setting up privileges in Godaddy

Permalink
Hello,

Does anyone know how to set the "INSERT, SELECT, UPDATE, INDEX, DELETE, CREATE, DROP, ALTER" privileges that Concrete5 requires once you've created a new MySQL database in Godaddy?

I'm not a developer so my understanding of php/MySQL is limited. I've tried searching all over phpMyAdmin and couldn't find any area to check and uncheck the privileges. I'm assuming that I'll have to type in code somewhere.

I've been going in circles with this issue. Can anyone please help me?
View Replies:
TheRealSean replied on at Permalink Reply
TheRealSean
In Phpmyadmin from the home page,

There should be an option Privileges

url phpmyadmin.mydomain.com/server_privileges.php
If you dont see this its possible you do not have the privileges to create users?

Some servers do not allow users to create or alter user privileges. If that is the case you would need to get in contact with them, to look at getting access.

If you do you should come to a User overview page,

with an alphabet,

*If you have a user
Select the letter with which your username starts

In the available users, click the edit privileges on the right of the table.

This will take you to the users privileges page, you can either set users for global access (most of the time you wont want to do this)

Below the global Privileges there should be a Database-specific privileges window,

select the database from there. Once there you can choose the privileges
Data
SELECT
INSERT
UPDATE
DELETE
Structure
CREATE
ALTER
INDEX
DROP
CREATE TEMPORARY TABLES
CREATE VIEW
SHOW VIEW
CREATE ROUTINE
ALTER ROUTINE
EXECUTE
Administration
GRANT
LOCK TABLES
REFERENCES

If you dont have a user , click the Add a new User


Create username,
choose the host,
create a password

I tend to ignore the Global privileges

click ok
then from the privileges page find the user and follow the steps above*
TheRealSean replied on at Permalink Reply
TheRealSean
Scrap that, I missed the Go-Daddy part,

I am waiting for my database to be setup currently "Pending Setup"

Ill get back to you once I have had a play
Carine replied on at Permalink Reply
Thank you so much for all this seanom! I had spoken to a GoDaddy rep not too long ago and they said that you need a dedicated server to be able to have multiple databases.

Rather than wasting more time with GoDaddy, we ended up switching to BlueHost.

Let me know what ends up happening with the currently "pending setup" database. I'm curious to find out.

Thanks again!
pvernaglia replied on at Permalink Reply
You shouldn't have to do anything to the database. unless something has screwed up.

Copy the C5 files to a directory on Godaddy
Set permissions on the files/ directories that need to be changed. Put a copy of php5.ini in the same directory as your concrete5 installation, add the line
cgi.fix_pathinfo = 1 to it.

Once godaddy has the database set up,( that can take a couple hours), Point your browser at the directory with C5, run the installation, and it's done.

You need a paid account on Godaddy, it won't work on the free hosting accounts.
TheRealSean replied on at Permalink Reply
TheRealSean
Yes just found the same thing, as my hosted godaddy is the free version,

Hopefully Carine, now you have another hosting provider they can give you a better solution.

We are uk based and use UkFast for our hosting