What is MySQL Portal and how do I use it?

What is MySQL Portal?

MySQL Portal is a web-based application to manage MySQL database users' accounts for databases hosted on the UIC Technology Solutions MySQL host servers.

How do I access the MySQL Portal?

It can be accessed using the web-based URL mysqlportal.uic.edu. Log in using your UIC credentials.

How do I use the MySQL Portal? 

Existing Database Owners can use the portal to perform the following actions:

• Grant Access (adding new users)

• Manage Database Users:

  • Delete Access

  • Change Password

  • Change access ro <-> rw

• Update password for your own MySQL (NetID) user account 

• Search feature limited to the databases you own

Grant Access 

1. Under a specific database card, select button "Grant Access."
   
   
    
2. You can grant access to a NetID user or a Non-NetID user account. If it's a NetID user, select the NetID checkbox and enter the NetID If it's non-NetID user, keep the checkbox unchecked and create a new username.
   1. Adding a NetID User:
      
      
       
   2. Adding a Non-NetID user:
      
      
      
       
3. Select the type of access, whether is "Read Only (ro)" or "Read-Write (rw)" and "Submit". 

Manage Database Users - Delete Access

1. Under a specific database card, select "Manage Users."
    
2. Select the user you want to delete access.
   
   
   
    
3. Select "Delete Access" and "Submit". This removes access for the user and if it's a Non-NetID user, it deletes the user completely. NetID users are not deleted as they might have access to other databases.  

Manage Database Users - Change Password

1. Under the specific database card, select "Manage Existing Users."
    
2. Select the user to change password. You can change passwords for only non-NetID users.
   
   
    
3. Enter the updated password and select "Submit".

Manage Database Users - Change Access (ro <-> rw) 

1. Under the specific database card, select "Manage Existing Users."
    
2. Select the user to change access. 
   
   
    
3. Select "Read-Only" or "Read-Write", then select "Submit".

Update password for your own MySQL (NetID) user account  

To update your own MySQL NetID DB user password, follow the below steps. Note: This does not change your UIC NetID password. These credentials are limited to MySQL Database usage. 

1. On the top menu, select "Change Password"
    
2. Enter the new password and select "Submit".

Search 

You can search database cards for databases where you are listed as owner. 

• Search by database name.

• Search by owner NetID.

• Search by DB username.