Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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!

like image 450
scapegoat17 Avatar asked Dec 06 '13 18:12

scapegoat17


People also ask

How do I access MySQL localhost?

Enter 127.0. 0.1 for the host. The default username for a new MySQL installation is root, with a blank password. You can leave the port field blank unless your server uses a different port than 3306.

Why can I not connect to localhost MySQL?

normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.


2 Answers

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.

like image 196
James Smith Avatar answered Sep 21 '22 09:09

James Smith


Its Worked for me on Windows

First i installed and started XAMPP Control Panel enter image description here

Clicked for Start under Actions for MySQL. And below is my Configuration for MySQL (MySQL Workbench 8.0 CE) Connections enter image description here And it got connected with Test DataBase

like image 31
Dharmendra Prajapati Avatar answered Sep 19 '22 09:09

Dharmendra Prajapati