>I have installed a ILS.
Instrument landing system?
Installed MYSQL
Installed PHP on my XP PRO PC.
I want to test and develop a webshop local.
BUT...I got the PHP and ILS working.
The SQL im not sure about.
When I load the OSCommers webshop it lockes in step two (The SQL db
settings).
Now...Im not sure if I do it rigth OR what to fill into the shop info so pls
help me;
The info needed are;
Database Server`?
Assuming you installed MySQL and PHP on the same machine, the database
server is 'localhost'.
Username?
Password?
The default setup is 'root' with no password on a UNIX setup, not
sure what it would be on XP. Maybe root or Administrator. In any
case, you should create a separate MySQL account for OSCommerce
with its own username and password. Also, you should put a password
on the root or Administrator account.
Databasename`?
You need to create these yourself as part of setting things up. It
is possible that the request for the database name is asking for a
database for the OS Commerce setup routine to create for you.
Anything but 'test' and 'mysql' is OK. Or maybe it wants you to
create it first. If you are setting up multiple shops for multiple
customers, they likely each want their own database.
Pls help me fill in the rigth names etc.
I installed the SQL standard...So Im not even sure what the name of the DB
is ;-))
Can I test that in anyway???
One of the first things you need to test is whether the 'mysql'
command line client is working. Log in with host localhost, user
root or Administrator (whatever works), no password (unless you've
set one already, then use it). You might enter commands like:
C:\> mysql -h localhost -u root
mysql> grant all privileges on oscommerce.* to www@localhost identified by 'drowssap';
mysql> create database oscommerce;
mysql> quit
Now your username is www, password is drowssap, and database name is oscommerce.
The www user has privileges on the oscommerce database only.
Gordon L. Burditt