MySQL_Connector_Arduino icon indicating copy to clipboard operation
MySQL_Connector_Arduino copied to clipboard

Error in Wiki Documentation

Open PaulRB opened this issue 5 months ago • 1 comments

On this page it suggests the following command to test connection to your database from another system:

mysql -ubob -psecret –h192.168.0.2 --port=3306

When I tried this, replacing the user, password and host IP with my desired values, I get the following error:

ERROR 2002 (HY000): Can't connect to server on 'localhost' (115)

I thought to myself "that's strange, I'm asking it to connect to the host given in the command, I'm not asking it to connect to localhost". The system I am using has only the MariaDB client installed, it does not have MariaDB server installed, so there is nothing to connect to anyway.

After some time, I figured out the problem. In the command given on the wiki page, one of the hyphens is not a hyphen! The hyphen preceding the "h" is some other character that looks almost exactly like a hyphen, but isn't a hyphen. Deleting that character and re-typing a hyphen in its place fixed the problem, allowing me to connect to the MariaDB on the desired system.

Resolution: change mysql -ubob -psecret –h192.168.0.2 --port=3306 to mysql -ubob -psecret -h192.168.0.2 --port=3306

PaulRB avatar Sep 01 '24 15:09 PaulRB