Android Smartphone as PC monitor

This URL is some guides for it.

techwiser.com

The following software is awsome

https://spacedesk.net/

Reset MySQL Root Password

-----

Basic step to reset mysqld password just follow these instructions :

• Stop the mysql demon process

  •    sudo /etc/init.d/mysql stop

• Start the mysqld demon process using the --skip-grant-tables option

  •    sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

    or

       sudo mysqld_safe --skip-grant-tables &
     

• start the mysql client process using this command

  •    mysql -u root

• from the mysql prompt execute this command to be able to change any password

  •    FLUSH PRIVILEGES;

• Then reset/update your password

  •    SET PASSWORD FOR root@'localhost' = PASSWORD('password');

• If you have a mysql root account that can connect from everywhere, you should also do:

  •    UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';

• Alternate Method:

  •    USE mysql
       UPDATE user SET Password = PASSWORD('newpwd')
       WHERE Host = 'localhost' AND User = 'root';

• And if you have a root account that can access from everywhere:

  •    USE mysql
       UPDATE user SET Password = PASSWORD('newpwd')
       WHERE Host = '%' AND User = 'root';

For either method, once have received a message indicating a successful query (one or more rows affected), flush privileges:

   FLUSH PRIVILEGES;

Then stop the mysqld process and relaunch it

   sudo /etc/init.d/mysql stop
   sudo /etc/init.d/mysql start

-- Alternative method for different source

1. Run bash commands

# 1. first, run these bash commands
sudo /etc/init.d/mysql stop # stop mysql service
sudo mysqld_safe --skip-grant-tables & # start mysql without password
# enter -> go
mysql -uroot # connect to mysql

2. Run mysql commands

use mysql; # use mysql table
update user set authentication_string=PASSWORD("") where User='root'; # update password to nothing
update user set plugin="mysql_native_password" where User='root'; # set password resolving to default mechanism for root user

flush privileges;
quit;

3. Run more bash commands

sudo /etc/init.d/mysql stop 
sudo /etc/init.d/mysql start # reset mysql 
mysql -u root -p root # try login to database

-- If you find following error

2017-02-10T17:05:44.870970Z mysqld_safe Logging to '/var/log/mysql/error.log'.

2017-02-10T17:05:44.872874Z mysqld_safe Logging to '/var/log/mysql/error.log'.
2017-02-10T17:05:44.874547Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists. 

Do this 

$ mkdir -p /var/run/mysqld

$ chown mysql:mysql /var/run/mysqld

To reset 
Mysqld_safe 
Solving Error 
 

Setup PHP on Ubuntu

Please check these links

LAMP
LAMP how to

To install PHP 7 on Ubuntu 
sudo apt-get -y update
sudo add-apt-repository ppa:ondrej/php
sudo apt-get -y update
sudo apt-get install -y php7.0 libapache2-mod-php7.0 php7.0 php7.0-common php7.0-gd php7.0-mysql php7.0-mcrypt php7.0-curl php7.0-intl php7.0-xsl php7.0-mbstring php7.0-zip php7.0-bcmath php7.0-iconv php7.0-soap 

 
PHP install guide

to Upgrade to PHP7
PHP7

 If an "PHP ERROR: Module php7.0 does not exist" occur

PHP ERROR

to install PHPmyAdmin

sudo apt-get install phpmyadmin
phpMyAdmin

FSTAB and MTAB

Sumber:
brunolinux
tuxfiles

Equalizer di Amarok

1. Download package http://ftp.br.freesbie.org/mirror/biglinux/packages/karmic/main/phonon-backend-xine_4:4.3.4~svn1037991~karmic~ppa2_i386.deb

2. Instal Packege

3 Buat file preference

Package: phonon-backend-xine
Pin: version 4.3.1~svn1037991*
Pin-Priority: 1001

3. update

4. selesai

sumber
kubuntuforums

Joomla Installation Blank Page

