Link to home
Start Free TrialLog in
Avatar of BzowK
BzowKFlag for United States of America

asked on

Adding Remote ODBC Access for New MySQL Database

Hey Guys -

I'm trying out a new app which requires a MySQL Database. Due to resources as well as not planning to use the app 100% of the time, I planned to install MySQL and create the database on a separate host than the app located within a VM.  The two systems are not on a domain, but on the same local network and I have full rights to each.  The system with the app is running Windows 8.1 and the MySQL server is running 2012 R2.

I installed MySQL and created a basic database.  Once done, I installed the ODBC connector locally on the MySQL server and was able to successfully connect.  I then installed the ODBC connector on the other server which has the app, but when trying to connect to the DB on the other server, I go the error:

Connection Failed
[MySQL][ODBC 5.3(w) Driver] Host '192.168.0.25' is not allowed to connect to this MySQL server:

Since then, I've been trying to research and find out how to grant it access.  After looking through many things, I found the below two "example" commands.

  mysql> update db set Host='10.199.15.46' where Db='webdb';
  mysql> update user set Host='10.199.15.46' where user='webadmin';

However, when I try to run the first one (using 'diskboss' instead of 'webdb', I get the error:

ERROR 1046 (3D000): No database selected

I then entered 'use diskboss' and tried the command again. but got:

ERROR 1146 (42S02): Table 'diskboss.db' doesn't exist

What am I doing incorrectly?  How can I add remote access?  I installed Workbench, too, but couldn't find an option to do it in there, either.  By the way, when I run 'show databases';, I get the below:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| diskboss           |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 sec)

Any suggestions?  Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial