Setting up privileges in Godaddy
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?
There should be an option Privileges
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
CREATE TEMPORARY TABLES
If you dont have a user , click the Add a new User
choose the host,
create a password
I tend to ignore the Global privileges
then from the privileges page find the user and follow the steps above*
I am waiting for my database to be setup currently "Pending Setup"
Ill get back to you once I have had a play
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.
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.
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