php -m

list modules
No SimpleXML

sudo apt-get install php7.0-simplexml

php -m

Will show
SimpleXML

Restart apache2

Joomla should start

source

Ubuntu find Duplicated Files

Try this

find -name "*.pdf" -printf "%10s\t%p\n" | sort --numeric | uniq --repeated --check-chars=10

or
Search similar filesize:

find -name "*" -printf "%sc %p\n" | sort --numeric | uniq --repeated --check-chars=10 | cut -d' ' -f1 | grep -v '0c' >a; for i in `cat a`; do echo $i; find -size $i; echo; done

to ignore the file type

for i in `cat a| uniq| sort -nr`; do echo $i; find -size $i | xargs -I{} echo \"{}\"| xargs md5sum 2>/dev/null; done

below code is the wrap up

find -name "*" -printf "%sc %p\n" |sort --numeric | uniq --repeated --check-chars=10 | cut -d' ' -f1 | grep -v '0c'> a
rm b.txt
for i in `cat a| uniq| sort -nr`; do echo $i; find -size $i| xargs -I{} echo \"{}\"| xargs md5sum >>b.txt 2>/dev/null; done
cat b.txt |sort --numeric | uniq --repeated --check-chars=10 > c.txt
cat c.txt | cut -d'*' -f1 >d
rm e
for i in `cat d`; do grep $i b.txt >> e;done

Ubuntu Install boot-repair

sudo add-apt-repository ppa:yannubuntu/boot-repair
sudo apt-get update
sudo apt-get install -y boot-repair && boot-repair

source

Ubuntu Cannot Enable WiFi

sudo modprobe -r acer_wmi

Source:
askubuntu.com 

Update grub on a dual boot machine

sudo nano /etc/default/grub 

sudo update-grub

source  

Install Wordpress on Ubuntu

Installation

To install WordPress, run the following comand in the command prompt:

    sudo apt install wordpress

You should also install apache2 web server and mysql server. For installing apache2 web server, please refer to Installation sub-section in HTTPD - Apache2 Web Server section. For installing mysql server, please refer to Installation sub-section in MySQL section.

Configuration

For configuring your first WordPress application, configure an apache site. Open /etc/apache2/sites-available/wordpress.conf and write the following lines:

        Alias /blog /usr/share/wordpress
        
            Options FollowSymLinks
            AllowOverride Limit Options FileInfo
            DirectoryIndex index.php
            Order allow,deny
            Allow from all
        
        
            Options FollowSymLinks
            Order allow,deny
            Allow from all
        
           

Enable this new WordPress site

    sudo a2ensite wordpress

Once you configure the apache2 web server and make it ready for your WordPress application, you should restart it. You can run the following command to restart the apache2 web server:

sudo systemctl restart apache2.service

To facilitate multiple WordPress installations, the name of this configuration file is based on the Host header of the HTTP request. This means that you can have a configuration per VirtualHost by simply matching the hostname portion of this configuration with your Apache Virtual Host. e.g. /etc/wordpress/config-10.211.55.50.php, /etc/wordpress/config-hostalias1.php, etc. These instructions assume you can access Apache via the localhost hostname (perhaps by using an ssh tunnel) if not, replace /etc/wordpress/config-localhost.php with /etc/wordpress/config-NAME_OF_YOUR_VIRTUAL_HOST.php.

Once the configuration file is written, it is up to you to choose a convention for username and password to mysql for each WordPress database instance. This documentation shows only one, localhost, example.

Now configure WordPress to use a mysql database. Open /etc/wordpress/config-localhost.php file and write the following lines:

Now create this mysql database. Open a temporary file with mysql commands wordpress.sql and write the following lines:

CREATE DATABASE wordpress;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON wordpress.*
TO wordpress@localhost
IDENTIFIED BY 'yourpasswordhere';
FLUSH PRIVILEGES;

Execute these commands.

