Python mysql.connector - how am I supposed to use it? (Mac)

[Wictorian]

I really have no idea what I am supposed to do. I know I have to create a database first to run the code but no one talks about how. I have written the code but can't run it becasue I don'T know how to create the database.

 

[Thomas4]

Some answers here:

https://stackoverflow.com/questions/19808865/creating-sql-database-on-mac

[Slottr]

This would be easiest to do within Docker; I would highly suggest looking at creating a Docker container and setting up an SQL server & DB, and running your python program within.

[Takumidesh]

What have you tried?

What have you researched?

What code have you written?

 

What is the actual error you are receiving or functionality you are expecting?

 

Have you read the docs for mySQL?

Have you read any tutorials?

Have you watched any videos?

 

1 hour ago, Wictorian said:

no one talks about how.

You and I know this is not true. There are 5 million videos, articles, documents, and tutorials on how to create a mySQL database.

 

As a hint, The first thing that showed up on ddg when I searched for "Create a mysql database on mac" was a step by step guide, with pictures and detailed explanations on how to do what  you are asking.

[Wictorian]

11 hours ago, Thomas4 said:

Some answers here:

https://stackoverflow.com/questions/19808865/creating-sql-database-on-mac

There are no answers here.

[Wictorian]

10 hours ago, Takumidesh said:

What have you tried?

What have you researched?

What code have you written?

 

What is the actual error you are receiving or functionality you are expecting?

 

Have you read the docs for mySQL?

Have you read any tutorials?

Have you watched any videos?

 

You and I know this is not true. There are 5 million videos, articles, documents, and tutorials on how to create a mySQL database.

 

As a hint, The first thing that showed up on ddg when I searched for "Create a mysql database on mac" was a step by step guide, with pictures and detailed explanations on how to do what  you are asking.

Everyone talks about the code but when I run it I get error 61. Which I suppose means that database hasn’t been created. As far as I understand I should create the database outside the code first. And no one talks about that so far.

[C2dan88]

1 hour ago, Wictorian said:

And no one talks about that so far.

Who you referring to? Maybe the exercise presumes you already know mysql.?

 

You can create/manage your databases using the mysql command line. Or install mysql workbench for a gui.

https://www.mysqltutorial.org/mysql-create-database/

 

If you want to create a database using python's mysql connector. This guide explains

https://realpython.com/python-mysql/

[Wictorian]

36 minutes ago, C2dan88 said:

Who you referring to? Maybe the exercise presumes you already know mysql.?

 

You can create/manage your databases using the mysql command line. Or install mysql workbench for a gui.

https://www.mysqltutorial.org/mysql-create-database/

 

If you want to create a database using python's mysql connector. This guide explains

https://realpython.com/python-mysql/

I have trouble connecting to mysql server.

[wasab]

Your MySQL server is listening on port 3306 by default. Connect to it via 

mysql --protocol=TCP -u <username> -p

 

[C2dan88]

25 minutes ago, Wictorian said:

I have trouble connecting to mysql server.

Error 61 appears to be common error on mac. This guide may have a solution

https://ryansechrest.com/2015/08/cant-connect-to-mysql-server-on-127-0-0-1-61-on-mac/

[Wictorian]

44 minutes ago, wasab said:

Your MySQL server is listening on port 3306 by default. Connect to it via 

mysql --protocol=TCP -u <username> -p

 

What am I supposed to substitute username with?

I haven’t created users or anything.

And aren’t I supposed to create the server first?

[C2dan88]

17 minutes ago, Wictorian said:

I haven’t created users or anything.

Mysql's default username is root. With no password.

 

17 minutes ago, Wictorian said:

And aren’t I supposed to create the server first?

Mysql is the server. Have you actually installed mysql? And is it running?

[Akolyte]

4 hours ago, Wictorian said:

Everyone talks about the code but when I run it I get error 61. Which I suppose means that database hasn’t been created. As far as I understand I should create the database outside the code first. And no one talks about that so far.

Hey, so for context - here's how it works: 

 

You setup a mysql database or whatever database you're using.  This needs to be set-up as a server, and then you log into it and create a database.  You can create a user to access MySQL on the server you set up. 

 

The MySQL connector allows the Python application to access your MySQL database server and send queries to retrieve or post data.  

 

This makes the beginning of a 3-tier architecture to allow for scalability, it's quite old and probably won't be used outside of development but it's great to learn for sure as it leads onto more complex system decoupling. https://en.wikipedia.org/wiki/Multitier_architecture if you want to learn about it. 

 

