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 SFTP
Server : phpmysql.howardcc.eduUsername edu
Username : Your HCC Username, such as jdoe1234Password jdoe1234
Password : Your HCC passwordPort password
Port : 99022

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

Enter your HCC password in the password field
Click the Quickconnect button Image Removed
 Image Added

1. When it asks if you want to trust the host, click "OK" Image Removed
    Image Added
2. On the right side you will see the files in your drive on the server you can download and editThe edit
   The 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

...

1. Open Explorer Image Removed
2. Click on "Map network drive" Image Removed
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". Image Removed
5. Click the "Finish" button
6. Enter in your HCC Username and Password credentials Image Removed
7. Click the "OK" button
8. You can now read and write to your drive Image Removed
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. To get back to this folder later, click phpmysql.howardcc.edu under "Shared" in Finder Image Removed
2. Then open the folder with your username Image Removed

...

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

...

1. Open Explorer Image Removed
2. Click on "Map network drive" Image Removed
3. Type in "https://phpmysql.howardcc.edu/HCCMAIN"
4. Select a free drive letter. Check "Connect using different credentials". Image Removed
5. Click the "Finish" button
6. Enter in your HCC Username and Password credentials Image Removed
7. Click the "OK" button
8. When you open the drive you will see folders for all the instructors and all the students Image Removed
   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 : Image Removed
10. Instructors – shortcut to the Instructors folder for students to access shared files
11. 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
Public – For your publicly accessible website https://phpmysql.howardcc.edu/Users/Username replacing Username with your HCC username
12. 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

...