Mysql?

[pfeffer5308]

I am currently working on a project involving a picture album for my site and it asks for my SQL Host, Database name, username, password, and table prefix. Can you please tell me what these are?

 

Thanks in advance,

 

chris pfeffer

[LisaJill]

You need to create the database by going to cpanel and mysql databases.

 

The server will be localhost

The databasename will be cpanelname_dbname (whatever dbname you chose)

 

Then create a user, choose a name and password

 

The username will end up being cpanelname_username, and password will just be the password.

 

Then, you'll see two drop down boxes - one with dbnames and one with usernames. Choose the two newly created details and then click "Add User to Database"

 

Then you can fill in the settings and all should work. =)

[TCH-Rob]

Chris, this is database information. You will need to create a database in your cPanel. Open Manage Mysql Enter the name of the database in the Db field. Click on the Add Db button. Then enter the user's name in the UserName field and the user's password in the Password field. Click on the Add User button

Then choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list. Click on the Add User to Db button. The user now has permission to use that database and sample connection strings are shown in the MySQL window. "SQL Host" is localhost, "Database name" is cpanelname_dbname, "username" is cpanelname_username, "password" is the password you created. I am not sure the specific "table prefix" they are talking about.

[TCH-Rob]

Or I can let Lisa do all the answering for me.

[pfeffer5308]

you guys rock... thanks for the help!