Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

MySQL Workbench - Connect to a Localhost

Tags:

mysql

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:

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
Sign in to Comment

Related questions

How to generate unique id in MySQL?
Check if mysql database exists, perform action based on result
Laravel 5.1 Migration and Seeding Cannot truncate a table referenced in a foreign key constraint
Mysql select distinct
Laravel: Get the ID of User::create and insert new row using that ID
How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?
File Storage for Web Applications: Filesystem vs DB vs NoSQL engines
MySQL: Select N rows, but with only unique values in one column
LINQ to MySQL - what is the best option?
Site has been hacked via SQL Injection
MySQL - TEXT vs CHAR and VARCHAR
MySQL concurrency, how does it work and do I need to handle it in my application
Migration Foreign Key Vs Eloquent Relationships in Laravel
DB Schema For Chats?
How to generate graphs and charts from mysql database in php [closed]
C# with MySQL INSERT parameters
How to use MySQL JDBC driver in an SBT Scala project?
MySQL storing duration time - datatype?
Inserting NULL into MySQL timestamp
What is the difference between MySQL's create index and alter add index?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!