lhn Posted February 20, 2003 Posted February 20, 2003 Hello everyone, I just joined yesterday. I'm new to website design, hosting and ecommerce. I have some really basic starter questions that I hope someone can help me. I'm working on an ecommerce website for my business and I'm trying to install oscommerce program on the site. I'm being asked for 'database server', 'username', 'password' and 'Database'. Could someone show me how to set them up? Thanks. Linh Quote
KevinW Posted February 20, 2003 Posted February 20, 2003 First, welcome to TCH! Second, perhaps you could start by identify which software it is that you are trying to use? Is it ine that comes with cPanel, or some other product? -kw Quote
lhn Posted February 21, 2003 Author Posted February 21, 2003 Thanks kw, I'm trying to install a program from www.oscommerce.com, it's basically an ecommerce website you can download and use it as a template to design an ecommerce store. -linh Quote
lhn Posted February 21, 2003 Author Posted February 21, 2003 I tried to create a username, password and database in cpanel under Manage Mysql and this is what I get. 'Connection Strings Perl $dbh = DBI->connect("DBI:mysql:asiapdp_:localhost","asiapdp_linh",""); PHP $dbh=mysql_connect ("localhost", "asiapdp_linh", "") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("asiapdp_");' what is all this mean? -Linh Quote
Lianna Posted February 21, 2003 Posted February 21, 2003 Teehee. That means that you created a database! Tah-da! Oh, you mean what does all that jibberish translate to? Well, if you were actually writing the code to connect to the database, then that's the stuff you would need to include in your code. Chances are that oscommerce is going to create the code for you by asking some specific questions during its setup. Like: Host Server Name? localhost DB Name? asiapdp_linh It may even ask you if the tables in the database will be prefixed? Yes and that prefix will be linh_ There are two different codes given to you. One is for use with Perl and the other with PHP scripts. Hope that helps. Lianna Quote
lhn Posted February 21, 2003 Author Posted February 21, 2003 thanks, that helps a little. I'm still missing something. Here is what I entered in the blank and it still said access denied for user... Database Server: Locolhost The database server can be in the form of a hostname, such as db1.myserver.com, or as an IP address, such as 192.168.0.1. Username: asiapdp_linh The username is used to connect to the database server. An example username is mysql_10. Note: If the catalog is to be imported (selected above), the account used to connect to the database server needs to have Create and Drop permissions. Password: "password for username in database" The password is used together with the username, which forms the database user account. Database: Localhost The database used to hold the catalog data. An example database name is catalog. -Linh Quote
lhn Posted February 21, 2003 Author Posted February 21, 2003 finally got it to work. Thanks everyone.... -Linh Quote
Lianna Posted February 21, 2003 Posted February 21, 2003 *YAY* When you get a few extra minutes and if you feel like sharing, could you post here the information that is requested from oscommerce and the 'right' answers? I'm sure that you won't be the last to ask of oscommerce. Your proven install could be very helpful to someone else, too. Thanks. Lianna Quote
lhn Posted February 28, 2003 Author Posted February 28, 2003 Ok, here is what I did... Database Server: localhost The database server can be in the form of a hostname, such as db1.myserver.com, or as an IP address, such as 192.168.0.1. Username: asiapdp_linh The username is used to connect to the database server. An example username is mysql_10. Note: If the catalog is to be imported (selected above), the account used to connect to the database server needs to have Create and Drop permissions. Password: "password for username in database" The password is used together with the username, which forms the database user account. Database: asiapdp_ The database used to hold the catalog data. An example database name is catalog. -Linh Quote
Lianna Posted February 28, 2003 Posted February 28, 2003 Thank you. I'm sure this will be of value to someone else! Lianna Quote
Guest Guest Posted February 28, 2003 Posted February 28, 2003 No problem at all.... I do have one other question for you Lianna. Is there something that I have to enable in "Cpanel" so that my site display properly? example. when I type www.mydormain.com all I see is my folders. How can I get it to display www.mydormain.com/catalog/default.php? I have tried different methods but nothing have work so far. Thanks again. -Linh Quote
Lianna Posted February 28, 2003 Posted February 28, 2003 create an index.htm and place in the public_html folder. Code that page to redirect the visitors to your /catalog/default.php? page. The public_html directory is the first stop for a visitor of your domain, so if you want me to type: http://youdomain.com and end up at http://youdomain.com/catalog/default.php? then you must redirect me. index.htm or index.php will do it. Lianna Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.