<div>
Cool, thanks, that was easier than I figured it would be.
</div>


Cool, thanks, that was easier than I figured it would be.

<div>
I had this problem a couple of times as well :p<br />
I like the MySQL workbench to do backups, even though I use phpmyadmin for everything else
</div>


I had this problem a couple of times as well :p
I like the MySQL workbench to do backups, even though I use phpmyadmin for everything else

<div>
<div class="content wysiwyg-content">
I have a new MySQL database set up and I need to manage it with MySQL Workbench. &nbsp;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. &nbsp;I have tried by both IP as well as hostname. &nbsp;I am using an administrator level database user on the SQL box. &nbsp;The database is on an Ubuntu Server machine and is working perfectly with this exception. &nbsp;I made sure the server is listening on 3306. &nbsp;It still appears that I have a permissions issue, but I can't seem to find out what it is. &nbsp;I can access the database management with PHPMyAdmin, but I need to be able to use some of the MySQL tools.
</div>
</div>


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.

access to MySQL from Windows 7 via MySQL Workbench

A Linux distribution is an operating system made as a software collection based on the Linux kernel and, often, on a package management system and are available for a variety of systems. A typical Linux distribution comprises a Linux kernel, GNU tools and libraries, additional software, documentation, a window system (the most common being the X Window System), a window manager, and a desktop environment. Most Linux systems are open-source software made available both as compiled binaries and in source code form, allowing modifications to the original software. Over three hundred distributions are in active development, including commercially backed distributions (such as Fedora, openSUSE and Ubuntu) and community-driven distributions (such as Debian, Slackware, Gentoo and Arch Linux).

Linux Distributions

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.