Phpmyadmin not present in new vps version

[TonzaniE]

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

[TonzaniE]

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

[TonzaniE]

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

[didarali]

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;

[TonzaniE]

you can fix this empty password by this below method.

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

yes, sure. Thanks

[didarali]

glad to help and your welcome.