Ok- so I'm completely ignorant when it comes to MySQL. I'm hosting a site and she needs MySQL Access. I support that, but because I know nothing on it, I never bothered with it.

I use CPanel and know how to create the databases and add users... but how do they access their database? And usernames and passwords, i create those, but then they change to fortres_abc123 (myaccount_....) so would their user name be abc123 or fortres_abc123?

Another thing, she sent me this email-

Hey Jenn! *sorry to bother you* I was uploading a script that uses mySQL and it asked for a local host; I'm not sure what that is, do you know?

I'm just like.... eh?!

Anyway- if anybody could help it'd be greatly appreciated :)

Ok- so I'm completely ignorant when it comes to MySQL. I'm hosting a site and she needs MySQL Access. I support that, but because I know nothing on it, I never bothered with it.

I use CPanel and know how to create the databases and add users... but how do they access their database? And usernames and passwords, i create those, but then they change to fortres_abc123 (myaccount_....) so would their user name be abc123 or fortres_abc123?

Another thing, she sent me this email-



I'm just like.... eh?!

Anyway- if anybody could help it'd be greatly appreciated :)


it problalby jsut asks for a host, "localhost" will be fine then in 99.9999% of the cases.

As far as i know after you make a account in cpanel you also have to bind it to a database? i don't have a cpanel account anywere so i can't confirm this.

it problalby jsut asks for a host, "localhost" will be fine then in 99.9999% of the cases.

As far as i know after you make a account in cpanel you also have to bind it to a database? i don't have a cpanel account anywere so i can't confirm this.

And I have no idea what you just said.

this is what my mysql database looks like (completely empty):

http://www.four-nineteen.org/etc/mysql.jpg

below "Databases:"(in bold) you see:
user: <dropdown> db: <dropdown>

when you below add a user and a database you will see it appears in the dropdowns. now choose the user and the database and hit "add user to db". that will add the user youy just made to the database you just made

Whao nice what OS is that kinda looks link Mac but Its Not Maybe Vista?

Whao nice what OS is that kinda looks link Mac but Its Not Maybe Vista?

Haha, thanks. No, it's actually just a WindowBlinds skin I downloaded; ported from Mac though I think :)


below "Databases:"(in bold) you see:
user: <dropdown> db: <dropdown>

when you below add a user and a database you will see it appears in the dropdowns. now choose the user and the database and hit "add user to db". that will add the user youy just made to the database you just made

I'll have to give that a try and see what happens. Thanks :)

Ok I have that all set up.... now what? How is this person supposed to be able to access their SQL database?

host: localhost
username: the user you added
password: the password that you gave that user
database name: the name of the database you created.
(you have binded this user/pass to that database)

host: localhost
username: the user you added
password: the password that you gave that user
database name: the name of the database you created.
(you have binded this user/pass to that database)

Ok.. I'll pass the info along and hopefully it'll work.
Thanks! :)