I would like to share how to connect MySQL by using Python script.

My Python version is 3.7.6.

1. Install mysql-connector-python

First, you need to install mysql-connector-python module. Install this module by using pip.

pip install mysql-connector-python

2. Setup Mysql 

To connect mysql, we need to set up couple things in advance.

I try to connect local mysql server(localhost). But you can change host ip address if you want.

I created user "testuser" and password "0000" with "mysql_native_password" authentical plugin.

You can easily create user below query. 

CREATE USER 'testuser'@'localhost' IDENTIFIED WITH mysql_native_password BY '0000';

So, the summary of my setup is here.

● host : localhost 
● user : testuser
● password : 0000
● authentication plugin : mysql_native_password

3. Connect Python to Mysql

So here is source code. I write one query to check connection. 

If you want to see more details about mysql.connector module. Please check this link.

import mysql.connector
from mysql.connector import (connection)

try :

    mydb = mysql.connector.connect(
      host="localhost",
      user="testuser",
      password="0000",
      auth_plugin='mysql_native_password'
    )

    # simple query to check mysql is connected.
    # list tables from world database
    sql_select_Query = "show tables from world"

    cursor = mydb.cursor()
    cursor.execute(sql_select_Query)
    records = cursor.fetchall()
    
    print('tables : ', records)

    # close mysql connection
    if mydb.is_connected():
        cursor.close()
        mydb.close()
        print("MySQL connection is closed")

except mysql.connector.Error as e:
    print("Error reading data from MySQL table", e)

If connection is success, you can see this result.

If connection is not worked, you can see error message. You can see one of error message below.

ERROR 1045 is one of error value When you enter an incorrect password or password for your database. 

If you have any question, please write a comment

Today, I want to show how to install visual studio code for C++ IDE.

My OS is Windows 10.

The reason why I choose Visual Studio Code is because it is open-source and fast interface.

We need to install software and build environment path but it is not so hard!

Then, let's start!

1. Install Visual Studio Code

Install Visual Studio Code this link(Download Visual Studio Code - Mac, Linux, Windows)

If you install Visual Studio Code, now we need to install extension for C++.

I installed "C/C++" and "C/C++ Extension  Pack" Extensions. The Extension window is located here.

If you still don't know how to install exntesion, please check this link.(Managing Extensions in Visual Studio Code)

You might need to install SDK too. Here is link for SDK for Visual Studio Code (Download .NET SDK for Visual Studio Code (microsoft.com))

2. Install a compiler

We also need to install a compiler. C++ is a compiled language so we must complie before it can be run in your machine. Unfortunately, VS code is an editor and does not include a C++ compiler or debugger. Therefore, you need to install a compiler additionally.

But, maybe you already have a compiler. Check if you have a compiler.

Please open Command Prompt in your machine and write this command.

This command is to check for the GCC compiler:

g++ --version

If you can see g++ version like below, you have already a compiler.

If you don't have any compiler, I recommend to you to install MinGW-x64 via MSYS2. The MSYS2 link is here(MSYS2)

After you install MSYS2, please Run MSYS2 terminal. You need to install the full Mingw-w64 toolchain. So please write this command in MSYS2 terminal.

pacman -S --needed base-devel mingw-w64-x86_64-toolchain

If you install all toolchain, now you need to add the MinGW compiler to your environment PATH.

Please follow these steps.

1. open Windows settings.

2. search for Edit environment variables for your account. 

3. Choose the Path variable in your User variables and then select Edit.

4. add your mingw-w64 installed path into Path. If you don't change any installation path, it should be C:\msys64\mingw64\bin.

5. Select OK.

Now, we can check your MinGW compiler.

Please open Command Prompt in your machine and write this command. 

gcc --version
g++ --version
gdb --version

If you can see all version, you succeed to install MinGW.

But if you cannot see all, please check your PATH correct and C:\msys64\mingw64\bin folder has files. If you don't have files in C:\msys64\mingw64\bin folder, you need to install full Mingw-w64 toolchain again.

3. Run Hello World

So now, we need to check the compiler is working fine.

Let's open VS code and create a folder HelloWord and create helloworld.cpp file.

I just created one more parent folder "C++". But it doesn't matter!

Now, please paste this script into your source code(helloworld.cpp) and save source code:

#include <iostream>

int main()
{
    std::cout << "Hello World" << std::endl;
}

Now, we need to build source code first as I explained above. Select the Terminal → Run Build Task from the main menu.

There are several build options. But we choose C/C++: g++.exe build active file option.

If your build finished successfully, you can see an executable file called helloworld.exe in File Explorer.

To run helloworld.exe, please open new terminal in VS code.

run your program by typing ".\helloworld.exe" in your terminal. If everything is fine, you should see the output "Hello World".

So today, we learn how to install visual studio code for C++.

If you have any question, please write a comment.