I installed MySQL Workbench, entered the CREATE DATABASE python_mysql; . After that, I did not see a new database anywhere, although it is written that it was successfully created. Instead, there are schemas (SCHEMAS) in which the tables are located and which can be accessed as databases from Python or Java.

Explain, please, what is happening and how schemes differ from databases.

    1 answer 1

     root@host# mysql -u root -p Enter password:******* mysql> use TUTORIALS; Database changed mysql> CREATE TABLE tutorials_tbl( -> tutorial_id INT NOT NULL AUTO_INCREMENT, -> tutorial_title VARCHAR(100) NOT NULL, -> tutorial_author VARCHAR(40) NOT NULL, -> submission_date DATE, -> PRIMARY KEY ( tutorial_id ) -> ); Query OK, 0 rows affected (0.16 sec) mysql>

    Example uper from the Internet. What's happening?

    1. We start the mysql client as root , authorization by password
    2. Switch to TUTORIALS database
    3. Create a tutorials_tbl table in it with the specified columns and index. Easily tailor an example to your needs.