Oscommerce installation/phpmyadmin

[tailormadepc]

Hi,

I'm trying to follow the OSCdox Guide on how to install OSCommerce however am a little confused with..

Using phpMyAdmin or other tool, create your database and user, and assign that user to the database. Make note of the name of the database, login and password for this database, you will need this later.

Could someone please explain how exactly I should go about doing this, i've got phpmyadmin installed however i'm a PHP/phpmyadmin newbie and have no previous experience with mysql/databases.

Thank you in advance for any help.

Kind Regards.

[jpf]

Load phpMyAdmin in your browser and just below "Create new database" should be a TEXT box and a CREATE button - if it said "No Privileges" then you can't....Ask your host to provide/create one for you.

To assign a user (provided that your able to create above database...) On the main screen - Click on "Privileges" then

a)edit an existing user
b)Click "Add a new User"

Then fill in :
User name: Your OSC database user name you want
Host: Local (from drop down box - or enter 'localhost' as "Use text Feild")
Password: Your OSC database password you want
Re-type: Your OSC database password you want

Check all the following Global privileges:
SELECT CREATE
INSERT ALTER
UPDATE INDEX
DELETE DROP
FILE

(no ADMIN needed for this account)

All "Resource limits" should be 0 (unlimited)

Click on "GO" when done.

[tailormadepc]

Originally Posted by jpf

Load phpMyAdmin in your browser and just below "Create new database" should be a TEXT box and a CREATE button - if it said "No Privileges" then you can't....Ask your host to provide/create one for you.

To assign a user (provided that your able to create above database...) On the main screen - Click on "Privileges" then

a)edit an existing user
b)Click "Add a new User"

Then fill in :
User name: Your OSC database user name you want
Host: Local (from drop down box - or enter 'localhost' as "Use text Feild")
Password: Your OSC database password you want
Re-type: Your OSC database password you want

Check all the following Global privileges:
SELECT CREATE
INSERT ALTER
UPDATE INDEX
DELETE DROP
FILE

(no ADMIN needed for this account)

All "Resource limits" should be 0 (unlimited)

Click on "GO" when done.

Hi,

Thank you for your advice, much appreciated.

Any idea's how I can get oscommerce installed locally initially so that I can get used to how it works locally before FTP'ing to a web-host. Have to admit that i'm finding all of this quite confusing. I've managed to get PHP, mySQL, phpmyadmin installed along with the xiwin32 server (as opposed to Apache).

Could someone please advise how I can go about setting up oscommerce locally to run using xiwin32?.

Thank you,
Kind Regards.

[borrrden]

Ok I have a HUGE problem.....I accidentally deleted the root privileges on phpmyadmin, I am the server but I have no privileges to do anything (create...select...etc). Is there some way to reset this? I tried looking for the answer on the web but they all say to log in and do it, I can't log in from the mysql> command prompt because it automatically goes to localhost.....where I have no privileges.....help

I'm running fedora core 2, with current versions of php apache and mysql