View Forum Topic

Forums
CS320
MySQL Connection is not setting up properly for user.

Author	Message
nmodi Posts: 3	Posted 00:52 Feb 26, 2014 \| Hello Dr. Sun, I tried to set up connection on server with my username in MySQL workbench. It shows me error, the snapshots of errors are attached as follows. Can you please, help me out in this issue. - regards, Nirav Modi cs320stu62 Attachments: error.png errormsg2.png
spandya3 Posts: 14	Posted 01:05 Feb 26, 2014 \| you should try this use your cs3 server password then check it
nmodi Posts: 3	Posted 01:46 Feb 26, 2014 \| I already tried all these things. -dropped and recreated the connection. - changed password(in SQL Query). - reinstalled the workbench. - directly created the connection without schema passing. then tried to create default schema.. but it didn't work... btw thanks...
redge Posts: 31	Posted 06:58 Feb 26, 2014 \| Use an SSH passthrough; the MySQL DBs on CS3 aren't (or at least shouldn't be) exposed to outside connections.
cysun Posts: 2935	Posted 08:02 Feb 26, 2014 \| nmodi wrote: Hello Dr. Sun, I tried to set up connection on server with my username in MySQL workbench. It shows me error, the snapshots of errors are attached as follows. Can you please, help me out in this issue. - regards, Nirav Modi cs320stu62 I just re-created the cs320stu62 database. You must have dropped it, which is why you got a "unknown database" error. Please don't do that again.
cysun Posts: 2935	Posted 08:04 Feb 26, 2014 \| redge wrote: Use an SSH passthrough; the MySQL DBs on CS3 aren't (or at least shouldn't be) exposed to outside connections. Actually 3306 is not firewalled on CS3. CS3 is a class server with temporary accounts and no important data, so we chose convenience over security.