Hi,
To connect MATLAB to a MySQL database on another PC, you’ll need to ensure a few things are set up correctly.
1. Find the ip-address of machine from where you want to connect.
2. In the MySQL server configuration, add the following and restart the mysql server to apply these changes.
% my.cnf file
[mysqld]
bind-address = <ip-address-of-client-machine>
3. Granting Access: Granting access to a user from a remote host.
GRANT ALL PRIVILEGES ON *.* TO 'username'@'client_machine_ip' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
4. Firewall Settings: Ensure that the firewall on the remote PC allows incoming connections on the MySQL port (default is 3306).
5. MATLAB Connection: Use the database function in MATLAB to connect to the remote MySQL server. Replace 'remote_ip' with the IP address of the remote PC:
conn = database('your_database_name', 'username', 'password', 'Vendor', 'MySQL', 'Server', 'remote_ip', 'PortNumber', 3306);
