mysql (maria-db) passwd change

**fulltilt** · Dec 28th 2016

IMSCP 1.3.8
Debian 8.6
10.0.28-MariaDB

MySql Password change (10.0.28-MariaDB)
is there is a special approach and are there updated instructions for that?

Code

perl imscp-autoinstall -dr sql

Regards

**Nuxwin** · Dec 28th 2016

Which SQL user password exactly?

**fulltilt** · Dec 28th 2016

Hello Nuxwin,
I need to change the root passwd of maiadb and IMSCP 1.3.8 because of security reasons ...

can I still use this?

Code

perl imscp-autoinstall -dr sql

**fulltilt** · Dec 28th 2016

Today my jacket was stolen incl a USB stick w/ the server passwords ...
I have already changed all the other passwords, I do not want to damage anything here w/ mysql root pw changing
so it's really urgent
Thank you for a quick response

**Nuxwin** · Dec 28th 2016

Re,

SQL

# mysql -u root -p'<current_pwd>'> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpass');> SET PASSWORD FOR 'root'@'::1' = PASSWORD('newpass');>\q

Shell-Script

# cd <imscp-1.3.8-archive-directory>
# perl imscp-autoinstall -dasr sql

**fulltilt** · Dec 28th 2016

what a day, incredible ...
all done!
thanks Nuxwin

mysql (maria-db) passwd change

Share

Daily visitors