Database problems

[foryou]

I don't get why I am having issues, I hope I'm just c/p'ing something in wrong and its just a simple fix.

Database is set up on my hosting with a username to access it. All names below are pretend. :)

domain - www.smiley.com

Installed Database - smil_store
DB username - smil_jane

What would go in these spots:

Store Identifier (Table-Prefix)
Database Host
Database Username
Database Name

I currently have, but have tried several ways -

Store Identifier (Table-Prefix) = smil_
Database Host = smileys.com
Database Username = smil_jane
Database Name = store

Using the information above, what all do I put in. Im not sure if I should be putting in full information like "smil_store" or just "store"

I feel like it's an error in what I'm putting in, I appreciate any help. Thanks :)

[usernamenone]

When you set up your database you are asked for a name for the database then a password for that database. You may or may not have been asked for the user name if you were then you will need to use it, If you were not asked a user name you can assume it is the same as the database name.

Some hosts assign you a database name and user name for that database. I am guessing you chose yours.

define('DB_SERVER', 'localhost'); This is usually localhost but may not be depending on your host and how they have it configured. You should be able to find out in your control panel
define('DB_SERVER_USERNAME', 'xxxxxx'); This may be the same name as your database name if you did not get to pick a user name
define('DB_SERVER_PASSWORD', 'xxxxxx');
define('DB_DATABASE', 'xxxxxx');

If you have intered all info correctly and still can not connect to the database you host may have database problems...... Happened to me more than once.

You do not put in a store identifier unless you added a prefix to your database and if you did not then leave it blank.

I don't get why I am having issues, I hope I'm just c/p'ing something in wrong and its just a simple fix.

Database is set up on my hosting with a username to access it. All names below are pretend. :)

domain - www.smiley.com

Installed Database - smil_store
DB username - smil_jane

What would go in these spots:

Store Identifier (Table-Prefix)
Database Host
Database Username
Database Name

I currently have, but have tried several ways -

Store Identifier (Table-Prefix) = smil_
Database Host = smileys.com
Database Username = smil_jane
Database Name = store

Using the information above, what all do I put in. Im not sure if I should be putting in full information like "smil_store" or just "store"

I feel like it's an error in what I'm putting in, I appreciate any help. Thanks :)

[A-1 Electronics]

I have a ? concerning this issue also. I did not insert a db prefix when I installed. I should have. Where do I go to edit this? Do I need to do a db update through the zc_install and give it a name there?

[A-1 Electronics]

I have a ? concerning this issue also. I did not insert a db prefix when I installed. I should have. Where do I go to edit this? Do I need to do a db update through the zc_install and give it a name there?

Got it figured out.