MYSQL Authority~!

$ mysql -u root -p
Enter password:

mysql> use mysql

mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password'; 

mysql> FLUSH PRIVILEGES;

if i want all ipaddress can access to DB Server

mysql> GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'your-root-password'

how to install scp on linux

[root@centos6 ~]# yum install openssh-clients

Change Database Characters

Change Character set

There are many way to change character set
this way is to change database character set

ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

belows sql query shows that what kind of character set mysql has

mysql> show character set;

+x means a+x : all user can execute

$ chmod +x your-script-name
$ chmod 755 your-script-name




Examples:
$ bash bar
$ sh bar
$ ./bar


echo show on monitor

$ vi first # # My first shell script # clear echo "Knowledge is Power"

$ ./first

when you write 'free' on linux

you will know the rest of you computer memory

[root@posu7 logs]# free

             total       used       free     shared    buffers     cached
Mem:        524288     404716     119572          0      76072      93512
-/+ buffers/cache:     235132     289156
Swap:      1081336        112    1081224

Install Mysql

Now I let you know how to install MySQl on linux

First this will check if mysql is already installed on linux

# rpm -qa | grep mysql

Remove previouse Versin

# rpm -e  mysql-devel-5.0.77-4.el5_5.4 –-nodeps(--nodeps will ignore dependencies)

And go to web site to find the version that you want to install

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

# rpm -ivh Mysql-server....rpm

# rpm -ivh Mysql-share.....rpm

# rpm -ivh mysql-devel......rpm

# rpm -ivh mysql-client......rpm

A) If you are /using mysql on RedHat Linux (Fedora Core/Cent OS) then use following command:

* To start mysql server:

/etc/init.d/mysqld start

* To stop mysql server:

/etc/init.d/mysqld stop

* To restart mysql server

 /etc/init.d/mysqld restart

# service mysqld start
# service mysqld stop
# service mysqld restart

$ mysql -u root -p
Enter password:

mysql> use mysql

mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password'; 

mysql> FLUSH PRIVILEGES;
and /etc/sysconfig vi iptables and add open 3306 port

What is RPM

RPM(RedHat Package Manager)

RPM Package Manager (RPM) is a package management system.^[2]The name RPM variously refers to the .rpm file format, files in this format,software packaged in such files, and the package manager itself. RPM was intended primarily for GNU/Linux distributions; the file format is the baseline package format of the Linux Standard Base.

rpm -qi :  mtools-3.9.8-2.i386.rpm print package summary
rpm -i : mtools-3.9.8-2.i386.rpm install package
rpm -ivh : mtools-3.9.8-2.i386.rpm install, monitor and verify pack
rpm -q : mtools verify if pack installed
rpm -qa :  list all installed packs
rpm -ql : mtools list all files installed for pack
rpm -qd : mtools list pack doc files only
rpm -e  : mtools erase package
rpm -Uvh :  * upgrade all packs in distribution