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.
//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:
- 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!👍
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