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!
BzowKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
don't update system tables like that...

you want to GRANT permissions to the user connecting from a given (or any) host:
http://dev.mysql.com/doc/refman/5.7/en/grant.html
example:
GRANT SELECT, INSERT, UPDATE, DELETE on db_name.* TO `youruser`@`remotehost`
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.