Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section General Discussion
  • Search

#2002 Cannot log in to the MySQL server

General questions about VestaCP
Post Reply
  • Print view
Advanced search
8 posts • Page 1 of 1
mcam435
Posts: 1
Joined: Tue Oct 28, 2014 4:48 pm

#2002 Cannot log in to the MySQL server
  • Quote

Post by mcam435 » Tue Oct 28, 2014 4:52 pm

Hi,

I have spent hours on this now and have trawled this forum and pages and pages of search results on google.

I have done an install of VestaCP on a clean Ubuntu 14.04 build.

The install seems to go smoothly, however roundcube does not work. I was trying to go through the steps of creating the database however I cannot get into phpmyadmin as I get the below error:

"#2002 Cannot log in to the MySQL server"

I have tried everything I can find on this forum. Could someone please help. Getting kinda desperate and about to move back to ISPConfig...

Thank you.
Top

melkerman
Posts: 8
Joined: Wed Apr 02, 2014 10:52 am

Re: #2002 Cannot log in to the MySQL server
  • Quote

Post by melkerman » Wed Oct 29, 2014 10:04 am

Did you install vestacp as root?

I had the same problem when i created a new user, stopped root ssh access and installed vesta with the new user. I got #2002 Cannot log in to the MySQL server and backups didn't work.

I made a new clean Ubuntu 14.04 build, no new user only root and installed vesta. And vesta worked like a charm.
Top

robotini
Posts: 14
Joined: Wed Dec 04, 2013 10:01 am

Re: #2002 Cannot log in to the MySQL server
  • Quote

Post by robotini » Sat Jan 03, 2015 10:51 pm

Same problem, any solution? I changed the root password from /usr/local/vesta/conf/mysql.conf but this dont work
Top

joem
Posts: 378
Joined: Thu Nov 13, 2014 8:33 am

Os: CentOS 6x
Web: nginx + php-fpm
Re: #2002 Cannot log in to the MySQL server
  • Quote

Post by joem » Sun Jan 04, 2015 12:16 am

robotini wrote:Same problem, any solution? I changed the root password from /usr/local/vesta/conf/mysql.conf but this dont work

viewtopic.php?f=14&t=6705#p19902
Top

robotini
Posts: 14
Joined: Wed Dec 04, 2013 10:01 am

Re: #2002 Cannot log in to the MySQL server
  • Quote

Post by robotini » Sun Jan 04, 2015 12:56 am

joem wrote:
robotini wrote:Same problem, any solution? I changed the root password from /usr/local/vesta/conf/mysql.conf but this dont work

viewtopic.php?f=14&t=6705#p19902
Don't work...

#2002 Cannot log in to the MySQL server

Edit: this solved if I turn off and turn on again the service mysql on Vesta, but when I make a reboot to my server in few seconds I get that error
Top

joem
Posts: 378
Joined: Thu Nov 13, 2014 8:33 am

Os: CentOS 6x
Web: nginx + php-fpm
Re: #2002 Cannot log in to the MySQL server
  • Quote

Post by joem » Sun Jan 04, 2015 1:28 am

robotini wrote:
joem wrote:
robotini wrote:Same problem, any solution? I changed the root password from /usr/local/vesta/conf/mysql.conf but this dont work

viewtopic.php?f=14&t=6705#p19902
Don't work...

#2002 Cannot log in to the MySQL server

Edit: this solved if I turn off and turn on again the service mysql on Vesta, but when I make a reboot to my server in few seconds I get that error
Are you sure MySQL is still running? Sometimes you'll get error #2002 when the MySQL service has crashed.
Top

robotini
Posts: 14
Joined: Wed Dec 04, 2013 10:01 am

Re: #2002 Cannot log in to the MySQL server
  • Quote

Post by robotini » Sun Jan 04, 2015 2:14 am

joem wrote:Are you sure MySQL is still running? Sometimes you'll get error #2002 when the MySQL service has crashed.
I just reinstall my server to Ubuntu 12.04, set a backup from my old server and now this is fine, I don't know if mysql crashed, now I have this problem:

viewtopic.php?f=10&t=6601
Top

vestacp89
Posts: 83
Joined: Thu Aug 14, 2014 11:04 am

Re: #2002 Cannot log in to the MySQL server
  • Quote

Post by vestacp89 » Sun Jan 04, 2015 10:16 am

robotini wrote:
joem wrote:Are you sure MySQL is still running? Sometimes you'll get error #2002 when the MySQL service has crashed.
I just reinstall my server to Ubuntu 12.04, set a backup from my old server and now this is fine, I don't know if mysql crashed, now I have this problem:

viewtopic.php?f=10&t=6601
I have same problem, mysql crashed, i fix this with restart mysql, but this is not solution this will happend again i here paste problem before 2 month nobody not care
Top


Post Reply
  • Print view

8 posts • Page 1 of 1

Return to “General Discussion”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password