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?
TS-212P Mysql cannot log in
-
- Starting out
- Posts: 21
- Joined: Wed Nov 27, 2013 5:24 am
Re: TS-212P Mysql cannot log in
*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.
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.
-
- New here
- Posts: 2
- Joined: Sun Jun 12, 2016 12:22 pm
Re: TS-212P Mysql cannot log in
@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.
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.
- OneCD
- Guru
- Posts: 12155
- Joined: Sun Aug 21, 2016 10:48 am
- Location: "... there, behind that sofa!"