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

Install unikey on ubuntu

sudo apt-get install ibus-unikey

ibus restart or ibus-daemon & ibus restart

Text Entry settings > Add new language

Super + Space -> to  change language

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