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

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 toApplication > Accessories > Terminal

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.

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

Enter

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

本文原创发布php中文网，转载请注明出处，感谢您的尊重！