Creazione del ambiente di sviluppo su Ubuntu

Ubuntu 21.04 ( 64-bit )

download

Java Runtime Environment ( JRE )   : :   JDK ( Java Development Kit )   : :   Java Doc - version 11.0.11

itammb@itammb-VirtualBox:~$ sudo apt-get --purge remove default-jre default-jdk openjdk-11-doc
itammb@itammb-VirtualBox:~$ sudo apt-get update
itammb@itammb-VirtualBox:~$ sudo apt-get install default-jre 
itammb@itammb-VirtualBox:~$ sudo apt-get install default-jdk 
itammb@itammb-VirtualBox:~$ sudo apt-get install openjdk-11-doc
itammb@itammb-VirtualBox:~$ java -version

Java Doc → shortcut

itammb@itammb-VirtualBox:~$ ln -s /usr/share/doc/openjdk-11-doc/index.html /home/itammb/Desktop/openjdk-11-doc

Eclipse - version 2019.12

itammb@itammb-VirtualBox:~$ sudo snap install --classic eclipse

MySQL - version 8.0.25

itammb@itammb-VirtualBox:~$ sudo apt-get --purge remove mysql-server mysql-common mysql-client
itammb@itammb-VirtualBox:~$ sudo apt-get upgrade
itammb@itammb-VirtualBox:~$ sudo apt-get install mysql-server mysql-common mysql-client
itammb@itammb-VirtualBox:~$ mysql -V

Ubuntu - services

itammb@itammb-VirtualBox:~$ sudo apt-get install net-tools

itammb@itammb-VirtualBox:~$ sudo netstat -tap

itammb@itammb-VirtualBox:~$ sudo netstat -tap | grep mysql

MySQL → server status

itammb@itammb-VirtualBox:~$ sudo systemctl status mysql.service

MySQL → server start

itammb@itammb-VirtualBox:~$ sudo systemctl start mysql.service

MySQL → server stop

itammb@itammb-VirtualBox:~$ sudo systemctl stop mysql.service

MySQL → server re-start

itammb@itammb-VirtualBox:~$ sudo systemctl restart mysql.service

MySQL → root user authentication

itammb@itammb-VirtualBox:~$ sudo mysql_secure_installation

itammb@itammb-VirtualBox:~$ mysql -u root -p

MySQL → user authentication

itammb@itammb-VirtualBox:~$ sudo mysql

	mysql> use mysql;
mysql> select user, authentication_string, plugin, host FROM mysql.user;

mysql> update mysql.user set authentication_string=null where user='root';
mysql> alter user 'root'@'localhost' identified with caching_sha2_password BY 'fiore76!"£XXXXXX';
mysql> flush privileges;
mysql> select user, authentication_string, plugin, host FROM mysql.user;

mysql> exit;

itammb@itammb-VirtualBox:~$ mysql -u root -p

MySQL - database configuration file

itammb@itammb-VirtualBox:~$ sudo gedit /etc/mysql/mysql.cnf

MySQL → reference manual

download

itammb@itammb-VirtualBox:~$ sudo tar -zxvf /home/itammb/Downloads/refman-8.0-en.html-chapter.tar.gz -C /usr/share/doc/mysql-server

itammb@itammb-VirtualBox:~$ ln -s /usr/share/doc/mysql-server/refman-8.0-en.html-chapter/index.html /home/itammb/Desktop/mysql-server-doc

Riferimenti

Come installare MySQL 5.7 su Ubuntu 20.04 LTS How to reset the root password in MySQL 8.0.11 ?

© Buscati Caminiti Massimiliano Patrizio. All rights reserved. office@buscati.org