What is MySql and how to use it?
Mysql:
Mysql is a open source relational database management system which uses structured query language.It is use to add,access and manage the database.It is quick proccessing,flexible and reliable to use.
Now we see how to install it and use it:
Step 1: Install Mysql by using yum command.
[root@scalebuzz~]# yum -y install mysql-server
Step 2: Once it installed start the mysql
[root@scalebuzz~]# /etc/rc.d/init.d/mysqld start
Step 3: Set autoboot after rebooting the system.
[root@scalebuzz~]# chkconfig mysqld on
Step 4: Login into Mysql
[root@scalebuzz ~]# mysql -u root
# show user info
mysql> select user,host,password from mysql.user;
# set root password
To set the root paasword
mysql> set password for root@localhost=password(‘password’);
mysql> delete from mysql.user where user=”;
To delete the Mysql user
mysql> select user,host,password from mysql.user;
Select user for Mysql
mysql> exit
To exit from Mysql.