Ubuntu offline install MySQL

First, the installation package

Download the MySQL installation package from the network and copy to the USB flash drive

: https://dev.mysql.com/downloads/mysql/

Second, mount the U disk

2.1 viewing partitions

Enter the command first cat/proc/partitions

Insert U -Disk, re-enter command

Cat/proc/partitions

The result is two more lines, SDB is a generic term for USB resources

8 * * * SDB
8 * * * SDB1

the newly inserted U disk is /DEV/SDB1

2.2 File System format

Check U -Disk File system format, input command

sudo fdisk-l/dev/sdb

2.3 Mounting U - disk

take Media/usb as the mount point, check if/media/usb exists, create folder sudo mkdir USB If it does not exist , confirm that the directory exists and re-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 drive is unplugged

Third, install MySQL

3.1 Unpacking the installation package

TAR-XVF Mysql-server_5.6.37-1ubuntu14.04_amd64.deb-bundle.tar

3.2 Increase execution Permissions

chmod +x *.deb

3.3 Installation

3.3.1 Install dependent Packages

sudo dpkg–i libaio1_0.3.110-2_amd64.deb

3.3.2 Installing MySQL sequentially

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

Pop-up the root password input box:

sudo dpkg–i mysql-server_5.6.37-1ubuntu14.04_amd64.deb

　3.4 Executing database Scripts (option to import business initialization data)

3.4.1 login mysql mysql –uroot–p

3.4.2 Creating database Create databases ERP;

3.4.3 Use the database created using ERP;

3.4.4 execute SQL script file source/home/orm/mysql.sql;

Ubuntu offline install MySQL