Wednesday, 21 November 2012

Create database and Drop database

How to create database :

 Mysql login with root user

Create a database "foss" and Verify that it’s there

How to remove database:

                   mysql>  drop  database  foss;

                     mysql>  exit


Saturday, 10 November 2012

How to reset Mysql root password on linux

First stop the mysql daemon service

   # /etc/init.d/mysqld   stop

Then, run following command in terminal

   # mysqld_safe    --skip-grant-tables   & 

Now login mysql

   # mysql   -u   root   mysql

Change root  password

   mysql >  UPDATE  mysql.user  SET  Password=PASSWORD('MyNewPass') WHERE User='root';


   mysql> exit

Now start the mysql daemon service

   # /etc/init.d/mysqld   start

   #  mysql   -u   root   -p

I hope , Now you can able to login with root user.

Monday, 5 November 2012

How to create user and set password in mysql

First login root user in mysql

        [root@sysadmin ~] # mysql -u root -p

Create the user

               mysql > create user test_user@localhost;

Set password for 'test_user'

          mysql > SET PASSWORD FOR 'test_user'@'localhost'  =  PASSWORD('test@1234');

Check test_user can able to login or not

      [root@sysadmin ~]# mysql  -u  test_user  -p
      Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.67-log 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

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

mysql> exit

 Successfully created user and set password. 

Check user list on mysql

                mysql> SELECT User FROM mysql.user; 

How to remove user in mysql

           mysql>  drop   user   'test_user'@'localhost';

Thursday, 1 November 2012

Skype Installation and Configuration on Proxy Network in Ubuntu

Skype allows people to communicate with each other by Messaging, Voice calling and Video calling over internet.Now we are going to install Skype.

Installation of Skype

                  manivel@manivel-admin:~$ sudo apt-get install skype

To check whether skype installed or not.Once skype installed you will get below output

                  manivel@manivel-admin:~$ sudo dpkg --list | grep skype

sudo: unable to resolve host manivel-admin

ii  pidgin-skype    20110407+svn612+dfsg-1.1  Skype plugin for libpurple messengers

ii  pidgin-skype-dbg 20110407+svn612+dfsg-1.1 Skype plugin for libpurple messengers (debug symbols)

ii  skype     client for Skype VOIP and instant messaging service

ii  skype-bin     client for Skype VOIP and instant messaging service - binary files

If you want open skype via terminal then open the terminal and type "skype"

              manivel@manivel-admin:~$  skype

How to Configure Proxy on Skype 

        Go to desktop top panel there is Skype symbol then Right click ---> options and set your proxy details.

I hope this helps.....,