Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

populating MySQL database


Guest

Recommended Posts

i am unable to populate my database. I run through the install page entering all info but it will not connect to my DB. i have tried to do it manually. I can create the DB but i am unable to do the second step. (i beleive that is when i try to populate my DB.) It might have to do with permission (create and drop) i have gave the files a chmod 777 (the two configure files)

 

Anybody help me? :roll:

Link to comment
Share on other sites

How are you setting up your database? Are you using a web interface such as phpMyAdmin, connecting to mysql through a command prompt and writing sql statements, or are you running a script from a unix command line that does the connecting for you?

 

Check your user table in mysql (connect to mysql, type "use mysql", then "select * from user") and make sure the user you're connected as has the ability to insert. Chances are if you have the ability to add and drop tables, you are allowed to insert rows.

 

Hope this helps a little.

 

-j

Link to comment
Share on other sites

HEy bud, i am using MysqlCC. I have created the data base and copied over the sample DB. but i am unbale to use the install.php method of installation

Link to comment
Share on other sites

You should not have copied anything - the install script does that.

 

All that you should have done is created a db and given a user all privileges on that db. You then enter the db name, user name, and password in the install script and all should be fine.

 

If you get a blank second page, then your user does not have lock privileges in which case you need to edit the oscommerce.sql file in the install folder to remove all of the lock and unlock statements.

 

That should do it for you.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

BY install script do u mean the /catalog/install.php page?

 

---------------------------

For the love god ..... i wil get through this in one piece!!

Link to comment
Share on other sites

How do i create a user for that DB?

I just answered that question in this thread. ;)

 

BY install script do u mean the /catalog/install.php page?

Actually, it is catalog/install/install.php but the answer is Yep. :)

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

How do i create a user for that DB?
If you are using a shared server, they may have already done it for you. In that case, your host would be the best one to ask that. Reading this should give you a better idea of how users work in MySQL. Especially this section.
BY install script do u mean the /catalog/install.php page?
Yes.

 

Good luck,

Matt

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...