How to change root password in phpmyadmin on ubuntu?

Question

linux

How to change root password in phpmyadmin to ubuntu via terminal?

Answer 1

if there was no password before
mysqladmin -u root password '1234'
if there was a password.
Stop MySQL:
/etc/init.d/mysql stop Start
in unchecked mode:
/usr/sbin/mysqld --skip-grant-tables &
Connect as root without password:
mysql
Select active database:
use mysql;
Update the password:
mysql> update user set Password=PASSWORD('new password') WHERE User='root';
mysql> flush privileges;
Shut down mysqld:
fg
"Ctrl+c"
Start MySQL in normal mode.
/etc/init.d/mysql start
INFA
there is a lot to learn here!