Scribd Logo
Upload

Welcome to Scribd!

  • 37 views

    Mysql Installation On Ubuntu

    Uploaded by

    apeksha_bochare
    To install MySQL on Ubuntu, run commands through the terminal to install the mysql-server package and mysql-query-browser. Configure the my.cnf file to allow remote connections and set the root password. Finally, use the MySQL Query Browser application to connect to the MySQL server and begin executing queries.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Mysql Installation On Ubuntu

    Uploaded by

    apeksha_bochare
    37 views4 pages
    To install MySQL on Ubuntu, run commands through the terminal to install the mysql-server package and mysql-query-browser. Configure the my.cnf file to allow remote connections and set the root password. Finally, use the MySQL Query Browser application to connect to the MySQL server and begin executing queries.

    Original Title

    Mysql Installation on Ubuntu

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    To install MySQL on Ubuntu, run commands through the terminal to install the mysql-server package and mysql-query-browser. Configure the my.cnf file to allow remote connections and set the root password. Finally, use the MySQL Query Browser application to connect to the MySQL server and begin executing queries.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    37 views4 pages

    Mysql Installation On Ubuntu

    Uploaded by

    apeksha_bochare
    To install MySQL on Ubuntu, run commands through the terminal to install the mysql-server package and mysql-query-browser. Configure the my.cnf file to allow remote connections and set the root password. Finally, use the MySQL Query Browser application to connect to the MySQL server and begin executing queries.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 4

    How to install MySQL On Ubuntu

    Follow the instructions to install MySQL and MySQL Query Browser on Ubuntu.
    Installing MySQL on Ubuntu:
    STEP1:
    To open the Terminal, go to Application > Accessories > Terminal

    STEP 2:

    Type the following command at terminal.

    $sudo apt-get install mysql-server

    STEP 3:
    To be able to connect to mysql from internet, remove the restriction on the below file.

    STEP 4:
    Open the file by typing the following command at terminal prompt.

    $gksudo gedit /etc/mysql/my.cnf

    STEP 5:
    Find the line bind-address = 127.0.0.1 and comment it out as shown below.

    #bind-address= 127.0.0.1

    STEP 6:
    Mysql comes with no root password. To set the root password, type:

    $mysqladmin -u root password your-new-password $sudo /etc/init.d/mysql restart

    STEP 7:
    Install mysql query browser $sudo apt-get install mysql-query-browser

    STEP 8:
    After installing, go to Applications > Programming > MySQL Query Browser to connect to mysql as shown below.

    STEP 9:
    Enter Server Hostname, Username and Password. Click on Connect and MySQL is now installed on Ubuntu.

    STEP 10: Start solving queries.

    You might also like