We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
[SOLVED] How to change MySQL root password
[SOLVED] How to change MySQL root password
Worked for me on Ubuntu 14.04 x64:
Also update the vestacp configuration file so that the backup process can access your database with the new password:
change the file mysql.conf located in "/usr/local/vesta/conf"
Code: Select all
# (Log onto or SSH access into your server's command line)
# Log into database (replace your_host with your selected host name you made during vestacp install)
mysql -h your_host -u root
# Change password for root user (replace yourpassword with your desired password, make sure to keep the quotes in though)
SET PASSWORD FOR root@localhost = PASSWORD('yourpassword');
# You are now able to log into phpmyadmin with user : root and password: yourpassword
change the file mysql.conf located in "/usr/local/vesta/conf"
Re: [SOLVED] How to change MySQL root password
Hi,
it's good to know that the mysql-root password is located in:
i try to detect what is causing mysql to crash frequently... like every 2 days.
server is vps@hetzner with 512MB of RAM running Linux 3.2.0-4-686-pae #1 SMP Debian 3.2.68-1+deb7u1 i686 GNU/Linux
why this message?
both commands seem to be wrong and fail btw :-D
is there no root password set?
it's interesting that
won't ask me for a password?
changing root pwd: this is the way it works: http://www.rackspace.com/knowledge_cent ... t-password
it's good to know that the mysql-root password is located in:
Code: Select all
/usr/local/vesta/conf/mysql.conf
server is vps@hetzner with 512MB of RAM running Linux 3.2.0-4-686-pae #1 SMP Debian 3.2.68-1+deb7u1 i686 GNU/Linux
Code: Select all
vim /var/log/syslog
May 28 10:17:11 dwaves mysqld_safe[3623]: /usr/bin/mysqladmin -u root password 'new-password'
May 28 10:17:11 dwaves mysqld_safe[3623]: /usr/bin/mysqladmin -u root -h password 'new-password'
both commands seem to be wrong and fail btw :-D
is there no root password set?
it's interesting that
Code: Select all
# mysql -u root
changing root pwd: this is the way it works: http://www.rackspace.com/knowledge_cent ... t-password
Re: [SOLVED] How to change MySQL root password
Use modest my.cnf configuration for low memory server and happyness be with you.canoodle wrote: try to detect what is causing mysql to crash frequently... like every 2 days.
server is vps@hetzner with 512MB of RAM running Linux 3.2.0-4-686-pae #1 SMP Debian 3.2.68-1+deb7u1 i686 GNU/Linux
If you use default my.cnf, happyless be with you and it's sad ;-)
You have password here - /root/.my.cnfcanoodle wrote:won't ask me for a password?Code: Select all
# mysql -u root
Re: [SOLVED] How to change MySQL root password
try to detect what is causing mysql to crash frequently... like every 2 days.
Last edited by skurudo on Tue Feb 16, 2016 7:04 pm, edited 2 times in total.
Reason: links
Reason: links
Re: [SOLVED] How to change MySQL root password
In many cases helped this - my.cnf config tuning.waleeed wrote:try to detect what is causing mysql to crash frequently... like every 2 days.
How much CPU/RAM on your server?