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

    admin
    No Comments

    Post a Comment

    Comment
    Name
    Email
    Website