- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Trouble trying to connect mySQL Workbench to NetMRI mySQL database
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2022 08:40 AM
Not sure if this has been asked before but I am trying to connect mySQL Workbench to the NetMRI database and is failing each time. Not sure why at the moment.
I have been using HeidiSQL for sometime and wanted to move to this Workbench.
So I know the database connection is working (i.e. User account/Password/Port 6033).
I am using the standard TCP/IP connection.
Has anyone suggestions/ideas for this?
Thanks
Solved! Go to Solution.
Re: Trouble trying to connect mySQL Workbench to NetMRI mySQL database
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2022 01:29 AM
Ok. solved the problem.
For reference for others who want to use mySQL Workbench to connect to the NetMRI database, you need to add the following to the Advanced Tab of the connection settings for the NetMRI database.
The following goes in to the "Others" field
defaultAuth=mysql_native_password OPT_CHARSET_NAME=utf8