Installing MySQL and the Workbench

John Purcell
A free video tutorial from John Purcell
Software Development Trainer
4.4 instructor rating • 17 courses • 2,257,312 students

Learn more from the full course

MySQL, SQL and Stored Procedures from Beginner to Advanced

A beginners' guide to MySQL queries, database design, transactions and stored procedures.

18:16:46 of on-demand video • Updated May 2016

  • Create, query and update databases
  • Use triggers, views and stored procedures
  • Understand transactions and database isolation levels.
  • Understand database users and security.
English Hello this is John from Cave of programming dot com and this tutorial can unlock what you need to install to get started with this tutorial. So I mean Google here and for reasons that I don't fully understand or got on Garion version of Google . But the first thing we need to install is that my sequel community server says free database which you can install and which will sort of enable you to create tables and store data in there and do all kinds of things like that. So if you search for them my seek community server. Just go to the download link and most of the time all you have to do is select your operating system download the right installer and just run it like any normal installation program. Let's just click this download link. They do have this slightly sneaky thing where they try to get you to create an account but at the moment at least they also give you this no fans to start my download option here. So you can do that. So download the version for your operating system and install it. They have versions for for Linux for Windows I'm using Mac but you can install it on more or less any reasonable desktop computer. If the installation program asks you to enter a password for your route to use which is as we'll see later on this is the use of that will be connecting us initially. It's really important that you that you remember the password that you entered. It's very important but it might just not ask you this installation program used to be a bit flaky and a long time ago that didn't even used to be a program but now usually that installers for the various platforms they all pretty much work out in a box. If you do run into any problems then we'll make sure you are running the installer and not as it download . And don't be afraid to call for further information if you have to. I can't show you the installation of your platform because it depends on your platform and it even depends on the version of my sequel and the version of the installer. But if you run into any problems. Don't be afraid to google for that. I can can't install my Seacole Windows 7 or whatever. And if any error messages come up don't be afraid to copy losen or just type them out paste them into Google do a search and see what comes of that because probably other people have encountered your problem as well. If you have a problem if you really get stuck with this you can just search for online. My c call database or something like that and you will find versions that you can use on the Internet and some of these are just meant for learning my sequel and others require you to create a count and maybe create a database with a few clicks and possibly even pay what you can find various free versions on here that you can use to practice a sequel. If you really run into problems now in this tutorial will focus on using the my school work package which is another free tools they also need to install the file system search for my school work and go to that and install that. So again all the same things apply is probably going to install pretty smoothly if you run into any problems. Don't be afraid to Google if you if you want to use an on line. My sequel database instead should be no problem because we won't be getting too tied up with Workbench here. I'm going to focus on learning my sequel of the saw. It also tied on a command line if you wanted to but this is a really handy tool to have because it just makes it much easier and nicer to work with my simple database when you've installed it. You you all one you probably have a choice between running to my sequel's server when you when your operating system starts up when your computer starts which is the easiest option. That's going to run your actual database self when it starts and then you can start my sequel workbench to connect to it. Or you can opt to start it via some kind of tool that they supply you with. So for example in my Mac here if I go to my Mac system preferences I've got my C core administration tool and so I'm going to not have install this. I once thought my sequel. I can click start my SQL Server and I just go into my operating system password. Stop usually started pretty smoothly. Might get someone to restart your computer or have any problems. Then when he'd done that he should be able to run my sequel workbench. Let's try to run that and should be able to open a connection. So this is how it looks and the moment it does change from version to version. But you should be able to figure out how to create a new connection. I created one already here. Create a new one. Click the plus sign by my secret connections. This could be slightly different in your version and if so it pre-filled in the details here. I didn't set a password. My username route which is the default. This hostname means basically just the computer word in my sequel's server. The database itself is running through 3 0 6 is the default pool for my sequel's So then I can click test connection and it says successfully made my secret connection. So you want to get to that point where you can see that your. My sequel workbench can successfully connect to your server. Don't forget you might have to start your server. Fire Control Panel or my preferences or whatever you are using. If you didn't select target start when you start your computer when you installed it. OK so that's it for this tutorial. Good luck with that. As I said if you run into any problems Google it and as a last resort you can use just an online sequel database to follow this tutorial and in the next tutorial will look. Actually setting up a connection and issuing commands. So until next time happy coding