TS-212P Mysql cannot log in

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Locked
enzo3856
Starting out
Posts: 21
Joined: Wed Nov 27, 2013 5:24 am

TS-212P Mysql cannot log in

Post by enzo3856 »

TS-212P running 4.3.3.0868

I just did a full reset on the NAS and setup mysql, enabled tcp/ip 3306, etc.
I can login using sqlbuddy and phpmyadmin no problem.. this is using the standard "root" "admin" login

I created a new user for kodi and was having issues connecting to the db.
I then installed MySQL Workbench on my PC. When I try to login to mysql from my PC I get the error "cannot connect to MySQL server on 192.168.0.4"

Why can I connect locally on the NAS but not from another machine on the same network?
What am I doing wrong?
enzo3856
Starting out
Posts: 21
Joined: Wed Nov 27, 2013 5:24 am

Re: TS-212P Mysql cannot log in

Post by enzo3856 »

*Problem Solved*
I had two issues...
#1 - I restarted mySQL. I think once it is started, if you then enable TCP access it does not work unless you restart the service
#2 - Once I restarted with TCP enabled, mysqWorkbench was incompatible with my version of MySQL... solution is to install an older version of the admin tools.
At this point it all seems to be working again.
msdiniz
New here
Posts: 2
Joined: Sun Jun 12, 2016 12:22 pm

Re: TS-212P Mysql cannot log in

Post by msdiniz »

@enzo3856 is right.
Mine is a TS-220 with version mysqlnd 5.0.11.
At HostGator I have a version libmysql - 5.6.43.

Workbench 6.3 connects to both; any higher version refuses to connect with TS-220's MySQL.
User avatar
OneCD
Guru
Posts: 12010
Joined: Sun Aug 21, 2016 10:48 am
Location: "... there, behind that sofa!"

Re: TS-212P Mysql cannot log in

Post by OneCD »

* topic locked to prevent further necroposting *

ImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImage
Locked

Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”