MySql & python

Today I want to build a database for storing my records data.
My developing environment is ubuntu 18.04

Before the developing

1. Install MySql on ubuntu. So mysql is seen as a server service on my ubuntu, to install it with sudo apt-get install mysql-server
2. After installed, use sudo netstat -tap | grep mysqlto check if sql service is listening.
3. After verified, use default user root to login sudo mysqlor more specific sudo mysql -h localhost -P 3306 -uroot -ppasswdto login the server. Mysql has stored all the user info in the tables. Use show tables from mysql; to check.
4. After login, show databases;(always use databases with ;, mysql would not think the command is ended unless ; is put ) to get the list of all the databases generated by default.
5. If a new user is needed or existing user needs to be changed, to use create user <u_name>@<u_host> identified by 'password'; or alter user ... identified with mysql_native_password by '<new_password>'; The latter could also be used to alter the verification methods for authentication methods for mysql account.

Developing

1. Create a database: create database/create schema [name];: create one database with name, this database has no tables.
2. Add tables to an existing database: use [dbname];: Tells mysql to use daname database as the current database for subsequent statements. Then create table <t_name> (<row_name> type); . Now an empty table should be created.
3. Insert values to the tables insert into <t_table>(<row_name>) values(val); then select <row_name> from <t_table>; to retrieve a column back.

Questions

1. Privilege: I have encountered this many times reading \h <item> , what is this and how would this be changed? where is this stored?