Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: databasestar.mykajabi.com/lpkj-timesaver-mysql-wb/?
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.
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. 🤔
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!
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.
I followed it by I got error message after I test connection saying that.. Failed to connect to mySQL 127.0.0.1 with user root? Did i missed something i follow every details since the 1st minute thank you.
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.
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?
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
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. .
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?
@@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 "
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.
wrong instructions???... I've done everything, and ir didn't worked! therefore I needed to previously install mySQLSERVER and also mySQL connections....
Do you want to save time while using MySQL Workbench? Get my Timesaver Guide to MySQL Workbench here: databasestar.mykajabi.com/lpkj-timesaver-mysql-wb/?
This video is fantastic! So clear, concise, and thorough. Sincerely appreciate it!
Glad it was helpful!
I'm just starting to learn SQL and this rly helps acquaint me with the tool. Thank you !
Great to hear!
That was really precise and useful to know when you're starting to work in MySQL workbench, Thanks!
Glad it was helpful!
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.
Awesome, glad I could help!
Amazing tutorial, both this and also for the SQL Database installation, because everything is simply working :D
Thanks! Glad it's working for you.
clear and concise. thank you for this, sir! i'll be revisiting this video often, i can tell
Glad it was helpful!
MySQL Workbench is so unintuitive and frustrating to work with. Thanks for making a video to make it a bit easier.
Yeah it can be tough to get things done.
perfect start with mysql workbench, thank you!
You're welcome!
Thanks a lot for this video. I need to do the project for my studies and this is helping me a lot!😀
Glad it was helpful!
Thank you so much, perfect explanation. Greetings from Colombia 💛💙❤
Glad you liked it!
It helped me. watched your videos those are awesome. Thanks for sharing!😎
Glad to help!
This video was so helpful! Thank you so much
Glad it was helpful!
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. 🤔
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
hi thank you so much for this video really helped a ton, where can i find sample databases to work with just like the one u have eg netflix
You're welcome! I've got a range of sample databases on my website: www.databasestar.com/sample-data-sql/
Very, very well done! I really enjoyed your video. thank you...Bob👍
Thanks, I’m glad you liked it!
Thank you so much for such a detailed explanation❤
Thanks, glad you liked it!
This is a great tutorial clip.
Thanks!
Fantastic tutorial.
Thanks!
Very clear!!
Glad it was helpful!
Thank you so much for this detailed and clear instruction! It helps a lot! 😁
Glad it was helpful!
Thank you so much!
You're welcome!
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!
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.
@@DatabaseStar Thanks! Will try
@@DatabaseStar Yup, older (31) worked fine, thanks!
I followed it by I got error message after I test connection saying that..
Failed to connect to mySQL 127.0.0.1 with user root?
Did i missed something i follow every details since the 1st minute
thank you.
Do you have a MySQL database installed? If so, did you enter the correct password?
I have a problem with connecting the database."Failed to connect to MYSQL at 127.0.0.1:3306 with user root".
Do you have a MySQL database running? If so, perhaps the password is wrong.
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.
No problem! Not that I know of, I've only ever used the light theme.
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?
Oh that's strange. Which MySQL Workbench version are you using? Is there a menu option to show actions?
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
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.
.
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?
@@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
"
what to do if there is an Access denied for user 'root'@localhost using password: No error ?
It could be because the password is incorrect, or the database server is not running, or perhaps the password is case sensitive.
what is the function of the tools tab in the workbench.... Please provide details
There are a range of features of Workbench that it gives you access to.
How to disable UPDATE option in MySQL workbench for mac... I can't find the PREFERENCE option in it.
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.
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.
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.
"Failed to connect" How can i fix this problem please ?
Is MySQL running? Have you used the correct username and password? Is the port correct?
Why your key words color is blue,mine is gray. How could I switch to blue ?
Oh I’m not sure, I’ve only ever seen it blue. Perhaps it’s a setting in Preferences.
good
Thanks!
wrong instructions???... I've done everything, and ir didn't worked! therefore I needed to previously install mySQLSERVER and also mySQL connections....
What issue are you having? Which instructions are you referring to?
10/10
Thanks!
why schools can't exlpain this much in a 3h class?
That's a shame the school doesn't teach you this stuff, but glad you like the video!
WHAT ACCENT DOES HE HAVE?
It’s an Australian accent 🇦🇺 😊
@@DatabaseStar
G'day, mate. 😊