![]() ![]() And at least for our purposes here, we want to use the Strong Password Encryption, so that we can use it. And I get this choice: Use Strong Password Encryption or Use Legacy Password Encryption. This is the password for my computer that I'm installing this on. We're going to have different passwords involved in this process so I just want to be clear. I'm going to type the password for my computer here. So I press Continue, and I press Continue, and I accept the license agreement which I have not read. And if you've installed anything on your Mac, most of this is very familiar. I opened up this DMG file and I get a Mac installation package, a pkg file, and so I'll double-click on that, and I get this little warning that's going to run a program to determine et cetera. It's the exact same process for downloading both of them. And I've also downloaded the MySQL Workbench. And so, I've already downloaded that onto my desktop here and it's right here. And you notice that when I hover over that, I get the DMG file. You just press No thanks, just start my download. If you do that, you're going to get a ton of email, most of it asking you to spend money on stuff you don't need so I didn't do that. And when you press Download, you get yet another page and this page asks you to login or just sign up. When you click on this, you'll see, you'll get a page with a bunch of stuff, and then down here, have an operating system selected, in this case, macOS because I'm doing this on a Mac, and you'll have a bunch of different choices here. ![]() And so, I've already download both of these to my desktop, but I just want to run you though this really quickly. MySQL Community Server and then farther along down, MySQL Workbench. So down here under the MySQL Community Downloads, we'll notice a couple of items. The Community edition is free and it doesn't cost anything at all. See, Enterprise edition cost money and if you're not running an enterprise, we're just running this for yourself, and in this case, we're just using this for development, and really just for learning so the Community edition is exactly what we want. Significantly, the Enterprise and Community editions. Now, there's several different editions of MySQL. And so, we have the MySQL Community Downloads. And I've got DOWNLOADS here selected and Community selected. So here I have /downloads and I've loaded this up in my browser. So I'm going to press Command + Q to quit the System Preferences, and now we'll go ahead, and download MySQL from the website. If MySQL Server was running on this computer, there would be a little highlight around one of these items for the MySQL panel, but we don't have that, and so MySQL Server is not running on this computer. and you'll notice that nothing is highlighted here in the System Preferences. First, we need to confirm that we're not already running MySQL Server on this computer. The process should be the same on any modern version of macOS. We’ll see it in a separate tutorial.We'll install the MySQL Server on a Mac running macOS. Note that we are connected using the root user, which should only be used for administration purposes.ĭay to day use of a database should be done using a normal user. Then set a name for the connection, and enter “root” and the password you set previously:Ĭlick Connect, and you should be connected to MySQL! I know there are macOS, Windows and Linux versions.Ĭlick “Create a new connection…” and select MySQL in the list: It comes with a free trial that’s perfect for our usage, because it’s not time-based but rather it limits the amount of concurrent connections you can make to the database.ĭownload it from. You will need to type the root user password after you run this command, and once you are done you should see this screen:Ī great GUI (graphical) software we can use to interact with a SQLite database is TablePlus. Now you can connect to the server using the command: mysql -u root -p It’s up to you to decide which one you prefer. This will start MySQL and will keep it running until the computer is shut down, or until you run: rver stop You can also avoid this daemon mode (that’s what we call programs that always run in the background and restart when the computer is restarted) by running: rver start To stop this from happening, and also to immediately stop MySQL. Since we used brew services start mysql to start MySQL, your Mac will re-start it at reboot. The procedure can take a while, but it gives a lot of power to make sure you get the best defaults out of the box: By default the server comes without a root password, so we need to make sure it’s protected. You can now start the MySQL server by running: brew services start mysql The above command should take a while, then print something like this: On macOS, you can install MySQL easily using Homebrew. Step by step instructions to install MySQL on macOS using Homebrew ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |