Why install ODBC Connector for MySQL?
ODBC connector works as a standard gateway for programming languages, applications (such as Excel, Access, or OpenOffice) to communicate with database server with ease.
The database behind ODBC Connector could be MySQL, Microsoft SQL, PostgreSQL, Microsoft Access, or FileMaker, and more. You do not have to input the direct connection string into the code. You just need to know how to contact to ODBC Connector in a very simple way; especially, Delphi even makes it simpler with a few clicks.
If you want to see how to connect Delphi to mysql ODBC, click here to link to
Connect Delphi to MySQL using ODBC.
You could see the usage of MySQL in these two cases.
The first case is to connect to a local MySQL Server. It means you have MySQL Server running on your local computer.
In this case, the grant permission command is not necessary because MySQL allows localhost (127.0.0.1) to connect by default.
The second case is to connect to a remote MySQL Server. In this case, you want to connect to a remote machine where MySQL is running. Sometimes, we need to access to a remote MySQL to do some automatic tasks, such as maintaining database, checking database, or updating a WordPress blog using an auto web crawler application. If you want to run an application on one server and access database on another server, this case can be used.
In this case, the administrator on the machine 192.168.11.130 must execute the GRANT command. More about GRANT command in MySQL. Back to top
Which version