The above can also be done with a tool like MySQL WorkBench too run the same commands above in a query window or via the Users and Privileges window. ThatвЂ™s our Linked Server MySQL login ready! Which I can confirm with a quick write test. Put on the User hat and do what you need to do. Below IвЂ™m opening the mysql.exe file rather than using the MySQL Command Line Client application which logs in as root. If I want to test this new MySQL login locally, I can create the user using вЂlocalhostвЂ™ too.

GRANT SELECT ON milk.* TO connections are within the 172.31.1.0 network, so IвЂ™m adding in a wildcard (%) for all addresses on this range to be allowed to connect with this login. INSERT INTO animal VALUES (2,'cow','black with white spots','') Д¬REATE USER IDENTIFIED BY 'eCh0Ch4rl1E' INSERT INTO animal (1,'cow','white with black spots','') Create test database & tableД¬REATE TABLE animal (id INT, type VARCHAR(50), breed VARCHAR(50), age DATE) First SQL steps here for me are to create the test database & table. Tool like MySQL WorkBench or via command.ДЇirst up, IвЂ™ll get connected to MySQL via CLI.Д¬REATE USER and then GRANTING SELECT capabilities for all tables* within a вЂmilkвЂ™ database. # Create Linked Server to a MySQL Database.ДЄs always, this kind of task can be done using a management Once the above is done, this post runs through the following steps to get a Linked Server configured: The above was setup similar to whatвЂ™s included in some of my previous posts: This here is a simple diagram of the setup in this post. This is my 3 rd Linked Server post, and this time itвЂ™s to a MySQL database.

Mysql create database workbench