Mysql : Connect to a remote mysql Server

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

MySql : how to create database user on mysql databbase?

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

MySql : How to Create a new database on MySQL?

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 local privilege escalation via SUID
How to uninstall Vmware workstation v 8.0.0.471780.bundle
Linux : Flash fullscreen doesn’t work on Ubuntu 10.10
VCP Home LAB : Part -3
VCP Home LAB – part-2

Linux : Linux command line calculator

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