Install Mysql offline in Ubuntu and mysql offline in ubuntu

Install Mysql offline in Ubuntu and mysql offline in ubuntu

I. Installation Package

Download the Mysql installation package from the network and copy it to the USB flash drive.

: Https://dev.mysql.com/downloads/mysql/

Ii. mount a USB flash drive

2.1 view partitions

Enter the command cat/proc/partitions first

Insert a USB flash drive and re-enter the command

Cat/proc/partitions

The results show that there are more

8 16 *** sdb
8 17 * sdb1

The new USB flash drive is/dev/sdb1.

2.2 File System Format

Check the file system format of the USB flash drive and enter the command

Sudo fdisk-l/dev/sdb

2.3 mount a USB flash drive

Take media/usb as the mount point and check whether/media/usb exists. If not, create the sudo mkdir usb folder. confirm that the directory exists and enter:

Sudo mount-t vfat/dev/sdb1/media/usb

2.4 uninstall

Umount/media/usb

Note: the installation is successful and runs when the USB flash drive is pulled out.

Iii. Install Mysql

3.1 unzip the installation package

Tar-xvf mysql-server_5.6.37-1ubuntu14.04_amd64.deb-bundle.tar

  3.2 add execution permission

Chmod + x *. deb

3.3 Installation

3.3.1 install dependency packages

Sudo dpkg-I libaio1_0.3.110-2_amd64.deb

3.3.2 install mysql in sequence

Sudo dpkg-I mysql-common_5.6.37-1ubuntu14.04_amd64.deb

Sudo dpkg-I mysql-community-server_5.6.37-1ubuntu14.04_amd64.deb

Sudo dpkg-I libmysqlclient18_5.6.37-1ubuntu14.04_amd64.deb

Sudo dpkg-I libmysqlclient-dev_5.6.37-1ubuntu14.04_amd64.deb

Sudo dpkg-I libmysqld-dev_5.6.37-1ubuntu14.04_amd64.deb

Sudo dpkg-I mysql-community-client_5.6.37-1ubuntu14.04_amd64.deb

Sudo dpkg-I mysql-client_5.6.37-1ubuntu14.04_amd64.deb

Sudo dpkg-I mysql-common_5.6.37-1ubuntu14.04_amd64.deb

Sudo dpkg-I mysql-community-server_5.6.37-1ubuntu14.04_amd64.deb

The root password input box is displayed:

Sudo dpkg-I mysql-server_5.6.37-1ubuntu14.04_amd64.deb

　3.4 execute database scripts(Optional) import business initialization data)

3.4.1 log on to mysql-uroot-p

3.4.2 create database erp;

3.4.3 use the created database use erp;

3.4.4 run the SQL script file source/home/orm/mysql. SQL;