понедельник, 1 октября 2018 г.

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

пятница, 21 сентября 2018 г.

Diff for binary files

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

среда, 19 сентября 2018 г.

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

среда, 22 августа 2018 г.

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');

среда, 16 мая 2018 г.

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 -

понедельник, 22 января 2018 г.

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

пятница, 19 января 2018 г.

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"
     }
}

среда, 17 января 2018 г.

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

понедельник, 15 января 2018 г.

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

пятница, 12 января 2018 г.

Ubuntu iso and UEFI usb stick

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