Adding Remote ODBC Access for New MySQL Database
Posted on 2014-12-01
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:
[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!