MySQL Workbench: Connection Creation and Trouble Shooting (for beginners)

This video shows how to create connections in MySQL Workbench and what to do if problems arise with that.

Please subscribe to the MySQL Youtube channel:

Like our MySQL Facebook page:

Follow us on Twitter at:

[njun]

After running about for ages on the net trying to figure out why I couldn't get a connection, this was such a wonderful resource to come across. Why can't everything be like this.

[CAMILA-drii]

How can I stablish a connection using Mysql Workbench between differents LAN networks?

[beyzaaktepe]

Hello, good evening, I want to ask you a question
I downloaded MySQL Workbench and for the first time I thought that when creating the database, I would have to save my password and constantly write it in case I forget my password
But then I had to change my password to work with a different database and since my password was registered in the system and I entered the automatic system, I couldn't change my password when I needed to access the existing database
For this reason I don't know how to change my password
Can you help me change the password and when I create a local host with my password still registered, it does not ask me for my password when logging in and I need to solve this problem.
Could you help me?


At the same time, when I directly enter the codes of the existing data from the local host, when I create a new table and say apply, and then when I write these codes, I say apply again and it gives me an error, that is, it says connection error to the database and I could not solve this situation, whatever I do, do you have suggestions?
Thank you so much :(((

[mercantilism]

I wish you could have mentioned that MYSQL server must be installed to use workbench

[KoljaMineralka]

Is there a way to add new connection in workbench using CLI/CMD for automation ?

[chatradhinaveenkrishna]

hi, i am following the lecturer on sql workbench i am new to this and find difficulty in establishing connection . I tried what you mentioned in the video and its keeping n asking me password .
can you help me

[kensleylewis]

MySQL workbench crashes on me when I attempt to delete a specific connection. What other things should I try to do, to remove that specific connection from MySQL workbench than the obvious approach of clicking the delete button in the UI? Many Thanks!

[melissagriggs]

Right from the a new connection I get "failed to connect with user root" "unable to connect to local host" immediately after creating a new connection. Worked fine several days ago, now nothing works. Changed the port and the root password. Any ideas? Any help would be greatly appreciated.
Workbench 8.0 Windows 10

[luppo]

I have installed XAMPP with Mariadb on it, so how to connect Workbench with it???All the time getting notice "Failed to Connect to MySQL at 127.0.0.1:3306 with user root"!Please, help

[manuelaraica]

To connect to a remote server DB, can I use Workbench community or the standard version ?

[paih_paan]

hi, i create the mysql workbrench in the window 2008 server. i do my code html and php in the window 10, how i want to connect both of them? please help me

[MrJeffersonDias]

also when i type a code and hit execute it says error during execute query into text output.. and below theres always a message saying could not connect, server may not be running..

[as]

how did u creat the vault connection on the remote server??

[nouher]

Thanks, your video helped me resolve my 3306 connection issue

[journeytothedream]

I cannot find the schema panel on my mysql workbench. How do I resolve that

[theofficialbakait]

Can you please make a video on how to connect mysql to IBM i DB2

[joemagweregwede]

When i downloaded the MySQL i was not given a choice to choose a server, is there a way i can connect to the nearest server

[prakashthakur]

I am getting an error read as ****

Connecting to MySQL server My Service ...
Lost connection to MySQL server at 'reading initial communication packet', system error: 0

what should i do?

[manan]

5:20 workbench said, I think not.
2019-06-06 17:58:06 - Workbench will use cmd shell commands to start/stop this instance
2019-06-06 17:58:06 - Checking server status...
2019-06-06 17:58:06 - Trying to connect to MySQL...
2019-06-06 17:58:06 - Can't connect to MySQL server on '127.0.0.1' (10061) (2003)
2019-06-06 17:58:06 - Assuming server is not running

[age_of_reason]

This is not a troubleshooter at all and it is not for beginners. If it was for beginners the first thing you should have shown is a diagram of all the parts involved with explanation of what they are, how they work and how they are related to the program. You are either too advanced or you don't really understand what the word 'beginner' means. This video didn't help me or mostly anyone as the comments will show. I watched the entire video and I still don't have a clue as to why I am getting the error "Failed to Connect MySQL at 127.0.0.1:3306".