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
Installing Wordpress

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

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

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

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

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

Installing Applications

Installing Wordpress

1. In your web browser open http://wordpress.org/
2. Click the "Download Wordpress" button
3. Click the "Download Wordpress x.x.x" button where x.x.x is a version
4. When the download is finished, open the zip file:
5. Open the "wordpress" folder in the zip file
6. Copy all of the files
7. Open your PHPMySQL drive
8. Open the Wordpress folder
9. Paste the files, this will take a few minutes
10. Open https://phpmysql.howardcc.edu/Wordpress/Username, replacing username with your username, in a webbrowser
11. Click "Creation Configuration File" button
12. Click "Lets Go" button
13. Enter your username into the "Username" field and into the "Database" field, and the MySQL password your instructor provided into the "Password" field.
14. Click the "Submit" button
15. Click the "Run the Install" button
16. Enter in a Site Name for the "Site Name" field, your username in the "Username" field, a new password that is 7 characters long for the "Password" field and the confirm field, and your email into the email field.
17. Click the "Install Wordpress" button
18. Click the "Log In" button
19. Sign in
20. From here you can write posts, change you themes, add users, and all other administrative tasks
21. To access the admin page again you can browse to https://phpmysql.howardcc.edu/Wordpress/Username/wp-admin, replacing Username with your username.