My Technical Notes

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] is [...]

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 to [...]

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:

How ot install Tweetdeck on ubuntu 10.04 64bit
VMware : How to setup Windows Active [...]

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 with [...]