Guest Posted July 1, 2003 Posted July 1, 2003 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:
Jason Jacobs Posted July 1, 2003 Posted July 1, 2003 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
Guest Posted July 2, 2003 Posted July 2, 2003 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
Daemonj Posted July 2, 2003 Posted July 2, 2003 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
Guest Posted July 2, 2003 Posted July 2, 2003 BY install script do u mean the /catalog/install.php page? --------------------------- For the love god ..... i wil get through this in one piece!!
Daemonj Posted July 2, 2003 Posted July 2, 2003 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
Guest Posted July 2, 2003 Posted July 2, 2003 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
Guest Posted July 2, 2003 Posted July 2, 2003 het matt thanx i will try that... Sorry but i am new to all of this... HAve you ever used MySQLCC?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.