🔌 Connect to MySQL using DBeaver

Follow these steps to set up a connection from DBeaver to your locally installed MySQL server (Ubuntu 25.04, MySQL 8.0.41).

---

Step 1: Launch DBeaver and create a new connection

1. Open DBeaver.
2. Create a new connection using one of these methods:
   • Click the New Database Connection button in the toolbar.
   • Go to Database → New Database Connection in the main menu.
   • Press Ctrl + Shift + N (Windows/Linux) or ⌘ + Shift + N (macOS).

Step 2: Select the MySQL driver

1. In the “Connect to a database” window, type MySQL in the search bar to filter drivers.
2. Choose the correct driver for your version:
   • MySQL 8 and later → select MySQL (the default driver).
   • MySQL 5.x → select MySQL 5.
   • MySQL 4.x or older → select MySQL (old).
3. Since your server is MySQL 8.0.41, choose the MySQL driver.

Step 3: Configure the connection details

After selecting the driver, click Next. On the Main tab of the Connection Settings screen, fill in the following:

Field	Value for your setup
Host	localhost or 127.0.0.1 (the MySQL server is on your machine)
Port	3306 (default – leave as is unless you changed it)
Database	Leave blank (to see all databases) or enter a specific database name
Username	Typically root for a fresh Ubuntu installation
Password	Enter the root password you set during MySQL installation

💡 Note: If you didn’t set a password and are using the default auth_socket plugin, you may need to connect as root without a password, or set one using sudo mysql and ALTER USER.

Step 4: Test and finish

1. Click the Test Connection button.
2. If DBeaver prompts to download the JDBC driver, confirm the download.
3. If the test is successful, you’ll see a confirmation message.
4. Click Finish to save the connection.

The new connection will appear in the Database Navigator panel on the left. You can now browse and manage your MySQL databases directly from DBeaver.

---

✅ Connection successful? Start exploring your data!

Note: Set password for "root" user before trying to access MySQL using DBeaver using above steps
Otherwise you will get the below error: