Home > Database > Mysql Tutorial > 在ubuntu上安装mysql : How to install MySQL on ubuntu(转)

在ubuntu上安装mysql : How to install MySQL on ubuntu(转)

WBOY
Release: 2016-06-07 15:02:48
Original
1328 people have browsed it

How to install MySQL On Ubuntu Follow the instructions in this article to help you install MySQL and MySQL Query Browser on Ubuntu. Installing MySQL on Ubuntu: To open the Terminal, go to Application Accessories Terminal Type the following

How to install MySQL On Ubuntu

Follow the instructions in this article to help you install MySQL and MySQL Query Browser on Ubuntu.

Installing MySQL on Ubuntu:

        To open the Terminal, go to Application > Accessories > Terminal


          在ubuntu上安装mysql : How to install MySQL on ubuntu(转)

          Type the following command at terminal.

  •  $sudo apt-get install mysql-server

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

  • Open the file by typing the following command at terminal prompt.

          $gksudo gedit /etc/mysql/my.cnf

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

            在ubuntu上安装mysql : How to install MySQL on ubuntu(转)

         #bind-address           = 127.0.0.1 

  • 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

  • Install mysql query browser

         $sudo apt-get install mysql-query-browser

  • After installing, go to Applications > Programming > MySQL Query Browserto connect to mysql as shown below.


              在ubuntu上安装mysql : How to install MySQL on ubuntu(转)

             Enter Server Hostname,Username and Password. Click onConnect and MySQL is now installed on Ubuntu.


            在ubuntu上安装mysql : How to install MySQL on ubuntu(转)


Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template