Reputation: 5841

MySQL Workbench - Connect to a Localhost

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:

MySQL home page

And if I try to make a connection myself it shows this: enter image description here

Any help would be much appreciated - thanks!

Upvotes: 53

Answers (11)

Rahul Raj

Reputation: 1

services->mysql (on left corner click on start)

Upvotes: -1

Manthan Kurhekar

Reputation: 1

Install MySQL installer.
Select Add... from the right side and install the latest version of MySQL server.

I hope this will work. It worked for me. Thank You.

Upvotes: 0

MassDev

Reputation: 61

Solution:

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

Now, try again!👍

Upvotes: 6

Chitransh Agarwal

Reputation: 301

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.

Upvotes: 30

hossam ibrahem

Reputation: 11

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

Upvotes: 0

Deepak

Reputation: 707

You need to install mysql server for your machine first. Once done, you will be able to add local db details to it.

For e.g. IP: 127.0.0.1
port: 3306
user: root
pass: pass of root which you have set

Here is the link on step by step guide for linux.

https://support.rackspace.com/how-to/install-mysql-server-on-the-ubuntu-operating-system/

Upvotes: 0

Dharmendra Prajapati

Reputation: 483

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 And it got connected with Test DataBase

Upvotes: 4

ContexDev

Reputation: 1

if you are using localhost database, try port 3306

Upvotes: -2

user4825230

Reputation: 1

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

Upvotes: 0