[SOLVED] Access Denied phpMyAdmin
-
- Posts: 4
- Joined: Fri May 26, 2017 2:25 pm
[SOLVED] Access Denied phpMyAdmin
Ubuntu 16.04 at Digital Ocrean
Latest VestaCP
https://new.siteviewer.us/phpmyadmin/
Try to log in with username and password after creating database in vesta.
[/b]
This also happens when i create new users as well.
This is a new vesta installation and the only things i've done are.
Installed configured and activated vesta-lets-encrypt
Latest VestaCP
https://new.siteviewer.us/phpmyadmin/
Try to log in with username and password after creating database in vesta.
Code: Select all
#1045 - Access denied for user 'testu'@'localhost' (using password: YES)
This also happens when i create new users as well.
This is a new vesta installation and the only things i've done are.
Code: Select all
# Running fixes for phpmyadmin
curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma.sh && chmod +x pma.sh && ./pma.sh
Last edited by limitunknown.com on Sun May 28, 2017 12:42 am, edited 1 time in total.
-
- Posts: 4
- Joined: Fri May 26, 2017 2:25 pm
Re: Access Denied phpMyAdmin
I'm not sure exactly what it was but i found two things.
I have a installer script for ubuntu that sets up my preferred configurations.
I started from scratch installing vesta first and ran that after installing vesta.
Also the password for the user i was creating had a single quote in it.
Apparently when creating passwords that have single quotes, they aren't escaped.
Doubling single quotes allows you to escape and use them.
would let you log in with
I have a installer script for ubuntu that sets up my preferred configurations.
I started from scratch installing vesta first and ran that after installing vesta.
Also the password for the user i was creating had a single quote
Code: Select all
'
Apparently when creating passwords that have single quotes, they aren't escaped.
Doubling single quotes allows you to escape and use them.
Code: Select all
my''pass_109
Code: Select all
my'pass_109
Re: [SOLVED] Access Denied phpMyAdmin
I solved it in this simple way
***** restore user root mysql *****
mysql -u root -p mysql
MariaDB [mysql]> update user set plugin='' where user='root';
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> exit
***********************************
to disable user root again ....
update user set plugin='unix_socket' where user='root';
***** restore user root mysql *****
mysql -u root -p mysql
MariaDB [mysql]> update user set plugin='' where user='root';
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> exit
***********************************
to disable user root again ....
update user set plugin='unix_socket' where user='root';