cat wordpress.sql | sudo mysql --defaults-extra-file=/etc/mysql/debian.cnf

Your new WordPress can now be configured by visiting http://localhost/blog/wp-admin/install.php. (Or http://NAME_OF_YOUR_VIRTUAL_HOST/blog/wp-admin/install.php if your server has no GUI and you are completing WordPress configuration via a web browser running on another computer.) Fill out the Site Title, username, password, and E-mail and click Install WordPress.

Note the generated password (if applicable) and click the login password. Your WordPress is now ready for use.

https://help.ubuntu.com/lts/serverguide/wordpress.html

Blank screen after entering password on login screen Ubuntu

Right click on your virtue machine -> setting-> hardware -> display and deselect the option "3D acceleration"

source

MAC Address

Unless you have something like Virtualbox installed (which installs its own set of virtual LAN cards), you can try typing getmac at the command prompt. It should provide you your LAN card's MAC address.

If you do have Virtualbox installed, you might consider running getmac /v instead for more verbose output. It will list down the connection name associated with the MAC address.

Ubuntu Trash on NTFS Volume

1. Edit the fstab file

kate /etc/fstab

add uid=1000 in the option part

/dev/sda3       /home/norma/Documents/data        ntfs  defaults,uid=1000    0  0 
/dev/sda2       /home/norma/Documents/refreshing  ntfs  defaults,uid=1000    0  0 


2. Create a .Trash-1000 folder in the NTFS root Volume

Auto-Mount Hard Drives on Ubuntu

use Storage Device Manager

it is available on Ubuntu Software Center

Shell script to remove *~ temporary files

#************************************************#
# clean                                          #
# written by Norma Hermawan                      #
# December 25, 2011                              #
#                                                #
# Clean up temporary files.                      #
#************************************************#

usage()
{
  echo "Usage is: clean [DIR] [OPTIONS]                                            "
  echo "Remove temporary *~ files                                                  "
  echo "                                                                           "
  echo "OPTIONS:                                                                   "
  echo "    --help, -h             Show usage information                          "
  echo "    -r, -R, --recursive    remove temporary *~ files inside the directories recursively"
  echo "                                                                           "
  echo "Examples:                                                                  "
  echo "  clean ../~ -r            remove temporary *~ files inside home folder recursively"
  echo "                                                                           "
  echo "Report cat bugs to norma.hermawan@gmail.com                                "
}                                                                                 

clean-ex()
{
  found=0;
  for found in `cat temp`;
  do
    if [ -f $found ]
    then
      echo "Removed $found"
      rm $found
    fi
  done
 
  if [ $found = 0 ]
  then
    echo "Nothing to clean"
  else
    rm temp
  fi
}
     
# Main Script

  if [ "X$#" = "X0" ]
  then
    ls *~ > temp
    clean-ex
   
  elif [ "X$#" = "X1" ]
  then
    if [ "X$1" = "X-r" ] || [ "X$1" = "X-R" ] || [ "X$1" = "X-recursive" ]
    then
      find -name "*~" > temp
      clean-ex
     
    elif [ "X$1" = "X-h" ] || [ "X$1" = "X--help" ]
    then
      usage
     
    else
      ls $1\/*~ > temp
      clean-ex
     
    fi
     
  elif [ "X$#" = "X2" ]
  then
    if [ "X$2" = "X-r" ] || [ "X$2" = "X-R" ] || [ "X$1" = "X-recursive" ]
    then
      find $1 -name "*~" > temp
      clean-ex
   
    else
      echo "$0: Unknown command line option: '$2'"
    fi
   
  else
    echo "$0: Argument cannot greater than 2"
    usage
  fi 

 

CORBA

Source:
http://www.codeproject.com/KB/IP/corba.aspx

LinuxIPTables

Source:
http://www.thegeekstuff.com/2011/03/iptables-inbound-and-outbound-rules/
https://help.ubuntu.com/community/IptablesHowTo