KirillY/mysql-teachmeskills.md

## mysql-teachmeskills.md

      
    Raw
  

              mysql-teachmeskills.md
            
          
    Setup

Check if already installed

sudo service mysql start

If not installed, install

sudo apt update
sudo apt install mysql-server
Start server and enter sql console

sudo service mysql start
sudo mysql

Change password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'qwerty@123';
FLUSH PRIVILEGES;
Install mysql-connector-python

poetry add mysql-connector-python

Usage

Connect using CLI

 mysql --password=qwerty@123 --user=root

Connect using Python

import mysql.connector as mysql
db = mysql.connect(
    host="localhost",
    user="root",
    passwd="qwerty@123"
)

cursor = db.cursor()
cursor.execute("CREATE DATABASE test_db")
cursor.execute("SHOW DATABASES")
print(cursor.fetchall())
cursor.execute("DROP DATABASE test_db")
db.close()