UbuntuMySQL and Workbench Installation

1. Install mysql 1. sudoapt-getinstallmysql-servermysql-client (a window pops up asking for the mysqlroot user password during installation) 2. Once Installation

I. mysql installation 1. sudo apt-get install mysql-server mysql-client (a window pops up asking for the mysql root User Password during the installation process) 2. Once Installation

1. Install mysql
1. sudo apt-get install mysql-server mysql-client

(A window pops up asking for the mysql root User Password during the installation process)

2. Once the installation is complete, the MySQL server should be started automatically. You can run the following command at a terminal prompt to check whether the MySQL server is running:
Pprun @ pprun-t61 :~ $ Sudo netstat-tapln | grep mysql
Tcp 0 0 0.0.0.0: 3306 0.0.0.0: * LISTEN 1293/mysqld

3. If the server cannot run properly, run the following command to start it:
Sudo/etc/init. d/mysql restart

4. allow remote access to the MySQL database
In Ubuntu, MySQL only allows local access by default. If you want other machines to remotely access this Mysql database, you need to set something. Next we will step by step:

$ Sudo gedit/etc/mysql/my. cnf

Bind-address = 127.0.0.1
Change bind-address = the IP address of your machine so that other machines can access MySQL.
Or you can comment it out directly.

Ii. workbench
(When I published this article, mysql workbench 5.2 series is release candidate)
1. download mysql-workbench-ce-5.2.24-1ubu910-i386.deb

2. apt-get install libdbd-mysql-perl libdbi-perl libmysqlclient15off libnet-daemon-perl libplrpc-perl libzip1 mysql-client-5.1 python-paramiko python-pexpect

3. sudo dpkg-I mysql-workbench-ce-5.2.24-1ubu910-i386.deb

4. If any error occurs, follow the prompts.
Sudo apt-get-f install

5. After installation, choose menu application | Mysql Workbench under programming