Скачать или смотреть Java Tutorial 84 - Java Database Connectivity (JDBC) 1/7 MySQL / MariaDB from the NetBeans IDE

In this tutorial, I will show you how to install XAMPP 7.4.6 for the NetBeans IDE 11.3 on Windows 10 x64. Then I will demonstrate how to work with MariaDB or MySQL in NetBeans IDE.

XAMPP contains MariaDB 10.4.11 that is compatible with MySQL 8.0 with the most notable features. NetBeans IDE comes with support for the MySQL relational database management system (RDBMS). Once the NetBeans IDE is connected with MySQL or other DBMS, you can begin working with a database in the NetBean's Database Explorer by creating new databases or tables. You can populate table with data by running Structured Query Language (SQL) queries on database structures and data.

To follow this tutorial, you need to have following software

NetBeans IDE 11.3, https://netbeans.apache.org/download/...
Java SE 8u251 or 11.0.7 (LTS), https://www.oracle.com/java/technolog...
XAMPP, https://www.apachefriends.org/downloa...
MySQL JDBC connector 8.0.20, https://dev.mysql.com/downloads/conne...
MariaDB JDBC connector 2.6.0, https://mariadb.org/download/

How to install XAMPP

1. Download and install XAMPP
2. Run the installer to install XAMPP, you need to check the components which you want to install and can uncheck.
3. Start the XAMPP control panel through the "Run as administrator" option.
4. XAMPP Control Panel will appear on the screen and click on Start action to start the Apache and MySQL modules.
5. Change the phpMyAdmin password on XAMPP, By default, phpMyAdmin uses root as username without password.
Open XAMPP Control Panel.
Click the Admin button for MySQL.
Click on the User accounts tab.
Click the Edit privileges link for the username root, but the one with hostname localhost.
Click the Change password button.
Specify the new password.
Click the Go button.
6. Change phpMyAdmin access denied message (after step 5)
Open XAMPP Control Panel.
Click the Explorer button.
In the XAMPP folder, open the phpMyAdmin folder.
Open the config.inc.php file with any text editor.
Under “Authentication type and info,” and update the following lines:
$cfg['Servers'][$i]['password'] = 'newPasswd';

Fix an Issue of Apache not Starting in XAMPP.

Method 1: Change the default port of Apache
Open the XAMPP Control Panel.
In Apache Module Service, click on the Config button.
Click on Apache (httpd.conf) option.
Find the "Listen 80" and replace it with another open port (like 8080) and save the file.
Restart the Apache Server

Method 2: By disabling the Internet Information Services (IIS)
From the Start Menu, search for Control Panel.
Click on Apps and then Programs and Features option.
Click on the Turn Windows Feature on or off option.
Uncheck the Internet Information Services option and click on the OK button.
Click on the Restart Now option.
Restart the Apache Server.

Fix an Error of XAMPP Control Panel. (14.42 mins)

Error: Cannot create file "C:\xampp\xampp-control.ini".
Access is denied.

Exception EAccessViolation in module xampp-control.exe at 0025B2AE.
Access violation at address 0065B2AE in module 'xampp-control.exe.' Read of address 00000042.

Method 1: Run as Administrator
You can run the executable file as an Administrator so you will get permission for all the events and tasks of the XAMPP server.

Method 2: Disable User Account Control (UAC)
You can simply disable UAC but it is not recommended.

Fix an Issue of the server time zone value 'unknown' of the NetBeans IDE (5.35 mins)

The server time zone value 'unknown' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specific time zone value if you want to utilize time zone support.

Method 1: Configure the server to use a specific time zone
You can use a more specific time zone value of UTC.

jdbc:mysql://localhost:3306/test?serverTimezone=UTC

Method 2: Configure JDBC driver
You can configure JDBC driver via the 'serverTimezone' configuration property with UTC.

Method 3: Use a MariaDB JDBC connector
If you use a MariaDB JDBC connector 2.6.0, you don't have to configure the 'serverTimezone' configuration property with UTC. MariaDB Connector/J is a Type 4 JDBC driver that was developed specifically as a lightweight JDBC connector for use with MariaDB and MySQL database servers.

Method 3: Adjust time zone
You can adjust time zone to (UTC) Coordinated Universal Time but it is not recommended.