Electricity Bill Calculator

Electricity Bill Calculator

Electricity Bill Cost Calculator. Electricity Usage Consumption Calculator.

Select Country:  
Typical Appliance:
Power Consumption:
Hours Of Use Per Day: Hrs/Day
One Unit Cost (1 kWh ):
 
Electricity Cost Per Day:  
Electricity Cost Per Month:  
Electricity Cost Per Year:  

Note:- 1 Unit = 1 kwh (Kilo Watt Hour)

HTML tutorial

Social Message

Social Message
Social Message Useful Health Tips

Saturday, February 20, 2016

Windows 10 Hangs when creating a new folder and hangs again when Renaming Folder

Windows 10 Hangs when creating a new folder and hangs again when Renaming Folder


Click Windows Start Click "File Explorer " option - Click "View" option – Click "Options" and then "Change folder and search options"


Under Privacy:


Deselect “Show frequently use folders in Quick access.”
Deselect “Show recently used folders in Quick access.”
Then click on “Clear” and OK to save your preferences.





Sunday, February 14, 2016

MySQL Database Installation Using RPM Package on Redhat & Other Linux

MySQL Database Installation Using RPM Package on 

Redhat & Other Linux 


Download below RPM Packages below MySQL Site.

http://dev.mysql.com/downloads/mysql/

[root@SERVER11 ~]# ls -ltr
-rwxrwxr-x. 1 root root   3806848 Feb  5 10:59 mysql-community-devel-5.7.10-1.el6.x86_64.rpm
-rwxrwxr-x. 1 root root  23788680 Feb  5 11:21 mysql-community-client-5.7.10-1.el6.x86_64.rpm
-rwxrwxr-x. 1 root root 140055132 Feb  5 11:41 mysql-community-server-5.7.10-1.el6.x86_64.rpm
-rwxrwxr-x. 1 root root   2229848 Feb  5 12:04 mysql-community-libs-5.7.10-1.el6.x86_64.rpm
-rw-r--r--. 1 root root    332252 Feb  5 12:29 mysql-community-common-5.7.10-1.el6.x86_64.rpm

Install RPM Packages:

[root@SERVER11 ~]# rpm -ivh mysql-community-common-5.7.10-1.el6.x86_64.rpm
warning: mysql-community-common-5.7.10-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-common ########################################### [100%]
[root@SERVER11 ~]# rpm -ivh mysql-community-libs-5.7.10-1.el6.x86_64.rpm
warning: mysql-community-libs-5.7.10-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-libs   ########################################### [100%]
[root@SERVER11 ~]# rpm -ivh mysql-community-client-5.7.10-1.el6.x86_64.rpm
warning: mysql-community-client-5.7.10-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-client ########################################### [100%]
[root@SERVER11 ~]# rpm -ivh mysql-community-server-5.7.10-1.el6.x86_64.rpm
warning: mysql-community-server-5.7.10-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-server ########################################### [100%]

MySQL stop / start Service:

[root@SERVER11 ~]# service mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@SERVER11 ~]# service mysqld start
Starting mysqld:                                           [  OK  ]
[root@SERVER11 ~]# service mysqld status
mysqld (pid  3138) is running...

Get Temp. MySQL Password:

[root@SERVER11 ~]# grep 'temporary password' /var/log/mysqld.log
2016-02-05T07:28:43.322922Z 1 [Note] A temporary password is generated for root@localhost: e%clot#eT4he

[root@SERVER11 ~]# mysql -uroot -p
Enter password: Type Above Temp. password "e%clot#eT4he"
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.10

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Reset the password:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'mohan@123';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
[root@SERVER11 ~]# mysql -uroot -p
Enter password: Type New Password "mohan@123"
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.10 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye

Check MySQL Service Running Status Commands:

[root@SERVER11 ~]# ps -eaf | grep mysql

root      2942     1  0 12:59 pts/0    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql     3138  2942  0 12:59 pts/0    00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root      3249  2279  0 13:05 pts/0    00:00:00 grep mysql
[root@SERVER11 ~]#







RESETTING THE ROOT PASSWORD FOR MYSQL RUNNING ON RHEL OR CENTOS LINUX

RESETTING THE ROOT PASSWORD FOR MYSQL RUNNING ON RHEL OR CENTOS LINUX

Perform below steps:-


Started MySQL in safe mode

[root@SERVER11 ~]# mysqld_safe --skip-grant-tables &
[1] 24544
60205 20:13:17 mysqld_safe Logging to '/var/log/mysqld.log'.
160205 20:13:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

 Logged in using root

[root@SERVER11 ~]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.66 Source distribution

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Reset the MySQL password

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'mohan@123';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER 'root'@'localhost' IDENTIFIED BY 'mcas@123'' at line 1
mysql> select host, user from user;
ERROR 1046 (3D000): No database selected
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from  user;
+-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
| Host      | User | Password                                  | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections |
+-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
| localhost | root |                                           | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                | Y          | Y            |          |            |             |              |             0 |           0 |               0 |                    0 |
| SERVER11  | root | *7C7AE13C8C5C7D4E771E8C62907618D43FA4F30E | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                | Y          | Y            |          |            |             |              |             0 |           0 |               0 |                    0 |
| 127.0.0.1 | root |                                           | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                | Y          | Y            |          |            |             |              |             0 |           0 |               0 |                    0 |
| localhost |      |                                           | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          | N            | N          | N                     | N                | N            | N               | N                | N                | N              | N                   | N                  | N                | N          | N            |          |            |             |              |             0 |           0 |               0 |                    0 |
| SERVER11  |      |                                           | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          | N            | N          | N                     | N                | N            | N               | N                | N                | N              | N                   | N                  | N                | N          | N            |          |            |             |              |             0 |           0 |               0 |                    0 |
+-----------+------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+
5 rows in set (0.00 sec)

mysql> truncate table user;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to root@localhost identified by 'mohan@123' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> select host, user from user;
+-----------+------+
| host      | user |
+-----------+------+
| localhost | root |
+-----------+------+
1 row in set (0.00 sec)

mysql> quit
Bye

 Stop MySQL in safe mode

[root@SERVER11 ~]# service mysqld stop
Stopping mysqld:                                           [  OK  ]

 Start MySQL

[root@SERVER11 ~]# service mysqld start
Starting mysqld:                                           [  OK  ]


Log in using the new password

[root@SERVER11 ~]# mysql -u root -pmohan@123
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.66 Source distribution

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit
Bye




Rehat Linux My SQL Installation

Rehat 5 / 6 Linux My SQL Installation

While Installing Redhat Linux Operating system select MySQL Database option. After that try below steps.


[root@SERVER11 /]# service mysqld start

Initializing MySQL database:  Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h SERVER11 password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

                                                           [  OK  ]
Starting mysqld:                                 [  OK  ]


[root@SERVER11 /]# service mysqld status
mysqld (pid  6501) is running...



Friday, February 12, 2016

Redhat Linux Stop Firewall Service

Redhat Linux Stop Firewall Service


Temporary stop firewall service.


[root@SERVER11 ~]# service iptables stop

iptables: Flushing firewall rules:                         [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                               [  OK  ]


Permanent stop firewall service.

[root@SERVER11 ~]# chkconfig iptables off


Check firewall service Running Status.

[root@SERVER11 ~]# service iptables status
iptables: Firewall is not running.