Linux Commands for Java & MySQL Setup

1. Java Install

First, update the package index.

• sudo apt-get update

Next, install Java. Specifically, this command will install the Java Runtime Environment (JRE).

• sudo apt-get install default-jre

The JDK does contain the JRE, so there are no disadvantages if you install the JDK instead of the JRE, except for the larger file size.

You can install the JDK with the following command:

• sudo apt-get install default-jdk

2. Install MySQL

Step 1 — Installing MySQL Base

On Ubuntu 16.04, only the latest version of MySQL is included in the APT package repository by default. At the time of writing, that's MySQL 5.7

To install it, simply update the package index on your server and install the default package with apt-get.

• sudo apt-get update

• sudo apt-get install mysql-server

Step 2 —Run the security script and Configure.

• mysql_secure_installation

Step 3 — Testing MySQL

Regardless of how you installed it, MySQL should have started running automatically. To test this, check its status.

• systemctl status mysql.service

3. Extract tar/zip

Type man tar for more information, but this command should do the trick:

tar -xvzf community_images.tar.gz

To explain a little further, tar collected all the files into one package, community_images.tar. The gzip program applied compression, hence the gz extension. So the command does a couple things:

• f: this must be the last flag of the command, and the tar file must be immediately after. It tells tar the name and path of the compressed file.

• z: tells tar to decompress the archive using gzip

• x: tar can collect files or extract them. x does the latter.

• v: makes tar talk a lot. Verbose output shows you all the files being extracted.

4. Folder Permission 

In that chmod -R 755 will set these permissions to all files and subfolders in the tree 

To change all the directories to 755 (drwxr-xr-x):

find /opt/lampp/htdocs -type d -exec chmod 755 {} \;

To change all the files to 644 (-rw-r--r--):

find /opt/lampp/htdocs -type f -exec chmod 644 {} \;

5. Change User in Linux

How about using the su command?

$ whoami

user1

$ su - user2

Password:

$ whoami

user2

$ exit

logout

If you want to log in as root, there's no need to specify username:

$ whoami

user1

$ su -

Password:

$ whoami

root

$ exit

logout

6. MySQL Login

mysql -u USERNAME -pPASSWORD -h HOSTNAMEORIP DATABASENAME 

mysql -u root -p

The options above means:

-u: username

-p: password (**no space between -p and the password text**)

-h: host

last one is name of the database that you wanted to connect. 

7. Reinstall MySQL

Find and remove All Files my.cnf

sudo find / -name my.cnf

Try running the following command to reset and purge all MySQL related things:

sudo apt purge mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7 mysql-server-core-5.7 mysql-server

Once this is done, run the below to update your system and "clean up" your package cache.

sudo apt update && sudo apt dist-upgrade && sudo apt autoremove && sudo apt -f install

Then, try re-installing MySQL Server:

sudo apt install mysql-server

8. MySQL/MariaDB Status

Secure Installation Permission

sudo chmod -R 755 /var/lib/mysql/

Start

systemctl start mariadb.service

Enable

systemctl enable mariadb.service

Status

service mysqld status

10. CHAR CODE SET - utf8mb4

ALTER DATABASE at CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

ALTER TABLE CORE_DATA CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Create Table:

CREATE TABLE `CORE_DATA` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `type` int(11) DEFAULT NULL,

  `subtype` int(11) DEFAULT NULL,

  `parentID` int(11) DEFAULT NULL,

  `name` varchar(500) DEFAULT NULL,

  `message` varchar(8000) DEFAULT NULL,

  `tags` varchar(500) DEFAULT NULL,

  `orderNo` int(11) DEFAULT NULL,

  `url` varchar(500) DEFAULT NULL,

  `downloadurl` varchar(5000) DEFAULT NULL,

  `blobkey` varchar(500) DEFAULT NULL,

  `blobSize` bigint(20) DEFAULT NULL,

  `actualDate` date DEFAULT NULL,

  `createdDate` date NOT NULL,

  `updatedDate` date DEFAULT NULL,

  `referenceID` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

SELECT * FROM at.core_data;