Aktifkan com.mysql.jdbc.driver ke xampp

Introduction

XAMPP is a cross-platform web server solution package developed by Apache Friends. It’s open-source and free to use. It uses an Apache HTTP Server and MariaDB, PHP, and Perl.

XAMPP is an acronym for:

• X - Cross-Platform
• A - Apache
• M - MariaDB (formerly MySQL)
• P - PHP
• P - Perl

XAMPP works perfectly well on different operating systems like Windows or Linux. However, other versions are specifically made for an operating system like WAMP (Windows) or LAMP (Linux). To download XAMPP, visit the Apache and Friends Web page.

Why Connect XAMPP To Arctype?

Arctype is a fast, beautiful database GUI for developers and teams. With SQL autocomplete, spreadsheet-style editing, one-click visualizations, collaboration, and the best support for Postgres, MySQL, PlanetScale, Yugabyte, and SQLite, you can use Arctype to work with almost any DB.

This guide will walk you through the process of:

• Configuring XAMPP to connect with Arctype

• Changing or setting the password for your XAMPP server

• Configuring Arctype to connect with XAMPP

Prerequisites

To follow along, you need to have:

• XAMPP downloaded and installed on your PC
• Arctype downloaded and installed on your PC

Step 1: Start Apache and MySQL

First, open the XAMPP GUI. Then, start Apache and MySQL by clicking on “start” for both in the GUI. This will run the XAMPP server and activate all the packages built into it. It also enables an SQL client like Arctype to connect to it.

Step 2: Set Password for Your XAMPP Server

After installing XAMPP on your Windows machine, the root password is set to empty by default. However, this is not recommended, as a database without a password is accessible to everyone. Therefore, you need to set a secure password for your server.

Old versions of XAMPP come with a security page, allowing you to visit http://localhost/security/** **to set up the password for XAMPP directly. However, the new versions of XAMPP no longer support the security page, so your password will have to be set from PhpMyAdmin.

From your browser, visit http://localhost/phpmyadmin/, then click on “user account.” On the User accounts overview page, go to the user with username as “root” and hostname as “localhost” and click on “Edit Privileges.”

This takes you to a page where you can create your password and click ‘“Go.”

If you try accessing http://localhost/phpmyadmin/ after setting or changing your password, it displays an error.

To resolve this error, go to the XAMPP directory on your PC and locate the PhpMyAdmin folder. Inside the folder, locate a file named “config.inc.php” then open the file in an editor.

File Explorer → This PC → Local Disk (C:) → Xampp → PhpMyAdmin → Config.inc File

Under “Authentication type and info” change ‘config’ to ‘cookie’ then insert the password you created earlier into the open quotation mark for password. Then save the file.

The above steps will successfully create a password for your MySQL database on XAMPP, which you can now use to connect to Arctype.

Step 3: Connect to Arctype

The last step is to add or create a new connection on the Arctype GUI using the credentials from the XAMPP and PhpMyAdmin setup.

User name: root Password: same as created on XAMPP

Then, test your connection. You should see a “connection successful” message, after which you can save your connection

You now have access to your database on Arctype, where you can write your queries visualize your data with graphs, charts or tables. For more information about Arctype, check out the Arctype documentation or join the Arctype Discord.

5.3.1 Configuring a Connector/ODBC DSN on Windows with the ODBC Data Source Administrator GUI

The ODBC Data Source Administrator on Windows lets you create DSNs, check driver installation, and configure ODBC functions such as tracing (used for debugging) and connection pooling. The following are steps for creating and configuring a DSN with the ODBC Data Source Administrator:

1. Open the ODBC Data Source Administrator.

   Different editions and versions of Windows store the ODBC Data Source Administrator in different locations. For instructions on opening the ODBC Data Source Administrator, see the documentation for you Windows version; these instructions from Microsoft cover some popuar Windows platforms. You should see a window similar to the following when you open the ODBC Data Source Administrator:

   Figure 5.1 ODBC Data Source Administrator Dialog

   
   
   

2. To create a System DSN (which will be available to all users), select the System DSN tab. To create a User DSN, which will be available only to the current user, click the Add... button to open the "Create New Data Source" dialog.

3. From the "Create New Data Source" dialog, select the MySQL ODBC 5.x ANSI or Unicode Driver, then click Finish to open its connection parameters dialog.

   Figure 5.2 Create New Data Source Dialog: Choosing a MySQL ODBC Driver

   
   
   

4. You now need to configure the specific fields for the DSN you are creating through the Connection Parameters dialog.

   Figure 5.3 Data Source Configuration Connection Parameters Dialog

   

   In the Data Source Name box, enter the name of the data source to access. It can be any valid name that you choose.

   Tip

   To identify whether a DSN was created using the 32-bit or the 64-bit driver, include the driver being used within the DSN identifier. This will help you to identify the right DSN to use with applications such as Excel that are only compatible with the 32-bit driver. For example, you might add Using32bitCODBC to the DSN identifier for the 32-bit interface and Using64bitCODBC for those using the 64-bit Connector/ODBC driver.

5. In the Description box, enter some text to help identify the connection.

6. In the Server field, enter the name of the MySQL server host to access. By default, it is localhost.

7. In the User field, enter the user name to use for this connection.

8. In the Password field, enter the corresponding password for this connection.

9. The Database pop-up should be automatically populated with the list of databases that the user has permissions to access.

10. To communicate over a different TCP/IP port than the default (3306), change the value of the Port.

11. Click OK to save the DSN.

To verify the connection using the parameters you have entered, click the Test button. If the connection can be made successfully, you will be notified with a Connection Successful dialog; otherwise, you will be notified with a Connection Failed dialog.

You can configure a number of options for a specific DSN by clicking the Details button.

Figure 5.4 Connector/ODBC Connect Options Dialog

Toggling the Details button opens (or closes) an additional tabbed display where you set additional options that include the following:

• Connections, Metadata, and Cursors/Results enable you to select the additional flags for the DSN connection. For more information on these flags, see Section 5.2, “Connector/ODBC Connection Parameters”.

  Note

  For the Unicode version of Connector/ODBC, due to its native Unicode support, you do not need to specify the initial character set to be used with your connection. However, for the ANSI version, if you want to use a multibyte character set such as UTF-16 or UTF-32 initially, specify it in Character Set box; however, that is not necessary for using UTF-8 or UTF-8-MB4 initially, because they do not contain \0 bytes in any characters, and therefore the ANSI driver will not truncate the strings by accident when finding \0 bytes.

• Debug lets you turn on ODBC debugging to record the queries you execute through the DSN to the myodbc.sql file. For more information, see Section 5.9, “Getting an ODBC Trace File”.

• SSL configures the additional options required for using the Secure Sockets Layer (SSL) when communicating with MySQL server.

  Figure 5.5 Connector/ODBC Connect Options Dialog: SSL Options

  

  You must also enable and configure SSL on the MySQL server with suitable certificates to communicate using it using SSL.