#2002 Cannot log in to the MySQL server

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Locked
olalere
New here
Posts: 5
Joined: Thu Nov 19, 2015 12:32 pm

#2002 Cannot log in to the MySQL server

Post by olalere »

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.
User avatar
Toxic17
Ask me anything
Posts: 6469
Joined: Tue Jan 25, 2011 11:41 pm
Location: Planet Earth
Contact:

Re: #2002 Cannot log in to the MySQL server

Post by Toxic17 »

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.
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
olalere
New here
Posts: 5
Joined: Thu Nov 19, 2015 12:32 pm

Re: #2002 Cannot log in to the MySQL server

Post by olalere »

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.
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.
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
User avatar
schumaku
Guru
Posts: 43579
Joined: Mon Jan 21, 2008 4:41 pm
Location: Kloten (Zurich), Switzerland -- Skype: schumaku
Contact:

Re: #2002 Cannot log in to the MySQL server

Post by schumaku »

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 ...
olalere
New here
Posts: 5
Joined: Thu Nov 19, 2015 12:32 pm

Re: #2002 Cannot log in to the MySQL server

Post by olalere »

schumaku 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 ...
Thanks, but I already did that
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;
olalere
New here
Posts: 5
Joined: Thu Nov 19, 2015 12:32 pm

Re: #2002 Cannot log in to the MySQL server

Post by olalere »

schumaku 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 ...
This is a piece of my SQL settings
You do not have the required permissions to view the files attached to this post.
User avatar
Toxic17
Ask me anything
Posts: 6469
Joined: Tue Jan 25, 2011 11:41 pm
Location: Planet Earth
Contact:

Re: #2002 Cannot log in to the MySQL server

Post by Toxic17 »

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
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
olalere
New here
Posts: 5
Joined: Thu Nov 19, 2015 12:32 pm

Re: #2002 Cannot log in to the MySQL server

Post by olalere »

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
wow, thanks so much .... will try that asap and get back to you.
ddkirk
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

Post by ddkirk »

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
In case anyone else finds this topic, don't bother, the requested URL /viewtopic.php was not found on this server.
TS-453 Pro
Firmware 4.2.1
venice
First post
Posts: 1
Joined: Sun Jun 20, 2021 9:22 am

Re: #2002 Cannot log in to the MySQL server

Post by venice »

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
User avatar
OneCD
Guru
Posts: 12037
Joined: Sun Aug 21, 2016 10:48 am
Location: "... there, behind that sofa!"

Re: #2002 Cannot log in to the MySQL server

Post by OneCD »

* topic locked to prevent further necroposting *

ImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImageImage
Locked

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