Praleisti ir pereiti prie pagrindinio turinio

Pranešimai

MySQL password resset (Ubuntu server 18.04)

1. Stop MySQL: $ sudo service mysql stop  2. Make MySQL service directory:  $ sudo mkdir /var/run/mysqld  3. Give MySQL user permission to write to the service directory:  $ sudo chown mysql: /var/run/mysqld  4. Start MySQL manually, without permission checks or networking:  $ sudo mysqld_safe --skip-grant-tables --skip-networking &  5.  Log in without a password.  $ mysql -u root mysql  6. Update the password for the root user.
 mysql> UPDATE mysql.user SET authentication_string=PASSWORD('YOURNEWPASSWORD') WHERE User='root';
 mysql> EXIT; 
7. Turn off MySQL:  $ sudo service mysql restart
Naujausi įrašai

Enable remote connection to MySQL server (Ubuntu server 18.04)

1. Edit mysql config file:
 $ sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf 

comment out following lines:
#bind-address = 127.0.0.1
#skip-networking 
2. Restart mysql server  $ sudo service mysql restart 
3. Log to mysql and change grand privileges (replace USERNAME and PASSWORD by you credentials):  mysql -u USERNAME -p   mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION; 
 mysql > FLUSH PRIVILEGES; 
4. Now you try connect remotely (replace HOSTNAME to server hostname or ip adress):  $ mysql -u root -p -h HOSTNAME

PHPMyAdmin install/upgrade in Ubuntu 18.04

Install PHPMyAdmin in Ubuntu 18.04 1. Install phpmyadmin from source $ sudo apt install phpmyadmin
2. Creating Password Access for the MySQL Root Account $ sudo mysql
$ mysql > SELECT user,authentication_string,plugin,host FROM mysql.user;
RESULT: +------------------+-------------------------------------------+-----------------------+-----------+ | user | authentication_string | plugin | host | +------------------+-------------------------------------------+-----------------------+-----------+ | root | | auth_socket | localhost | | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | debian-sys-maint | *8486437DE5F65ADC4A4B001CA591363B64746D4C | mysql_native_password | localhost | | phpmyadmin | *5FD2B7524254B7F81B3…

FreeCAD crach on start up

1. Go to /home/.local/share/applications and open your FreeCAD starter with an Editor
2. Change 'Exec' line to Exec=sh -c "LIBGL_DRI3_DISABLE=true freecad" --single-instance %U

OR

Run from terminal => LIBGL_DRI3_DISABLE=true freecad

AEON wallet install

1. On Debian/Ubuntu libgtest-dev only includes sources and headers. You must build the library binary manually.  $ sudo apt-get install libgtest-dev 
 $ cd /usr/src/gtest   $ sudo cmake .   $ sudo make   $ sudo mv libg* /usr/lib/ 
2. Install necessary dependencies: $ sudo apt update && sudo apt install build-essential cmake git libpcsclite-dev pkg-config libboost-all-dev libssl-dev libzmq3-dev libunbound-dev libsodium-dev libminiupnpc-dev libunwind8-dev liblzma-dev libreadline6-dev libldns-dev libexpat1-dev doxygen graphviz libpcsclite-dev 
3. Clone recursively to pull-in needed sub-module:
$ git clone --recursive https://github.com/aeonix/aeon
4. Build: $ cd aeon   $ make 
P.S. on Linux Mint 19 getting error in 40% :
In function ‘bool cryptonote::construct_miner_tx(size_t, size_t, uint64_t, size_t, uint64_t, const cryptonote::account_public_address&, cryptonote::transaction&, const blobdata&, size_t, uint8_t)’:
cc1plus: error: ‘void* __builtin_memset(void*, int, long u…

Automatinis disko prijungimas (automount) linux aplinkoje

1. Sukuriame direktoriją prie kurios bus prijungtas diskas:
mkdir /media/hdd

1. Sukuriame fstab failo atsargine kopija:
sudo cp /etc/fstab /etc/fstab.old

2. Surandam disko UUID kuri norime automatiškai prijungti:
sudo blkid
3. Sukuriame fstab faile disko prijungimo taisyklę:sudo nano /etc/fstab
UUID=<uuid> <direktorija> <failusistema> defaults 0 0 P.S. galima naudoti sekančią komandą, kad sužinoti disko pavadinimą, failų sistemos tipą ir UUID: lsblk -o NAME,FSTYPE,UUID
Po kompiuterio perkrovimo, jei fstab faile nepadarėte klaidų nurodytoje prijungimo direktorijoje matysite prijungto disko turini.