It gives you access to the latest version of MySQL and its functions.

Mysql-connector-python is the official python connector developed by MySQL and uses Python database API v2.0 specification. Running MySQL queries with mysql-connector-python If not, you can get that through the connectors. You might already know your database name. If you are using jupyter, you can use the %env 'magic' command, like so: %env export mysqlhost= You can do this via the terminal, like so: export mysqlhost= The better option at this stage is to save them as environment variables. Then suddenly you have credentials in the wild, and you have to go through a whole rigamarole to fix it. But if you build out the analysis into something useful, at some point you're probably going to commit it to version control. If you like living dangerously, you can just store them as variables in the file. Now that we have each of these creds, we need to store them. In AWS, this means setting your database to ‘publicly accessible’ and configuring a security group that allows incoming traffic from your IP address. Normally access to cloud databases is pretty locked down, so there’s a high likelihood you’ll also have to configure some security/accessibility settings to access your data. The username is available by going to Databases → Configuration under ‘Master username.’ You can’t see your password, but you can reset it by going to Databases → Modify and changing it there (make sure to ‘Apply Immediately’ otherwise you might be waiting days for the update to take effect). The username and password are configurable when you set up your instance. For the host address, it’s visible in the control panel for the database: MySQL host address in RDS In this scenario, we are using a MySQL database on an AWS RDS instance (so YMMV). Where to find this information will be different for different cloud providers. Sometimes this will default to ‘user’ or ‘admin.’ The username of the account to connect with. If you were working on a local instance of MySQL, this would be ‘localhost.’ For production databases, this is more likely to be the endpoint URL of the instance in a data center, such as ‘ .’ Getting the credentials for your MySQL databaseįirstly, to connect using either method you are going to need these credentials from your MySQL database: Use sqlalchemy when you want to run deeper analysis as it plays nicer with Pandas Use mysql-connector-python when you are just looking to run some quick queries There are two main ways you can connect to MySQL in Python. It’s still the most popular database on the 2022 Stack Overflow Developer Survey and counts Facebook, Twitter, YouTube, and Netflix among its users.

If you have spurned the latest NoSQL or serverless databases and continued to use the well-trod tables of MySQL for your production db, you’re in good company.

Mysql vs sql connection