Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Using MYSql, I have to connect to a server, but I am not sure how to do the conn

ID: 3719028 • Letter: U

Question

Using MYSql, I have to connect to a server, but I am not sure how to do the connection.

I have the credentials for connectivity: url, username and a password.

Setup New Connection Type a name for the connection Connection Method: Standard (TCP/IP) Parameters SSL Advanced Method to use to connect to the RDBMS Hostname: 127.0.0.1 Port: Name or IP address of the server host - and TCPIP port. Username: root Name of the user to connect with. Password: user's password. Will be requested later if it's The not set. Store in Vault tksr Default Schema: The schema to use as default schema. Leave blank to select it later. Configure Server Management. Test Connection Cancel OK

Explanation / Answer

Enter your Connection URL/ip in the field HostName

Enter port in the field Port

Enter the username in the field Username

Click on Store in Vault to enter the password

Now click on test connection button at the bottom to test the connection.

click OK button to connect to database.