Mysql 5.7 root empty password and Ubuntu

sudo mysql -u root

mysql> use mysql;

mysql> update user set plugin='mysql_native_password' where User='root';

mysql> set password = password('_new_root_password_');

[mysql] flush privileges;

check:

mysql -u root -p
enter new root password

Diff for binary files

diff -y <(xxd foo1.bin) <(xxd foo2.bin) | colordiff

Viber and Ubuntu 18.04

Download Viber
sudo dpkg -i viber.deb
sudo aptitude install -f
sudo aptitude install libqt5gui5

1. After executing command
sudo dpkg -i viber.deb

....
dpkg: dependency problems prevent configuration of viber:
 viber depends on libcurl3; however:
  Package libcurl3 is not installed.
 viber depends on gstreamer1.0-pulseaudio; however:
  Package gstreamer1.0-pulseaudio is not installed.
....

2. So now we have to fix dependencies
sudo aptitude install -f

Try to start Viber

/opt/viber/Viber

This application failed to start because it could not find or load the Qt platform plugin "xcb"
in "".
Available platform plugins are: eglfs, linuxfb, minimal, minimalegl, offscreen, vnc, wayland-egl, wayland, wayland-xcomposite-egl, wayland-xcomposite-glx, xcb.
Reinstalling the application may fix this problem.
Aborted

3. Install Qt5
sudo aptitude install libqt5gui5

Recreate mysql data dir

Recreate mysql data dir (without backup)


systemctl stop mysql

(rm -r /var/lib/mysql)
mkdir /var/lib/mysql
chown mysql. /var/lib/mysql

mysqld --initialize

You can find password for root in /var/log/mysql/error.log
~A temporary password is generated for root@localhost: xxxxxxxx~

mysql -u root -p

systemctl start mysql

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

XML pretty command line output

XML pretty command line output

sudo apt install libxml2-utils

and use " | xmllint --format - "

for example
echo '<root><test a="b">value</test><check value="new" /></root>' |  xmllint --format -

Mysql copy database

sudo apt-get install mysql-utilities

mysqldbcopy \
    --source=root:your_password@localhost \
    --destination=root:your_password@localhost \
    sitedb1:sitedb2

or

mysqldump db_name | mysql new_db_name

Lubuntu Shift + NumPad work like Windows

Set "Keyboard Layout Handler" (in tray) - "Advanced setxkbmap Options" - value = numpad:microsoft

and right click icon for saving.

or

change this option in file ~/.config/lxpanel/Lubuntu/panels/panel

Plugin {
     type=xkb
     Config {
     ......
         AdvancedOpt="numpad:microsoft"
     }
}

Mysql and new location for data with Errcode: 13 - Permission denied

For new instance data dir:

mysqld --initialize

mysqld: Can't create directory '/xxxx/mysql/' (Errcode: 13 - Permission denied)

add to file /etc/apparmor.d/ usr.sbin.mysqld new location

# Allow data dir access
  /var/lib/mysql/ r,
  /var/lib/mysql/** rwk,
 /xxxx/mysql/ r,  /xxxx/mysq/** rwk,

and reload apparmor

service apparmor reload

other way

apt install appamor-utils
aa-disable /usr/sbin/mysqld

Disabling /usr/sbin/mysqld.

mysqld --initialize

You can find password for root in /var/log/mysql/error.log

A temporary password is generated for root@localhost: xxxxxxxx

Lubuntu 16.04 repeat key functionality doesn't work

Fix for notebook Lenovo Ideapad 700-15ISK

sudo su
echo "blacklist peaq_wmi" >> /etc/modprobe.d/50-blacklist.conf

Ubuntu iso and UEFI usb stick

Get etcher app from https://etcher.io and write Ubuntu iso.