MYSQL entries - a little help please
Permalink
Hello, I've just installing Concrete on my server, and after an issue getting the php5.ini file to work I went ahead and started to do the mysql database and entries, and then ran into an issue. I'm new to mysql.
So far my MYSQL database looks like the following, but I have no idea about what the type or other information should be. Any some either tell me what I need to put in the remaining fields, or better yet show me via a screenie.
Sorry if this is all newbie, but then again, that's what I am.
Thanks
Furyan
So far my MYSQL database looks like the following, but I have no idea about what the type or other information should be. Any some either tell me what I need to put in the remaining fields, or better yet show me via a screenie.
Sorry if this is all newbie, but then again, that's what I am.
Thanks
Furyan
I'm following a concrete5 beginners guide pdf I found.
I'm trying to install a test run on my godaddy hosted account, hoping to be able to set up subdomains off the main site for staff etc (a problem I will have to address later)
In the Beginner Guide is gives steps on how to install it and says I need to:
Did I find something old?
I'm trying to install a test run on my godaddy hosted account, hoping to be able to set up subdomains off the main site for staff etc (a problem I will have to address later)
In the Beginner Guide is gives steps on how to install it and says I need to:
Did I find something old?
Alright, no, you're on the right track. Just a word of caution - from what I've seen in discussions here, Godaddy seems to be a problematic host for concrete5 in terms of performance.
Does your phpMyAdmin home screen (= when you click on the small house icon in the left sidebar) look like my screenshot? If so, you can create your concrete5 database by just entering the name, e.g. "c5test" in the form field that I highlighted in the screenshot and clicking on the "Create" button.
That's all you need to do with the database.
Now, for the user, you have to check the second screenshot. Do you have that tab "Privileges"? If not, you cannot create new users, instead you should use your MySQL admin user account when concrete5 asks for database access information during its installation.
Does your phpMyAdmin home screen (= when you click on the small house icon in the left sidebar) look like my screenshot? If so, you can create your concrete5 database by just entering the name, e.g. "c5test" in the form field that I highlighted in the screenshot and clicking on the "Create" button.
That's all you need to do with the database.
Now, for the user, you have to check the second screenshot. Do you have that tab "Privileges"? If not, you cannot create new users, instead you should use your MySQL admin user account when concrete5 asks for database access information during its installation.
No, my screen looks different from yours.
In Godaddy's MYSQL database section I have to create the database, which I did (a new one for this topic) and it looks like this (refer to image)
I'm probably doing something wrong somewhere along the lines >_<
In Godaddy's MYSQL database section I have to create the database, which I did (a new one for this topic) and it looks like this (refer to image)
I'm probably doing something wrong somewhere along the lines >_<
Ok, then what I called "c5test" in my previous post is your "test50555" database. No need to do more here, you have the required MySQL database for c5.
Since you don't have the possibility to create a new MySQL user, you probably have to use the account that you use for logging into phpMyAdmin also for giving concrete5 database access. So, you probably just skip this part from your tutorial (can you post a link to it, please?).
Have you already uploaded the contents of your concrete5.4.1.1.zip to your server? Then you could check the install page under http://yoursite.com/concrete5/ , see if the pre-install checks go well and depending on the result enter your database info and go ahead and install. If it doesn't work, please post back here. :-)
Cheers!
Since you don't have the possibility to create a new MySQL user, you probably have to use the account that you use for logging into phpMyAdmin also for giving concrete5 database access. So, you probably just skip this part from your tutorial (can you post a link to it, please?).
Have you already uploaded the contents of your concrete5.4.1.1.zip to your server? Then you could check the install page under http://yoursite.com/concrete5/ , see if the pre-install checks go well and depending on the result enter your database info and go ahead and install. If it doesn't work, please post back here. :-)
Cheers!
Ok, so with this database will it manage one C5 driven site/subdomain site or does it manage many?
As far as I know and understand it, you would need one database for each c5 site, but do not quote me on that. How many databases does your hosting plan allow for?
However, it's possible to do a multi-site installation, but from what I've understood from forum threads, it's not quite trivial. Here's something for a start: https://www.concrete5.org/community/forums/chat/mobile-and-multi-sit...
P.S. There's an addon in the marketplace which would probably do what you want:http://www.concrete5.org/marketplace/addons/domain_mapper/... (but it costs money)
However, it's possible to do a multi-site installation, but from what I've understood from forum threads, it's not quite trivial. Here's something for a start: https://www.concrete5.org/community/forums/chat/mobile-and-multi-sit...
P.S. There's an addon in the marketplace which would probably do what you want:http://www.concrete5.org/marketplace/addons/domain_mapper/... (but it costs money)
P.S. It looks like you're creating a *table* which isn't at all needed for the install, instead you have to create a MySQL user with certain rights (INSERT, DELETE, UPDATE etc.)
Are you on Windows? Is your server your desktop computer or some webhost?
Cheers,
stromberg