MySQL Workbench - Connect to a Localhost

Question

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

User · Answer

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/

User · Answer

if you are using localhost database  try port 3306

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

If xamp already installed on your computer user these settings

User · Answer

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

[mysql] MySQL Workbench - Connect to a Localhost

Examples related to mysql

Examples related to mysql-workbench