phpmysql

[tcjay]

Has anyone been able to install phpmyadmin on Powweb? If so I am looking for help. I have a program that requires me to create tables. The have provided the sql but if I can't get phpmyadmin to work, how else can I install the script? :)

[sophiespo]

phpMyAdmin is quite easy to set up -

1) Edit the config.inc.php to match your database and site info. The file explains each part so it shouldnt be too hard.

2) Add the #!/usr/local/bin/php line to the index.php, sql.php, read_dump.php (these are the main ones that you need to use to dump .sql files on your database). Im sure there are more files that need the line, I just havent used them as yet, if you get a 500 error on a file, then youll know it probably needs the line.

3) Upload all the files (php files in ASCII) and chmod the scripts to 755.

4) Open index.php in your browser, and it should have 2 frames, one on the left which displays your database and all its tables, the one on the right which just shows some info. Click on the name of your database on the left frame and itll give you some query options. Ifyou have a .sql file then you just click the 'Browse" button, choose the file then click "Go".

Youll need to password protect your phpmyadmin directory using .htaccess and .htpasswd - theres a thread around here somewhere that has a really good utility for creating these files. If you dont do it, someone could get to your phpMyAdmin and do horrible things to your database.

sophie

[tcjay]

Thanks, I will give it another try. :)

[technophilic]

Sophiespo,

I've tried this and other instructions and I'm still failing to get things going. I know that this can't be so terribly difficult, so I'll rehash what I did and let you tell me where I've gone wrong (per your instructions):

1.) Edited the config.inc.php file. Seemed intuitive.

2.) Added the #!/usr/local/bin/php line to the index.php, sql.php, read_dump.php.

Ok, no problems there . . . I cut/pasted it in at the beginning of each file.

3.) Upload all the files (php files in ASCII) and chmod the scripts to 755.

Here's where I'm concerned. At first I tried doing this automatically (first via WS_FTP and then via LeapFTP). No luck.

Next, I manually uploaded ALL php files in ASCII format and let the others go automatically. Still no luck.

When you say "the scripts", I interpret this to mean specifically these three files. Should this be extended to mean "all php scripts"?

4.) I try to call things up via a browser calling the index file (e.g. www.mysite.com/mypath/index.php) but I can't get any further :(

If there are other instructions I'm missing here (like Chmod-ing other folders) please let me know. This really does not seem like it should be hard. I'm sure I'm missing something simple but despite all the explicit instructions for phpNuke and other installations, only the information that you setup for phpMyAdmin was present.

Sincerely,

Technophilic

[technophilic]

Sophiespo,

Nevermind my notes . . . I fixed my problem. It would have been a good idea for me to have put the path in the correct place! Ahh, the things we have to go through to learn.

Thanks,

Technophilic