can’t login as mysql user root from normal user account in ubuntu 16.04

1 – First, connect in sudo mysql

sudo mysql -u root

2 – Check your accounts present in your db

SELECT User,Host FROM mysql.user;
+------------------+-----------+
| User             | Host      |
+------------------+-----------+
| admin            | localhost |
| debian-sys-maint | localhost |
| magento_user     | localhost |
| mysql.sys        | localhost |
| root             | localhost |

3 – Delete current root@localhost account

mysql> DROP USER 'root'@'localhost';
Query OK, 0 rows affected (0,00 sec)

4 – Recreate your user

mysql> CREATE USER 'root'@'%' IDENTIFIED BY '';
Query OK, 0 rows affected (0,00 sec)

5 – Give permissions to your user (don’t forget to flush privileges)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0,00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0,01 sec)

6 – Exit mysql and try to reconnect without sudo

Advertisements

How to move window between workspaces in ubuntu

To move window between workspaces in Ubuntu.

Select window you want to move. Press Ctrl + Shift + Alt +  (arrow)

To go around workspaces. Press Ctrl + Alt + (arrow)

To put window between screen

sudo apt-get install compizconfig-settings-manager
sudo apt-get install compiz-plugins

Open CompizConfig Settings Manager > Window Management > Put > Enabel Put and set keywords to put to next output