MySQL Workbench Tutorial

[@murgraydj5812]

This video is fantastic! So clear, concise, and thorough. Sincerely appreciate it!

[@DatabaseStar]

Glad it was helpful!

[@UyenNguyen-ds9pi]

I'm just starting to learn SQL and this rly helps acquaint me with the tool. Thank you !

[@DatabaseStar]

Great to hear!

[@aog2742]

Thank you so much for making this video. I was desperate to find myself being the only kid using macOS in my class. And all the tutorials from the teacher are on a Windows os. Luckily, I've got this! Cheers mate.

[@DatabaseStar]

Awesome, glad I could help!

[@AliAliOxenFree]

clear and concise. thank you for this, sir! i'll be revisiting this video often, i can tell

[@DatabaseStar]

Glad it was helpful!

[@pugazhenthimanoharan327]

That was really precise and useful to know when you're starting to work in MySQL workbench, Thanks!

[@DatabaseStar]

Glad it was helpful!

[@danielsehnoutek2016]

Amazing tutorial, both this and also for the SQL Database installation, because everything is simply working :D

[@DatabaseStar]

Thanks! Glad it's working for you.

[@someuser4166]

Thank you. I used to use mysqlYog but moved over to Linux and thus needed something new, this was very helpful. I haven't watched the full video yet but I hope this program has the ability to export your databases as sql quarries for backups 🤔 Also a bit of a side note but do you know of any reputable mysql clients on Android? Nothing fancy, I just want to be able to quickly review the information when I'm out and about. 🤔

[@DatabaseStar]

Glad you liked it. Yes I believe it can export to both formats. I don’t know any clients for android as I’ve never used sql on an android

[@9785633425657]

Thanks a lot for this video. I need to do the project for my studies and this is helping me a lot!😀

[@DatabaseStar]

Glad it was helpful!

[@jakobdonathellmann7192]

perfect start with mysql workbench, thank you!

[@DatabaseStar]

You're welcome!

[@violettracey]

Thank you so much!

[@DatabaseStar]

You're welcome!

[@anthonycarella1779]

MySQL Workbench is so unintuitive and frustrating to work with. Thanks for making a video to make it a bit easier.

[@DatabaseStar]

Yeah it can be tough to get things done.

[@meenachisundaram4816]

It helped me. watched your videos those are awesome. Thanks for sharing!😎

[@DatabaseStar]

Glad to help!

[@andreasansa6569]

Very clear!!

[@DatabaseStar]

Glad it was helpful!

[@ashwanth9981]

Nice vid! So how to work on connecting the database to some python code that we wrote in our system? Say coding a login or logout page using python which uses database.

[@DatabaseStar]

Thanks! Good question. I don’t have python experience but you would need to create a connection to the database in your code somewhere. Then use that connection to run your queries on the database (such as select user details, or insert into login history table)

[@ashwanth9981]

@@DatabaseStar OK thanks!

[@sannivalimaki7463]

This video was so helpful! Thank you so much

[@DatabaseStar]

Glad it was helpful!

[@bbulliard]

Very, very well done! I really enjoyed your video. thank you...Bob👍

[@DatabaseStar]

Thanks, I’m glad you liked it!

[@horizonariondust576]

Thank you so much for this detailed and clear instruction! It helps a lot! 😁

[@DatabaseStar]

Glad it was helpful!

[@user-yk8dq1st2k]

Thank you so much for such a detailed explanation❤

[@DatabaseStar]

Thanks, glad you liked it!

[@name1927]

This is a great tutorial clip.

[@DatabaseStar]

Thanks!

[@GD-my5hm]

Fantastic tutorial.

[@DatabaseStar]

Thanks!

[@trieutruong2410]

Hello there, thank you for your sharing, such a great thing. I have a question please. Is there any chance to set the Light theme for MySQL Workbench since I still want to keep the Dark theme from system perspective. I just googled around but had no luck.

[@DatabaseStar]

No problem! Not that I know of, I've only ever used the light theme.

[@thomashart5081]

For some reason on my Mac workbench works fine but the output bar isn’t showing actions but I can copy actions. How do I get action to be displayed on the bar between time and response?

[@DatabaseStar]

Oh that's strange. Which MySQL Workbench version are you using? Is there a menu option to show actions?

[@thomashart5081]

The latest Mac version I think 8.0.39. I’m also finding on here it only shows command words in a changed tone of grey not blue which is not helpful and can’t find options to resolve the query display

[@merry1195]

Why your key words color is blue,mine is gray. How could I switch to blue ?

[@DatabaseStar]

Oh I’m not sure, I’ve only ever seen it blue. Perhaps it’s a setting in Preferences.

[@abdurrahmanaltunay]

Hi there! Bottom right corner of the Result Grid, I can only see 'Read Only'. I don't have Apply and Revert. How do I find it, I want to change data from the result panel? Thanks for the help.

[@DatabaseStar]

I think it's because you haven't selected the primary key in your query, so MySQL Workbench can't work out which row you want to edit.

[@Lennings82]

hi. i wonder is it possible to kinda put a folder in where all the tables are? to make it more organized? and also, i get an error if i remove all the records in the table. i wonder if its something i need to set, that allows a table to be empty. or maybe i just don't need to care about the error. .

[@DatabaseStar]

Good question about the folder for tables! I'm not aware of this feature but I can look into it. Which error are you getting when you remove records? Is it something about a foreign key or parent records?

[@Lennings82]

@@DatabaseStar i cant send a picture on it. But here is the text: "MySQL Workbench has encountered a problem Value of '0' is not valid for 'RowCount'. 'RowCount' must be greater than or equal to 1. Parameter name: RowCount We are sorry for the inconvenience but an unexpected exception has been raised by one of the MySQL Workbench modules. In order to fix this issue we would kindly ask you to file a bug report. You can do that by pressing the [Report Bug] button below. Please make sure to include a detailed description of your actions that lead to this problem. Thanks a lot for taking the time to help us improve MySQL Workbench! The MySQL Workbench Team "

[@user-ty7ze6nm5o]

How to disable UPDATE option in MySQL workbench for mac... I can't find the PREFERENCE option in it.

[@DatabaseStar]

Do you mean disable updates for users? I don’t think this is a workbench setting. I think it can be done with user privileges.

[@vivekkumarmishra2433]

what is the function of the tools tab in the workbench.... Please provide details

[@DatabaseStar]

There are a range of features of Workbench that it gives you access to.

[@diplodocus3]

I'm on mac silicon and the IDE keeps crashing when running the SELECT statement 10:14 ?? I dropped the schema and tried again, still crashing! Frustrated!

[@DatabaseStar]

I actually just got an email from someone today with this same issue. I think it’s an issue with the latest version of Workbench (32 I believe). If you try a previous version, that may work.

[@diplodocus3]

@@DatabaseStar Thanks! Will try

[@diplodocus3]

@@DatabaseStar Yup, older (31) worked fine, thanks!

[@filipemotapinto2834]

wrong instructions???... I've done everything, and ir didn't worked! therefore I needed to previously install mySQLSERVER and also mySQL connections....

[@DatabaseStar]

What issue are you having? Which instructions are you referring to?

[@user-wd6bl2pd9g]

10/10

[@DatabaseStar]

Thanks!

[@magicaxel2000]

why schools can't exlpain this much in a 3h class?

[@DatabaseStar]

That's a shame the school doesn't teach you this stuff, but glad you like the video!

[@adityapawar1337]

WHAT ACCENT DOES HE HAVE?

[@DatabaseStar]

It’s an Australian accent 🇦🇺 😊