Can't connect to MySQL localhost (how to)

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Posts: 6
Joined: Fri Nov 25, 2016 12:08 pm

Can't connect to MySQL localhost (how to)

Postby Aldoseri » Sat Dec 10, 2016 11:07 pm

Hi guys,

I thought this might help someone.

If you get this message from VestaCP ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Then this means your root password for MySQL has changed for example after installing MariaDB. like in my case where I used a password different from when I first Installed VestaCP.

Steps to fix the problem.

1- Login to your server using FTP
2- Update your password in the following files.


You don't need to restart your server or MySQL service.

If you don't know your root password or would like to change it then continue to step 3

3- Follow the instructions below:

login as root using terminal ( I use Mac, maybe you have something else )

~# /etc/init.d/mysqld stop
~# mysqld_safe –skip-grant-tables &
~# mysql -u root
~# mysql> use mysql;
~# mysql> update user set password=PASSWORD(“Your-new-password-here”) where User=’root’;
~# mysql> flush privileges;
~# mysql> quit
~# /etc/init.d/mysqld stop
~# /etc/init.d/mysqld start

Now it should work


VestaCP Team
Posts: 7676
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow

Re: Can't connect to MySQL localhost (how to)

Postby skurudo » Mon Feb 27, 2017 9:34 pm

Nice one! Thanks.

PS: Topic it's sticky now.
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

Return to “Database Server”

Who is online

Users browsing this forum: No registered users and 5 guests