How to connect Python to MySQL Workbench


Step-by-Step Guide


1) Download MySQL:

Download MySQL Installer (For Windows only!)

Begin download



For Windows users...

2) How to setup MySQL Installer

  • We are going to show how to download and install MySQL Community Server only...
    • Double click the file and install it
    • Once it has finished installing, you will see this window below and click on the 'Add' option
Click 'Add' option
    • Agree on their License terms and click 'next'
Agree on License Terms

    • Select the Product that you want to install
Select Product

    • Execute the installation and wait for it...Then click 'Next'
Execute the Installation


    • Once the installation is completed, you will see the product configuration page
Product Configuration



    • Select the type of MySQL server  you want then click 'Next'
Select MySQL Server

    • Select the Server Configuration Type
Select the Server Configuration Type

    • Select the Authentication Method and then click 'Next'
Select the Authentication Method 

    • Create new user account and assign a role to the user. Otherwise, you can just key in a new MySQL Root Password and click 'Next'
Create New User Account

    • Configure MySQL Server as a Windows Server. Change the default name if you want and select what account you would like it to run as. Then click 'Next'
Configure MySQL Server as a Windows Server.



    • Last, apply the configuration! Once it's done, click 'Finish'

Apply the Configuration


3) Launch MySQL Workbench

  • Add a new MySQL connection as follows:
Add a new MySQL connection

  • Setup the new connection. Then click 'Test Connection' and enter the root password
Setup the new connection

  • If the connection is successful, you should see the following message. Then click 'OK'
Successful Connection Message

  • Open the new connection
Open the new connection

  • Create a new Schema and name it! Click 'Apply'
Create a new Schema


4) Connect Python to MySQL Database 

  • In the command prompt, key in the following command with the right input 

import mysql.connector cnn = mysql.connector.connect(user='<your input>', password='<your input>',
host='127.0.0.1', database='<your input>') cnn.close()

Comments

Post a Comment

Popular posts from this blog

Predict EPL results (Part 2: Neural Network example)

Image
Neural Network explained Artificial Neural Network is a model that receives input in vector/matrix form and uses them to compute the output  It is made up of 3 different layers namely input layer, hidden layer and output layer.  Each layer is made up of 1 or more artificial neurons (aka nodes)  The nodes are interconnected with one another Each node is assigned to a weight value denoted by  w  that determines how much emphasis is given to the learned information extracted from the raw training data  Note: A   Neural Network with 1 hidden layer is known as  Shallow Neural Network Types of Neural Networks Feedforward Neural Network Convolutional Neural Network (CNN) Recurrent Neural Network - Long Short Term Memory (LSTM) Networks Recursive Neural Network Neural Network Architecture The figure below shows a  Neural Network Architecture  that is made up of n  features,  h  hidden layers and ...
Read more

Bias and Variance in Machine Learning

Sorry for the lack of updates...Have been rushing to complete the Machine Learning course as fast as possible... Good news!!! We managed to survive through the whole course!!!! Hahaha Summary of Week 6 lesson: Some definitions first before delving into the details... Bias:  The hypothesis is known to be biased if it tends to overestimate or underestimate a parameter Variance:  The hypothesis is known to have high variance if the data are far away from its average value Given the complexity of some data, a linear regression may not be able to formulate an accurate prediction. As the linear regression only factors in 1 specific feature of the data, the 'best-fit' line does not fit the data well enough. Such under-fitting problem leads to high training costs and also causes the hypothesis to be biased. Ways to reduce the bias: Add more features / Increase the degree of the polynomial Decrease λ  Use larger neural network As mentioned a...
Read more