| Zolved community solution |
 new article edit article
|
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.
.jpg)
#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.
.jpg)
|
del.icio.us
stumble
print
- Posted by: phillean_113 at 16 Aug 21:55 permalinkI am using Ubuntu Hardy Herron, this worked fine, thank you. A very big help. In my install it asked for a root password for MYSQL. I am not sure if this was the install process or du to that fact that I had already installeld MSQL Query browser using the package installer, thinking this would install MYSQL, phillean@netspeed.com.au
