I’ve setup the mysql innodb cluster with some difficulty, and have mysqlrouter running and listening on ports with the correct IP address. I then have a C program trying to connect to mysqlrouter to submit queries to, but the function, mysql_connect() gives me an error: “No such file or directory”.
It’s likely it was looking for a mysqld-specific file. Has anyone managed to setup communications between a C program and mysqlrouter?
Edit: Fixed, have to setup permissions for the IP address mysqlrouter is on
The immediate answer, without more information, is that you are trying accessing MySQL (the protocol, not the server), using unix socket/named pipes, which is the only reason I can think from the top of my mind why a mysql connector may want to open a file. Check your connection options and make sure you are connecting using TCP, with a host, port combination.
It could be something else, but it is what I would try debugging first, for other issues we would need more context and code.
Fixed, I have to setup permissions for the IP address mysqlrouter is on.
On the sql node, do the following:
mysql> GRANT PRIVILEGES ON . TO account@ IDENTIFIED BY ‘password’;
mysql> FLUSH PRIVILEGES;