Using MySQL
Table of Contents
- Account Information
- Host names
- Connecting with MySQL Workbench
- Connecting with PHPMyAdmin
- Connecting with Command Line
Account Information
For SCE (Personal) Web Hosting
Request a MySQL account from an RA.
-
Account (username): [your_sce_username]
Note: the username is not prefixed with 'SCE\'.
Account information can viewed on your accounts page.
For DCM (Course) Web Hosting
- Account (username): [your_sce_username]
Check your accounts page for course information.
Host Names
For SCE (Personal) Accounts
Host name: sceweb.sce.uhcl.edu
For DCM (Course) Accounts
Host name: dcm.uhcl.edu
Connecting with MySQLWorkbench
MySQL Workbench
For SCE (Personal) Accounts- Host name (on campus access): sceweb
- Host name (off campus access): sce.uhcl.edu
- Host name (on campus access): dcmweb
- Host name (off campus access): dcm.uhcl.edu
Note: You will not be able to access the MySQL server from the UHCL Wifi.
The image should help you use MySQL Workbench Browser
Connecting With PHPMyAdmin
- Your SCE credentials to access the phpMyAdmin page
- Your MySQL credentials to access your MySQL database
Connecting With Command Line
MySQL Command Line Tool
mysql -h sceweb.sce.uhcl.edu -u <mysql_user_name> -p<mysql_password>