What part am I missing? FTP Server, FTP Client FileZilla, MySQL and PHP

Typr451's Avatar
Go4Expert Member
Hi!

I'm begining to work on a project and this is the part I love when I can't make effective Google-queries because I haven't got all the buzzwords down

Some years ago I did little project for a course with mainly JSP, SQL and Resin to act as a web-server. I configured Resin to connect the database to the web-pages. I had to place some sql- and jsp-packages for Resin to find aswell and everything worked.

This time I've decided to work with PHP, SQL and it's all supose to be on a FTP server. I found FileZilla which had got a lot of good comments and I've been able to contact and upload files to the FTP server.

I'm not really sure where I am now I think I need to know how to configure a FTP Server to work like Resin did for me and make it connect the database to the web-pages. It also need to find a PHP- and SQL-package. I've Googled for combinations of PHP, SQL, FTP, FileZilla and install/configure etc. but I can't really find anything interesting so it makes me think I'm missing some words.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
FTP is something different than the server which would run your PHP Files.

I would try to give an example

First create a simple PHP file and name in xyz.php
Put the following content into the file
PHP Code:
<?php
echo phpinfo();
?>
Now open the filezilla and connect to your FTP server.
See if there is any folder named public_html / httpdocs or anything where you can host your php files for Apache server to run it.
After uploading the xyz.php file into the server use the browser to open the file

yourdomain.com/xyz.php

You should be able to see all the php configuration available on your server.

I hope it helps
Typr451's Avatar
Go4Expert Member
Yes, thank you I understand much better what I'm working with now

The part about MySQL shown with phphinfo() seems to be installed, it shows a version and where to find socket-, include- and lib-files however the username and passwords are all blank so I don't think it've been configured properly.

The thing now is that I don't see the config-files or any files in FileZilla (FTP client, the server isn't mine) apart from the web-pages. I get quite a few tutorials with my searches but they all explain how to install everything from scratch on your own machine. I can see configure commands at the top of phpinfo but they seem to be arguments to where to find the config-files, and I sitll can't see them.

I can't find an answer to this so I'll ask, can I change the config-files (like the MySQL-config) with FileZilla? Should they be seen in the directory tree? Or do I have to contact the admin and let him go through the MySQL-configuration again and set a username and password? I've checked the options to show hidden files but they don't seem to be there, also trying to reach for example /var/mysql says "no such directory or file", so they really don't seem to be there.

I don't really think I should be able to get to the /var/mysql-folder, FileZilla doesn't give me access to his machine, only the Apache web server which only makes the web-pages available. Then through FileZilla I can change what files it makes available, however I'm hoping I'm wrong

Also to add a little answer to my first post: I was also thinking about a program like SQLyog to remotly create tables and such to the database. I still need the username/password for it to work though
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
For MySQL you need to run queries from your PHP Files only and do not need anything special folder access. phpMyAdmin would be there in your control panel to see the databases, create them and other stuff.
Typr451's Avatar
Go4Expert Member
Don't I still need a MySQL-username and password for phphMyAdmin? I mean "root" and something? In the MySQL-part of the printout from phpinfo it says "no value" on host, password, port, socket and user so I think MySQL itself haven't been configured.

I got phpMyAdmin to work I think (with lots of warnings), I follwed the instructions and placed the files for the web server to find and I could get into the configure file with phpMyAdmin/setup. However I had to enter a password there as well, wouldn't that be the password you set when you confiure MySQL?

It seems too insecure to be able to set that password by simply typing /setup in someone's URL, but I tried whatever for password and tried to login with it from /phpMyAdmin but it wasn't right.

I've also read a couple of tutorials for phpMyAdmin and they seem to say you'll use your root/password for MySQL in the config-files, still I'm hoping I'm wrong. It'll save me some trouble
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Yes you would need the username and password but what I meant is you would not need any special folder for it.
Typr451's Avatar
Go4Expert Member
I'm not sure I should say this, but if it says "no value" apparently you're able to login to phpMyAdmin with username/password " " or space. I'm saying this now because I've taken are of the issue on my sever, still not fun for new people setting up their database and forgetting to set a password, or careless people leaving the phpMyAdmin on their server. This wasn't possible with SQLyog.