My Technical Notes

Display the date:

Simply type the date command to display the current date:

# date

Output:

Fri Mar  12 12:44:29 CST 2010

To set/change date:

To set the date, you need to simply use the date command followed by the year, month, day, hour, minute, and second … all numeric and no spaces.

To set the date with date command, you need [...]

At a shell or command (cmd for windows) prompt you type all one 1 single line:

mysql -u DB_USER_NAME -p[PASSWORD] DB_NAME -h DB_SERVER

with the following replacements of the terms above:

* Replace DB_SERVER with the correct database servername or IP address

* Replace DB_USER_NAME with your mysql username.

* Replace DB_NAME with your mysql databasename.

* [PASSWORD] [...]

to create new user on mysql database we can use below script;

DB_NAME = KartookShop
DB_USER = Kartook
DB_PASSWORD = password
HOST=localhost

we want to give SELECT,INSERT,UPDATE,DELETE,CREATE,DROP permission on Kartook.

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON KartookShop.* TO ‘Kartook’@’localhost’ IDENTIFIED BY ‘password’;

this will allow Kartook to connect to KartookShop database from localhost. If you want to give permission [...]

How to Create a new database on MySQL?

To create a new database you need to login as root or a account that has permission.

we will create KartookShop database.

-> mysql -u root -p
mysql> create database KartookShop;
Query OK, 1 row affected (0.06 sec)

Possibly Related Posts:

Linux : How to Disable Direct Root Logins
Linux :How to encrypt text file [...]

Here what bc, a command line calculator, comes in handy.
In this short tutorial, I will show how to do some basic calculation with bc.

First launch bc by typing bc and hitting enter. You will see bc ready to take your commands.

[root@kartook ~]# bc
bc 1.06
Copyright 1991-1994, 1997, 1998, 2000 Free Software Foundation, Inc.
This is free software [...]