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
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 Browser to connect to mysql as shown below.
Enter Server Hostname , Username and Password . Click on Connect and MySQL is now installed on Ubuntu.
查看更多关于在ubuntu上安装mysql：HowtoinstallMySQLonubuntu(转)的详细内容...