logo

New Offers Coming Soon.

Email: [email protected]
Phone No. INDIA : +91 8467988800
                         USA : +12136402431

Follow Us:


Call Now! 🇮🇳 + (91) 8467988800

24X7 LIVE TECHNICAL SUPPORT

Follow Us:

Login       Register

What is MySql and how to use it?

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.
[[email protected]~]# yum -y install mysql-server

Step 2: Once it installed start the mysql
[[email protected]~]# /etc/rc.d/init.d/mysqld start

Step 3: Set autoboot after rebooting the system.
[[email protected]~]# chkconfig mysqld on

Step 4: Login into Mysql
[[email protected] ~]# 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 [email protected]=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.

admin
No Comments

Post a Comment

Comment
Name
Email
Website

Open chat