Mysql database - Arduino Yun

hello,

i have arduino yun connected ethernet port wired.

i have mysql database local on arduino yun.

via ssh can connect database.

now want use on laptop mysql workbench (or if know better software manage db) can connect database.

what problem?

regards
geert

melkske,

i use heidisql manage yun's mysql database, i'm sure mysql workbench work well.

i'm guessing issue trying connect yun's mysql via tcp/ip protocol, mysql server isn't set listen external connections.
the ssh access registers internal connection, listening for.

so there 2 ways can fix this:
1: connect using ssh instead of tcp/ip.
--i don't have mysql workbench installed, looking @ tutorial page, think pretty similar. https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-ssh.html
--make new connection , change type "tcp/ip on ssh" instead of "tcp/ip"
--fill in of information both ssh login , mysql login.
--you won't have make configuration changes mysql make work, ssh access slower, might matter if going lot of work through workbench.

2: make mysql server on yun listen external connections.
--find mysql configuration file. think located in here: /etc/my.conf
--edit , find entry "bind-address"
--change default value, might localhost or 127.0.0.1 0.0.0.0

code: [select]

bind-address = 0.0.0.0
--the server accept connections external or internal ip address
--you should able connect via tcp/ip.
--as added complication, quite possible mysql user accounts set accept logins particular ip/host. if go getting server error getting user/password error, case , have (via ssh) either add new admin user wildcard % host or change existing admin user's host column.

--edit: make sure reboot mysql server if make configuration changes. can either restart command line or reboot whole yun.

Arduino Forum > Products > Arduino Yún (Moderator: fabioc84) > Mysql database - Arduino Yun

arduino