From the course: Advanced Python: Practical Database Examples

Unlock the full course today

Join today to access over 24,500 courses taught by industry experts.

Create a MySQL database

Create a MySQL database

- [Instructor] Let's install and configure the tools to create a MySQL database. If you don't already have MySQL installed you can download it from this website. I already have it installed, so I won't be installing it but this would be the place to go to install it. Once it's installed, the path needs to be updated so we can use the MySQL Shell in the command line. This will be different if you're on a Windows computer but on a Mac you can use what type of shell you're running to determine where to update the path. We'll use echo SHELL to find out which shell we're running. In this case, ours is bin/zsh. This means we'll need to update our .zshrc file in our home directory. We can navigate to our home with cd tilde. Then we'll open up the file with nano dot zshrc. Inside of here, we have two entries that tell our shell where MySQL is located. We have the MySQL bin and MySQL support files. We add these to our path so we…

Contents