[SOLVED] How to change MySQL root password

[openyk]

Worked for me on Ubuntu 14.04 x64:

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

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"

[canoodle]

Hi,

it's good to know that the mysql-root password is located in:

Code: Select all

/usr/local/vesta/conf/mysql.conf

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

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'

why this message?

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

won't ask me for a password?

changing root pwd: this is the way it works: http://www.rackspace.com/knowledge_cent ... t-password

[skurudo]

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

Use modest my.cnf configuration for low memory server and happyness be with you.
If you use default my.cnf, happyless be with you and it's sad ;-)

Code: Select all

# mysql -u root

won't ask me for a password?

You have password here - /root/.my.cnf

[waleeed]

try to detect what is causing mysql to crash frequently... like every 2 days.

[skurudo]

try to detect what is causing mysql to crash frequently... like every 2 days.

In many cases helped this - my.cnf config tuning.
How much CPU/RAM on your server?