#2002 Cannot log in to the MySQL server
-
- New here
- Posts: 5
- Joined: Thu Nov 19, 2015 12:32 pm
#2002 Cannot log in to the MySQL server
Hi,
I have a TS-669L TurboNAS and recently update the firmware to 4.2.
Looks nice and all features are promising.
SQL Server Enabling: From Control Panel/SQL Server I enabled SQL Server (MariaDB 5.5.44) and TCP/IP networking on 3306 port.
phpMyAdmin: From Apps I installed phpMyAdmin on my NAS to access the db server.
Using the default user/password (root/admin) I cannot login into MySQL and end up with "#2002 Cannot log in to the MySQL server" error.
I tried to reset the db password: didn't work
I Disable/Enable MySQL server many times: didn't work
I clean all cookies and history from my browser: didn't work
I'm out of options here and I don't know what to do more to get access to MySQL db instance.
I need MySQL access as I cannot continue WordPress installation without db access credentials.
Is this a bug related to last firmware update 4.2 ?
Any ideeas what to do next are most welcomed as for now I'm stuck.
Many thanks.
I have a TS-669L TurboNAS and recently update the firmware to 4.2.
Looks nice and all features are promising.
SQL Server Enabling: From Control Panel/SQL Server I enabled SQL Server (MariaDB 5.5.44) and TCP/IP networking on 3306 port.
phpMyAdmin: From Apps I installed phpMyAdmin on my NAS to access the db server.
Using the default user/password (root/admin) I cannot login into MySQL and end up with "#2002 Cannot log in to the MySQL server" error.
I tried to reset the db password: didn't work
I Disable/Enable MySQL server many times: didn't work
I clean all cookies and history from my browser: didn't work
I'm out of options here and I don't know what to do more to get access to MySQL db instance.
I need MySQL access as I cannot continue WordPress installation without db access credentials.
Is this a bug related to last firmware update 4.2 ?
Any ideeas what to do next are most welcomed as for now I'm stuck.
Many thanks.
- Toxic17
- Ask me anything
- Posts: 6477
- Joined: Tue Jan 25, 2011 11:41 pm
- Location: Planet Earth
- Contact:
Re: #2002 Cannot log in to the MySQL server
have a read of this thread in regards t your issue especially the comments from Patrick.
Also you may also want to clear you Web Browsers cache and Cookies.
Also you may also want to clear you Web Browsers cache and Cookies.
Regards Simon
Qnap Downloads
MyQNap.Org Repository
Submit a ticket • QNAP Helpdesk
QNAP Tutorials, User Manuals, FAQs, Downloads, Wiki
When you ask a question, please include the following
NAS: TS-673A QuTS hero h5.1.2.2534 • TS-121 4.3.3.2420 • APC Back-UPS ES 700G
Network: VM Hub3: 500/50 • UniFi UDM Pro: 3.2.9 • UniFi Network Controller: 8.0.28
USW-Aggregation: 6.6.61 • US-16-150W: 6.6.61 • 2x USW Mini Flex 2.0.0 • UniFi AC Pro 6.6.62 • UniFi U6-LR 6.6.62
UniFi Protect: 2.11.21/8TB Skyhawk AI • 3x G3 Instants: 4.69.55 • UniFi G3 Flex: 4.69.55 • UniFi G5 Flex: 4.69.55
Qnap Downloads
MyQNap.Org Repository
Submit a ticket • QNAP Helpdesk
QNAP Tutorials, User Manuals, FAQs, Downloads, Wiki
When you ask a question, please include the following
NAS: TS-673A QuTS hero h5.1.2.2534 • TS-121 4.3.3.2420 • APC Back-UPS ES 700G
Network: VM Hub3: 500/50 • UniFi UDM Pro: 3.2.9 • UniFi Network Controller: 8.0.28
USW-Aggregation: 6.6.61 • US-16-150W: 6.6.61 • 2x USW Mini Flex 2.0.0 • UniFi AC Pro 6.6.62 • UniFi U6-LR 6.6.62
UniFi Protect: 2.11.21/8TB Skyhawk AI • 3x G3 Instants: 4.69.55 • UniFi G3 Flex: 4.69.55 • UniFi G5 Flex: 4.69.55
-
- New here
- Posts: 5
- Joined: Thu Nov 19, 2015 12:32 pm
Re: #2002 Cannot log in to the MySQL server
Thanks for your replay ... but I already did that and clean Web Browsers cache, cookies, history, browsing, form data, and more ... a complete clean up.Toxic17 wrote:have a read of this thread in regards t your issue especially the comments from Patrick.
Also you may also want to clear you Web Browsers cache and Cookies.
Didn't help.
Where can I find Patrick's comments about similar issue?
Is this a bug related to last firmware update 4.2 ?
Any ideeas what to do next are most welcomed as for now I'm stuck.
Thank you,
O
- schumaku
- Guru
- Posts: 43578
- Joined: Mon Jan 21, 2008 4:41 pm
- Location: Kloten (Zurich), Switzerland -- Skype: schumaku
- Contact:
Re: #2002 Cannot log in to the MySQL server
Either change the PHPMyAdmin config to connect instead of 127.0.0.1 new to localhost ... or enable the TCP/IP connection feature in the NAS SQL Server control panel.
Using search before posting - #2002 ...
Using search before posting - #2002 ...
-
- New here
- Posts: 5
- Joined: Thu Nov 19, 2015 12:32 pm
Re: #2002 Cannot log in to the MySQL server
Thanks, but I already did thatschumaku wrote:Either change the PHPMyAdmin config to connect instead of 127.0.0.1 new to localhost ... or enable the TCP/IP connection feature in the NAS SQL Server control panel.
Using search before posting - #2002 ...
Still cannot connect to SQL using phpMyAdmin
Here is a piece of my common.inc.php file
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
-
- New here
- Posts: 5
- Joined: Thu Nov 19, 2015 12:32 pm
Re: #2002 Cannot log in to the MySQL server
This is a piece of my SQL settingsschumaku wrote:Either change the PHPMyAdmin config to connect instead of 127.0.0.1 new to localhost ... or enable the TCP/IP connection feature in the NAS SQL Server control panel.
Using search before posting - #2002 ...
You do not have the required permissions to view the files attached to this post.
- Toxic17
- Ask me anything
- Posts: 6477
- Joined: Tue Jan 25, 2011 11:41 pm
- Location: Planet Earth
- Contact:
Re: #2002 Cannot log in to the MySQL server
uninstall the phpmyadmin you have installed from app center.
then try this one.
http://qnap.community/viewtopic.php?f=42&t=12
you need to install GIT 2.1.0 first however.
http://forum.qnap.com/viewtopic.php?f=301&t=97220
then try this one.
http://qnap.community/viewtopic.php?f=42&t=12
you need to install GIT 2.1.0 first however.
http://forum.qnap.com/viewtopic.php?f=301&t=97220
Regards Simon
Qnap Downloads
MyQNap.Org Repository
Submit a ticket • QNAP Helpdesk
QNAP Tutorials, User Manuals, FAQs, Downloads, Wiki
When you ask a question, please include the following
NAS: TS-673A QuTS hero h5.1.2.2534 • TS-121 4.3.3.2420 • APC Back-UPS ES 700G
Network: VM Hub3: 500/50 • UniFi UDM Pro: 3.2.9 • UniFi Network Controller: 8.0.28
USW-Aggregation: 6.6.61 • US-16-150W: 6.6.61 • 2x USW Mini Flex 2.0.0 • UniFi AC Pro 6.6.62 • UniFi U6-LR 6.6.62
UniFi Protect: 2.11.21/8TB Skyhawk AI • 3x G3 Instants: 4.69.55 • UniFi G3 Flex: 4.69.55 • UniFi G5 Flex: 4.69.55
Qnap Downloads
MyQNap.Org Repository
Submit a ticket • QNAP Helpdesk
QNAP Tutorials, User Manuals, FAQs, Downloads, Wiki
When you ask a question, please include the following
NAS: TS-673A QuTS hero h5.1.2.2534 • TS-121 4.3.3.2420 • APC Back-UPS ES 700G
Network: VM Hub3: 500/50 • UniFi UDM Pro: 3.2.9 • UniFi Network Controller: 8.0.28
USW-Aggregation: 6.6.61 • US-16-150W: 6.6.61 • 2x USW Mini Flex 2.0.0 • UniFi AC Pro 6.6.62 • UniFi U6-LR 6.6.62
UniFi Protect: 2.11.21/8TB Skyhawk AI • 3x G3 Instants: 4.69.55 • UniFi G3 Flex: 4.69.55 • UniFi G5 Flex: 4.69.55
-
- New here
- Posts: 5
- Joined: Thu Nov 19, 2015 12:32 pm
Re: #2002 Cannot log in to the MySQL server
wow, thanks so much .... will try that asap and get back to you.Toxic17 wrote:uninstall the phpmyadmin you have installed from app center.
then try this one.
http://qnap.community/viewtopic.php?f=42&t=12
you need to install GIT 2.1.0 first however.
http://forum.qnap.com/viewtopic.php?f=301&t=97220
-
- Know my way around
- Posts: 141
- Joined: Thu Aug 28, 2008 8:20 am
- Location: Southern California
Re: #2002 Cannot log in to the MySQL server
In case anyone else finds this topic, don't bother, the requested URL /viewtopic.php was not found on this server.Toxic17 wrote:uninstall the phpmyadmin you have installed from app center.
then try this one.
http://qnap.community/viewtopic.php?f=42&t=12
you need to install GIT 2.1.0 first however.
http://forum.qnap.com/viewtopic.php?f=301&t=97220
TS-453 Pro
Firmware 4.2.1
Firmware 4.2.1
-
- First post
- Posts: 1
- Joined: Sun Jun 20, 2021 9:22 am
Re: #2002 Cannot log in to the MySQL server
I had the same problem managed to solved it.
I am running on a QNAP TS-220 running on firmware version 4.3.3.1677 Build 20210608
Fixed it out of trial and error. So I am no means an expert on the subject.
After creating the
Control Panel > Applications > SQL Server
Check Enable SQL Server (it was unchecked by default)
Click the Apply Button
After enabling SQL Server this solved my problem of login to phpMyAdmin with the username:root and the password: admin
I am running on a QNAP TS-220 running on firmware version 4.3.3.1677 Build 20210608
Fixed it out of trial and error. So I am no means an expert on the subject.
After creating the
Control Panel > Applications > SQL Server
Check Enable SQL Server (it was unchecked by default)
Click the Apply Button
After enabling SQL Server this solved my problem of login to phpMyAdmin with the username:root and the password: admin
- OneCD
- Guru
- Posts: 12146
- Joined: Sun Aug 21, 2016 10:48 am
- Location: "... there, behind that sofa!"