godaddy hosting

i see this has been talked about, apologies in advance still not getting it. am setting up a test modx site on godaddy, found the thread about needing your database details handy when you get to installing modx. tis my first time at something like this so pls be kind...

database name [ok, i know this one, or do i think what goes in here is for db login name?]
table prefix [do i leave this as ’modx_’ ?]
collation [am not gonna touch this one]

database host [this is where i’m putting in ’p41mysqletcetc.secureserver.net’]
db login name: [same as db name above?]
db password: [no worries with this]

am getting ’Connection to host: failed!’ no matter what permutation of this info i try...
help?

The name of the database may not be the same as your username for logging in to the database. Usually the database name is some permutation of your domain name and your login name; mine for one host was sottwe_sottwe, since I always go by sottwell, and my domain is of course sottwell.com, but they only used the first six letters.

Collation is not a big deal, are you using utf-8 or one of the iso-8859 character sets? Once you can get a connection, you’ll be able to select from a list of what’s available for your database; the list varies depending on the configuration of MySQL. Collation itself has to do with how things are sorted; in some languages A may not be the first letter of its alphabet, and in others the same letter can be in a different location in a sorted list depending on the region. Alphabets like Hebrew, even in utf-8, can be complicated by the fact that there are no vowels, but vowels can be indicated by dots and various other little markings, or not. This can complicate sorting, and using the correct collation type is important. In English, it doesn’t really matter.

The prefix can be anything you want; it will be prepended to all of the MySQL tables, so if you have only the one database and want to run the SMF forums as well, you can have modx_users and smf_users; both users tables, but no confusion because of the prefix.

thank you so much for your email, today is my first day of hitting a forum and i’m stunned at how helpful people are...
do you think then to find the name of my database that’s something i need to ask godaddy for?
relating to ’are you using utf-8 or one of the iso-8859’... i had to google that to try to understand the question... and... i don’t know... [i can design static websites only for cms ones i’ve had the good fortune of a programmer who makes them ’work’, am trying to learn to do it myself hence what i’m sure is my remarkable ignorance].
i think i’ll ask godaddy for the database name as i’m not seeing any more details other than the ones i mentioned below. would that sound like a plan?

Yes, they should be able to help you with which is what

yr a gem, thank you again for sharing your time and help, really appreciate it. big teethy smile back atcha.

so... i’ve had no joy, as yet, getting modx working on my godaddy server. would anyone [sottwell, are you there? ] be willing to take a look at my screen grabs of what i’m putting in the fields and the screen of my database set up? i emailed godaddy and they said to put in kathleenread as my db name. have tried unsuccessfully... i have no doubt it’s me missing something super simple. might be able to provide you with a chuckle at my naivite...

go ahead... if I’m not around, somebody will be.

From what you’ve said, it should look like the attached screenshot...

thank so much again, think you folks are far away[?] otherwise i’d buy you a beer for your time. more than 1 beer i think! yep, my login screen looks like that. i think it must be the ’database login name’ that i’m messing up then. i’m trying everything i can think of. both my database name and user name for that account are kathleenread, so have tried that again. then tried my godaddy login number. i think maybe time for me to hit godaddy again... lordy knows what questions i’ll have when i actually really get into using this if i can’t even set up my db properly!! if you think of anything i might be missing, pls sing out, i’ll check back in the interim while i wait to hear from godaddy. thanks

i’ve been trying [unsuccessfully] since my last post to get modx working on my godaddy hosting. have reuploaded the files in case i messed that up... created a new database in case i messed that up... reentered passwords for my database in case i messed that up... and still having no joy...
i’ve emailed godaddy and they replied: ’We will need to know the permissions that the database requires in order to determine why you are unable to connect to the database. As this is not our product, we are not aware of the permission requirements.’
does anybody know what they would need information-wise in response to that? susan ottwell and bob ray, you were both kind enough to help me in the past with starting to get this sorted out, if you or any other nice folk would be inclined, i’d be very grateful if you would have a stickybeak around my files [am happy to email to email my ftp details, could give you my email address so yours wouldnt have to be shown to everyone] and see if i’m missing something? because i am stumped. again, am sure it’s me, no doubt at all that i’m missing something, just not sure what...

All MODx needs is the basics: server, database name, username, password. It uses standard PHP mysql functions for connecting and selecting a database.