Wednesday, November 25, 2015

How to change root PASSWORD in MySQL in terminal

                                                                   1

                                                                   
 
  service mysql stop
  service mysql status
  mysqld_safe --skip-grant-tables &
  mysql -u root

mysql> SHOW DATABASES;
mysql> use mysql;
mysql> update user set password=PASSWORD("yourverystrongpassword") where user='root';
mysql> flush privileges;

 service mysql restart
 service mysql status
 mysql -u root -p

wordpress problem with plugin updates

                                                           changing permissions will solve the problem                                    ...