Phpmyadmin not present in new vps version

Bare Metal and VPS
1

New vps version (prestashop), have Centos.
Phpmyadmin and mysql root password is present.
How to manage database?

2

Ok, phpMyAdmin is not installed.
About mysql root password?

3

No root password created.
We can access as root directy with command:
mysql -u root

4

becasue remote access for root is disabled and allowed just locally. you can fix this empty password by this below method.

update mysql.user set authentication_string=password(''), plugin='mysql_native_password' where user='root';
flush privileges;

5

you can fix this empty password by this below method.

update mysql.user set authentication_string=password(’’), plugin=‘m


yes, sure. Thanks
6

glad to help and your welcome.