Connect to MySQL

Connect to MySQL2017-09-15T18:39:21+00:00

Connect to MySQL

How to access MySQL from a Web Browser

You can access MySQL from anywhere – on campus, on a laptop, or at home – using this link:

https://web.cecs.pdx.edu/phpMyAdmin/

When you go to the webpage you will be prompted for your username and password. The username will always be your MCECS username, and the password will be provided to you when you activate your account. If you like you can change your MySQL password on the homepage of phpMyAdmin in the general settings section.

Access MySQL using the Unix/Linux command line

Use this command to access MySQL from the Unix/Linux command line:

mysql -h db.cecs.pdx.edu -u username -p

‘mysql’ is the program name, the ‘-h’ means host, and our host is db.cecs.pdx.edu, which is our database server. ‘-u’ means that what follows will be the username, which will be your normal MCECS username. The ‘-p’ means you will be prompted for your password after hitting enter.

Access MySQL from an MySQL client

You can access your MySQL database using a client you install on your personal computer, such as MySQL Workbench. These programs will need some information about our server in order to access your database.

Username: cecs username
Database: also your cecs username
Password: given to you when you make your MySQL account
Hostname: db.cecs.pdx.edu
Port: 3306 is the default port for MySQL