Labels

.net (1) *nix (1) administration (1) Android (2) Axis2 (2) best practice (5) big-data (1) business-analysis (1) code re-use (1) continuous-integration (1) Cordova-PhoneGap (1) database (2) defect (1) design (3) Eclipse (7) education (1) groovy (2) https (2) Hudson (4) Java (1) JAX-RS (2) Jersey (3) Jetty (1) localization (1) m2eclipse (2) MapForce (1) Maven (12) MySQL (1) Nexus (4) notes (4) OO (1) Oracle (4) performance (1) Perl (1) PL/SQL (1) podcast (1) PostgreSQL (1) requirement (1) scripting (1) serialization (1) shell (1) SoapUI (1) SQL (1) SSH (2) stored procedure (1) STS (2) Subclipse (1) Subversion (3) TOAD (3) Tomcat (4) UML (2) unit-testing (2) WAMP (1) WAS (3) Windows (3) WP8 (2) WTP (2) XML (4) XSLT (1)

Tuesday, March 5, 2013

Can't connect to MySQL from remote computer

I recently started using Uniform Server, a WAMP package, for creating a database for my test team.  I really like the convenience and ease of use of this package.  For example, port changes for Apache can be made from the Uniform Server dashboard application, rather than having to hand-edit configuration files.  But Uniform Server is meant for local development and by default, remote connections are not accepted.  For example, attempting a connection using the MySQL JDBC driver, remote users will get a "Connection refused" error.

To fix this, using the dashboard application, "Stop MySQL".  Then run the "MySQL Console".  From its command-line, run "mysqld1".  This starts up MySQL without the "--skip-networking" parameter and thus allows remote connections.