Connecting to mysql/mariadb
I've got a Yocto system that I'm working on that has mysql/mariadb configured but I can't connect to it with MySQL Workbench from another machine. mariadb is running, the network connection is live, but when I try to connect using MySQL Workbench I get an immediate "connection refused" response. I've tried user root, & mysql, same response. I'm using the default configuration from Yocto, so maybe I'm missing something that I should be configuring.
If anybody here has any experience with this I would appreciate any enlightenment you can give me.
Thanks in advance,
Greg Wilson-Lindberg
Hi Greg,
There are no leads to follow in logs? How about using netstat to check if port is really open?
Can you connect locally from a mysql client running in the device instead of using it externally?
BTW, verify that the skip-networking paramater is commented in your my.cnf file. Maybe networking is disabled by default.
Regards,
Quoted 14 lines · Greg Wilson-Lindberg
I've got a Yocto system that I'm working on that has mysql/mariadb configured but I can't connect to it with MySQL Workbench from another machine. mariadb is running, the network connection is live, but when I try to connect using MySQL Workbench I get an immediate "connection refused" response. I've tried user root, & mysql, same response. I'm using the default configuration from Yocto, so maybe I'm missing something that I should be configuring.
If anybody here has any experience with this I would appreciate any enlightenment you can give me.
Thanks in advance,
Greg Wilson-Lindberg
Signature · 23 lines
Victor M. Palacio Tárrega [email protected] <mailto:[email protected]> ** *Intemo Technologies****- Idetech Europe, S.L.* Mov.: (+34) 670 03 66 08 Tel: (+34) 93 336 16 51 C/ Montserrat Roig, nº 23, Pol. Ind. Pedrosa 08908 Hospitalet de Llobregat BARCELONA (SPAIN) | SmartCards |RFID |NFC |Biometría | Este correo electrónico puede contener información reservada y/o confidencial, destinada exclusivamente para el uso del destinatario. Si Vd no es el destinatario o la persona encargada de distribuirlo, no está autorizado a copiar o entregar esta comunicación a ninguna otra persona. Si ha recibido este correo electrónico por error, le rogamos nos lo notifique inmediatamente por teléfono o por el mismo medio. Gracias. Privilege/Confidential Information may be contained in this e-mail and is intended only for use of the addressee. If you are not the addressee, or the person responsible for delivering it to the person addressed, you may not copy or deliver this to anyone else. If you receive this e-mail by mistake, please notify us immediately by telephone or e-mail. Thank you.
Hi Greg,
Quoted 4 lines · Greg Wilson-Lindberg
I've got a Yocto system that I'm working on that has mysql/mariadb configured but I can't connect to it with MySQL Workbench from another machine. mariadb is running, the network connection is live, but when I try to connect using MySQL Workbench I get an immediate "connection refused" response. I've tried user root, & mysql, same response. I'm using the default configuration from Yocto, so maybe I'm missing something that I should be configuring.
If anybody here has any experience with this I would appreciate any enlightenment you can give me.
By default, mysql only listens on local interfaces. To make it listen on "external" interfaces also, change the "bind-address" setting in /etc/my.cnf on the target, and restart mysql.
// Martin