Unable to connect to localhost mysql workbench

I just installed MySQL Workbench and there are no connections available for my localhost server. When I try to make one, I get an error popup. Has anyone experienced something like this before and would be able to help me out?

Here is what it looks like on start up:

And if I try to make a connection myself it shows this:

Any help would be much appreciated - thanks!

Anil

2,5336 gold badges32 silver badges41 bronze badges

asked Dec 6, 2013 at 18:55

scapegoat17scapegoat17

5,23513 gold badges53 silver badges88 bronze badges

3

Sounds like you only installed the MySQL Client Tools (MySQL Workbench). You have to install the MySQL Database server, configure and start it.

http://dev.mysql.com/downloads/

You probably want the MySQL Community Server download.

answered Dec 6, 2013 at 19:02

James SmithJames Smith

1,0121 gold badge11 silver badges13 bronze badges

5

For Win users:

Check if the MYSQL service is running or not. To check the service is running or not. Use the below steps:

• Step1: Open the Services Desktop app from the Windows menu.

• Step 2: Then search the list of services to identify the name of the MySQL service.
• Step 3: Right-click on the service name to open the menu.
• Step 4: Start the service if it is not running.

ino

2,1591 gold badge14 silver badges26 bronze badges

answered Jan 30 at 10:45

1

Its Worked for me on Windows

First i installed and started XAMPP Control Panel

Clicked for Start under Actions for MySQL. And below is my Configuration for MySQL (MySQL Workbench 8.0 CE) Connections

answered Apr 1, 2019 at 7:41

If xamp already installed on your computer user these settings

answered Dec 17, 2014 at 6:10

UMAIR ALIUMAIR ALI

9755 gold badges13 silver badges25 bronze badges

1

Solution:

1. Open up your mysql installer.
2. Click on Reconfigure, shown in red.
3. In that, Click on next until you enter the Accounts and Roles tab.
4. Create a password and then, click next for the rest of the tabs.

Now, try again!👍

ino

2,1591 gold badge14 silver badges26 bronze badges

answered Apr 16, 2021 at 6:14

I had this problem and I just realized that if in the server you see the user in the menu SERVER -> USERS AND PRIVILEGES and find the user who has % as HOSTNAME, you can use it instead the root user.

That's all

answered Apr 23, 2015 at 16:33

if you are using localhost database, try port 3306

answered Apr 1, 2018 at 16:08

0

enter image description here

I think you want to config your database server firstly after the installation, as shown in picture, you can reconfigure MySql server

answered Jan 28, 2021 at 20:45

How do I connect to a local host in MySQL Workbench?

How do I fix MySQL Workbench connection?

Can't connect to local MySQL server on localhost?

How does MySQL Workbench connect to local SQL server?