Using the PHPMySQL Server
Contents
Access to PHPMySQL
Public Website Access
Accessing the Server from FileZilla/FTP Client
FTP Connection Quick Reference
Accessing the Server from Windows via WebDav - Students
Accessing the Server from Windows via WebDav – Instructor
PHPMyAdmin Access
MySQL Command Line Access
Installing Applications

Wordpress is not allowed on PHPMySQL server. Any installed instances will be removed 

Access to PHPMySQL

Public Website Access

1. Open a web browser
2. In the URL bar enter https://phpmysql.howardcc.edu/Users/Username replacing Username with your HCC username
3. When the page loads you should see :
4. You can change this page by replacing the index.html in your Public folder, for more details follow the instructions below.

Accessing the Server from FileZilla/FTP Client - Recommended method

FTP Connection Quick Reference

Protocol: FTPSServer : phpmysql.howardcc.eduUsername : Your HCC Username, such as jdoe1234Password : Your HCC passwordPort : 990

1. Open filezilla or your preferred FTP client
2. Enter "ftps://phpmysql.howardcc.edu" into the host fieldEnter your HCC username in the username field. Ex : jdoe1234

Enter your HCC password in the password field Click the Quickconnect button

1. When it asks if you want to trust the host, click "OK"
2. On the right side you will see the files in your drive on the server you can download and editThe left side will have your local files you can upload to the server
3. There can be multiple folders inside the drive depending on what classes you are in, they are:
   1. PHP – For PHP class assignments any files placed in here can be accessed publicly via https://phpmysql.howardcc.edu/PHP/Username replacing Username with your HCC username
   2. Public – For your publicly accessible website https://phpmysql.howardcc.edu/Users/Username replacing Username with your HCC username
   3. Wordpress – Wordpress class folder, it is publicly accessible at https://phpmysql.howardcc.edu/Wordpress/Username replacing Username with your HCC username
4. For further help with using FileZilla see its Tutorial

Accessing the Server from Windows via WebDav - Students - NOT RECOMMENDED, USe FTPS instead

1. Open Explorer
2. Click on "Map network drive"
3. Type in "https://phpmysql.howardcc.edu/HCCMAIN/UserName" replacing "UserName" with your HCC Username.
4. Select a free drive letter. Check "Connect using different credentials".
5. Click the "Finish" button
6. Enter in your HCC Username and Password credentials
7. Click the "OK" button
8. You can now read and write to your drive
9. This main folder and it's subfolders can be accessed by you and instructors in the web browser at https://phpmysql.howardcc.edu/HCCMAIN/UserName replacing Username with your HCC username
10. There can be multiple folders inside the drive depending on what classes you are in, they are:
    1. PHP – For PHP class assignments any files placed in here can be accessed publicly via https://phpmysql.howardcc.edu/PHP/Username replacing Username with your HCC username
    2. Public – For your publicly accessible website https://phpmysql.howardcc.edu/Users/Username replacing Username with your HCC username
    3. Wordpress – Wordpress class folder, it is publicly accessible at https://phpmysql.howardcc.edu/Wordpress/Username replacing Username with your HCC username

Accessing the Server from OSX via Webdav - Students - NOT RECOMMENDED, Use FTPS instead

1. Open Finder
2. In the menu bar, click "Go" then "Connect to Server"
3. Type in "https://phpmysql.howardcc.edu/HCCMAIN/UserName" replacing "UserName" with your HCC Username. Click "Connect"
4. Type in your HCC Username and password
5. Click the "Connect" button
6. The folder will open up with subfolder and you can now upload your webpages
   1. To get back to this folder later, click phpmysql.howardcc.edu under "Shared" in Finder
   2. Then open the folder with your username
7. This main folder and it's subfolders can be accessed by you and instructors in the web browser at https://phpmysql.howardcc.edu/HCCMAIN/UserName replacing Username with your HCC username
8. There can be multiple folders inside the drive depending on what classes you are in, they are:
   1. PHP – For PHP class assignments any files placed in here can be accessed publicly via https://phpmysql.howardcc.edu/PHP/Username replacing Username with your HCC username
   2. Public – For your publicly accessible website https://phpmysql.howardcc.edu/Users/Username replacing Username with your HCC username
   3. Wordpress – Wordpress class folder, it is publicly accessible at https://phpmysql.howardcc.edu/Wordpress/Username replacing Username with your HCC username

Accessing the Server from Windows via WebDav – Instructor - NOT RECOMMENDED, Use FTPS instead

1. Open Explorer
2. Click on "Map network drive"
3. Type in "https://phpmysql.howardcc.edu/HCCMAIN"
4. Select a free drive letter. Check "Connect using different credentials".
5. Click the "Finish" button
6. Enter in your HCC Username and Password credentials
7. Click the "OK" button
8. When you open the drive you will see folders for all the instructors and all the students
   1. There are INS_Username folders, these are the other instructors folders, there are also each INS_Username folder also has a shortcut folder with just the Username.
   2. The Instructors folder is for Instructors to place materials for students to access on the server such as a config file.
9. Inside each instructor or students folder there can be the following subfolders :
   1. Instructors – shortcut to the Instructors folder for students to access shared files
   2. PHP – For PHP class assignments any files placed in here can be accessed publicly via https://phpmysql.howardcc.edu/PHP/Username replacing Username with your HCC username
   3. Public – For your publicly accessible website https://phpmysql.howardcc.edu/Users/Username replacing Username with your HCC username
   4. Wordpress – To be used to install Wordpress, it is publicly accessible at https://phpmysql.howardcc.edu/Wordpress/Username replacing Username with your HCC username

PHPMyAdmin Access

1. Open a web browser
2. In the URL bar enter https://phpmysql.howardcc.edu/phpmyadmin/
3. Enter in your username, and the database password provided to you by your instructor, then click "Go"
4. From this page you will be able to create, modify, delete, and manage the database used by Wordpress and other applications installed on the server.

MySQL Command Line Access

1. Open a command prompt
2. Change directory to "C:\wamp\bin\mysql\mysql5.5.24\bin", by running cd C:\wamp\bin\mysql\mysql*\bin
3. Run "mysql -h phpmysql.howardcc.edu -u UserName –p", replacing "UserName" with your HCC username.
4. Enter your MySQL password provided by the instructor.
5. Once you are logged in you will have a mysql> prompt to run SQL statements from