elipsett
|
| Posted: 01/11/2003, 7:00 AM |
|
I've been writing HTML pages for years, FileMaker databases for years, and Visual Basic for over a decade. I understand how PHP works, no problems.
But after installing MyODBC, PHPTriad and CodeCharge, I cannot get CodeCharge to function normally. The problem is clearly getting my system to find the MySQL DB. I've been through all the documentation I can find, here and elsewhere, and cannot solve the problem. PHP is working, MySQL-NT is working, Apache is working.
Is there anywhere on the web that describes this process? Or is there anyone that has a clear, specific procedure for installing this stuff to Win2k?
Thanks.
Edward Lipsett
Fukuoka, Japan
elipsett@intercomltd.com
|
|
|
 |
RonB
|
| Posted: 01/11/2003, 11:47 AM |
|
in the bin directory under mysql there's a program called winadmin use it to set your initial account login and password for root. Now download phpmyadmin from http://www.phpwizard.net/projects/phpMyAdmin/
unzip into your htdocs directory under apache and edit the config.inc.php file. It is pretty much selfexplanatory.
Now you are able to connect to mysql using phpmyadmin and you can go about setting new users and there DB rights in a nice gui enviroment. once you've done that you go to your odbc manager and add a system source with myodbc wich you will use in the design stage within CCS. The server side mysql connection is handled by php so there's not much to configure there. That should be all. I had it working (php, mysql, apache) in ten minutes.
Ron
|
|
|
|
elipsett
|
| Posted: 01/11/2003, 6:06 PM |
|
Thanks, Rob.
OK, instead of a program called "winadmin" there was one called "WinMySQLAdmin" in the same place, which I had already installed and set up. The user and password are both set to "me" to make it easy to remember.
I downloaded the latest version of phpMyAdmin and installed it into the right place. I checked the config.inc.php file and didn't see anything that I needed to change right now, I think... there are a lot of places where I don't have the faintest idea if I need to do something or not, like:
==
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)
==
(I'll try it both ways to see what happens, but there's no particular information in the documentation...)
The next step seems to be "Now you are able to connect to mysql using phpmyadmin." How do you do this? Again, I am unable to find any info in the documentation...
Thanks.
|
|
|
|
elipsett
|
| Posted: 01/11/2003, 6:44 PM |
|
OK, I finally got a menu at:
http://localhost/phpmyadmin/
Strange that it doesn't tell you anywhere that this is where to find it...
Now I get to play around... thanks!
Edward Lipsett
|
|
|
|
elipsett
|
| Posted: 01/11/2003, 11:45 PM |
|
OK, after considerable fiddling, I have discovered how to activate one of your sample databases in PHPMyAdmin. I can now generate and view your samples, like Bookstore, on my machine.
To design a MySQL database, I gather that I have to actually design it in PHPMyAdmin, and then I can use (and input) the data using CodeCharge and the generated pages. In other words, CodeCharge itself cannot create a DB, or add tables or fields, correct?
Eventually I will need to upload a completed setup to my web host, however. This is Pair.com, using FreeBSD/PHP/MySQL. Pair.com documentation seems to imply that THEY create the MySQL DB, and you have to design and populate it online. Do you know? (I have asked for clarification). In that case, it sounds like the MySQL DB made at this end cannot be used...
How do people upload the DB they have made and tested on their systems? Uploading the PHP and HTML pages is simple, but getting the DB to be recognized by the host seems to be the problem.
(Actually USING CodeCharge looks to be pretty straightforward... it matches a lot of what I already know, and the examples are invaluable. It's the parts not covered in the manual that are killing me!)
Thanks.
Edward Lipsett
Fukuoka, Japan
|
|
|
|
DaveRexel
|
| Posted: 01/12/2003, 2:37 AM |
|
Hello Edward
I took a look at
http://pair.com/pair/support/tutorials/mysql.html
It seems you can create your own databases, create one and run the text file you generate with local phpmySQLAdmin Export function. This will create the tables you need and populate them. Now your local and remote databases will be in sync which is what CCS needs.
Hope this helps
Dave
|
|
|
|
DaveRexel
|
| Posted: 01/12/2003, 2:50 AM |
|
sorry that should read : phpmyadmin not phpMYSQLadmin
|
|
|
|
Walied
|
| Posted: 01/13/2003, 3:46 PM |
|
download mysql front program from administrating mysql db
|
|
|
|
elipsett
|
| Posted: 01/13/2003, 8:10 PM |
|
Thank you to all who replied; I am finally making a little progress here.
There are still a host of issues which are murky, but it works, and once CC, PHP and MySQL can all talk to each other on my system, I should be able to stamp out any new forest fires without too much difficulty.
Have a nice 2003!
Edward Lipsett
Fukuoka, Japan
|
|
|
|
|