Now, if you want to set-up the database - you have a couple of options:

• Set up one yourself, this could be in a virtual-machine or a docker container. https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04. You will need to set up a virtual machine using virtual box or something and connect to that btw, I wouldn't do this on your own machine unless it's in a container. 
• Rely on a Cloud Provider like AWS and set-up an RDS Database using the free-tier.   Remember that you'll have to make sure it falls within the free tier before you deploy it (I'm not responsible for any incurred costs of course), but if you're just creating your AWS account you should get 1 year of an RDS database running on a small EC2 instance for free. https://aws.amazon.com/premiumsupport/knowledge-center/free-tier-rds-launch/

Finally, make sure if you do opt to use the cloud option you secure your database by using strong credentials and setting your security group to only allow connections from your IP address (make sure /32 bit netmask). 

 

If this sounds complex to you, I'd take a course or follow a tutorial on setting up and using MySQL first so you can know what you're doing.   Taking a course on a cloud platform like AWS or GCP will be helpful as well so you can spin up development resources such as databases quickly. 

 

This site looks like a great starting point for the basics: https://www.tutorialspoint.com/mysql/index.htm if this does sound complex. 

 

[Takumidesh]

16 hours ago, Wictorian said:

Everyone talks about the code but when I run it I get error 61. Which I suppose means that database hasn’t been created. As far as I understand I should create the database outside the code first. And no one talks about that so far.

What code? what is giving that error? did you make the database? what do you mean no one talks about making a database?

 

some helpful tips on how to actually ask a technical question can be found here:

https://codeblog.jonskeet.uk/2010/08/29/writing-the-perfect-question/

https://stackoverflow.com/help/how-to-ask

 

 

What about all the other questions I asked? if you elaborate more, demonstrate the research you did, give code examples, etc. people can help you more.

 

Did you read the mysql docs where they tell you explicitly how to setup a mysql database on several operating systems in detail? did you put any effort into actually solving the problem?

 

I, just now, literally typed into google "how to create a mysql database" and the very first result is the official docs detailing exactly how to do it. did you read those?

 

You are saying the mystical 'nobody' is talking about how to do this, yet it is literally the first result that comes up, straight from the horses mouth.

 

once again... did you read any of the official documentation at all?

 

 

[Wictorian]

20 hours ago, Takumidesh said:

What code? what is giving that error? did you make the database? what do you mean no one talks about making a database?

 

some helpful tips on how to actually ask a technical question can be found here:

https://codeblog.jonskeet.uk/2010/08/29/writing-the-perfect-question/

https://stackoverflow.com/help/how-to-ask

 

 

What about all the other questions I asked? if you elaborate more, demonstrate the research you did, give code examples, etc. people can help you more.

 

Did you read the mysql docs where they tell you explicitly how to setup a mysql database on several operating systems in detail? did you put any effort into actually solving the problem?

 

I, just now, literally typed into google "how to create a mysql database" and the very first result is the official docs detailing exactly how to do it. did you read those?

 

You are saying the mystical 'nobody' is talking about how to do this, yet it is literally the first result that comes up, straight from the horses mouth.

 

once again... did you read any of the official documentation at all?

 

 

Yeah I read the docs and it doesn't talk about creating the server. By database I meant the server. Sorry for confusion.

[wasab]

8 hours ago, Wictorian said:

Yeah I read the docs and it doesn't talk about creating the server. By database I meant the server. Sorry for confusion.

creating a sql server involves just you installing the database and then running it. if you dont like writing sql commands, you can just create some migration code in python to create the schema and tables, maybe also seed them with some initial rows if you want. 

[hirushaadi]

On 10/21/2022 at 11:53 PM, Wictorian said:

I really have no idea what I am supposed to do. I know I have to create a database first to run the code but no one talks about how. I have written the code but can't run it becasue I don'T know how to create the database.

 

you need a DataBase Management System, once you install and setup one, you can create run normal sql commands and create stuff. you can get started by installing something like PostgreSQL or MySQL

 

you can run this to create your database named "mydatabase"

CREATE DATABASE mydatabase;

 

and this is how you use mysql connector in python to connect to that database

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="mydatabase"
)

you can read the docs here: https://dev.mysql.com/doc/connector-python/en/

you can refer this part of the documentation to create a table