Vesta Control Panel - Forum

I dont have /root/.my.cnf This file appear when you log to mysql console and you access to this console without password. You can create file yourself: [client] password='your-root-mysql-password' THank you. I solved this problem by manually changing the root password under phpmyadmin UI then I put...

skurudo wrote:

pandabb wrote: What else can i do to fix this problem?

Like this for example:
https://wiki.archlinux.org/index.php/Ph ... passphrase

The VestaCP PhpMyAdmin doesn't include the file config.inc.php. Even the sample file does not exist. How do I create one?

imperio wrote:Hi, you can find mysql root password in this files
/usr/local/vesta/conf/mysql.conf

Code: Select all

USER='root' PASSWORD=''

or

Code: Select all

/root/.my.cnf

passwords for root vps and root mysql is different

I dont have /root/.my.cnf

Why VestaCP keep this password there? So, how do I change the root password that can be seen at /usr/local/vesta/conf/mysql.conf ?

Do I just need to edit the password in there?

I solved this problem without chmod the sesion folder to 777. Please correct me if I'm wrong here: I think during installation of VestaCP, some of the configuration files were set to belong to admin owner. So, I changed the session folder to owner 'admin' and it works. This method works for the blow...