access to MySQL from Windows 7 via MySQL Workbench
Posted on 2010-09-01
I have a new MySQL database set up and I need to manage it with MySQL Workbench. Everything works great on the localhost, but as soon as I try to install a new server instance and connect to MySQL from my workstation, I get a failure. I have tried by both IP as well as hostname. I am using an administrator level database user on the SQL box. The database is on an Ubuntu Server machine and is working perfectly with this exception. I made sure the server is listening on 3306. It still appears that I have a permissions issue, but I can't seem to find out what it is. I can access the database management with PHPMyAdmin, but I need to be able to use some of the MySQL tools.