MySQL 8.0 : Install
2022/09/28 |
Install MySQL to configure Database Server.
|
|
[1] | Install and start MySQL. |
root@dlp:~# apt -y install mysql-server-8.0
|
[2] | Initial verification for MySQL. For MySQL 8 on 22.04, anonymous users, root login remotely, test databases are disabled by default, so it does not need to run [mysql_secure_installation]. |
root@dlp:~# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.30-0ubuntu0.22.04.1 (Ubuntu) Copyright (c) 2000, 2022, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. # autentication method of root user is [auth_socket] mysql> select user,host,plugin from mysql.user; +------------------+-----------+-----------------------+ | user | host | plugin | +------------------+-----------+-----------------------+ | debian-sys-maint | localhost | caching_sha2_password | | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | caching_sha2_password | | mysql.sys | localhost | caching_sha2_password | | root | localhost | auth_socket | +------------------+-----------+-----------------------+ 5 rows in set (0.00 sec) # default charset mysql> show variables like "chara%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | utf8mb4 | | character_set_server | utf8mb4 | | character_set_system | utf8mb3 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec) # databases mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.00 sec) # to enable password validation that is run with [mysql_secure_installation], # set like follows # * to disable it, run [uninstall component ***] mysql> install component 'file://component_validate_password'; Query OK, 0 rows affected (0.01 sec) mysql> show variables like 'validate_password%'; +--------------------------------------+--------+ | Variable_name | Value | +--------------------------------------+--------+ | validate_password.check_user_name | ON | | validate_password.dictionary_file | | | validate_password.length | 8 | | validate_password.mixed_case_count | 1 | | validate_password.number_count | 1 | | validate_password.policy | MEDIUM | | validate_password.special_char_count | 1 | +--------------------------------------+--------+ 7 rows in set (0.00 sec) # * to change validation policy parameters, # set parameters under the [mysqld] section in [/etc/mysql/mysql.conf.d/mysqld.cnf] # ex. validate_password.policy=LOW # create test database mysql> create database test_database; Query OK, 1 row affected (0.11 sec) # create test table on test database mysql> create table test_database.test_table (id int, name varchar(50), address varchar(50), primary key (id)); Query OK, 0 rows affected (0.42 sec) # insert data to test table mysql> insert into test_database.test_table(id, name, address) values("001", "Ubuntu", "Hiroshima"); Query OK, 1 row affected (0.04 sec) # show test table mysql> select * from test_database.test_table; +----+--------+-----------+ | id | name | address | +----+--------+-----------+ | 1 | Ubuntu | Hiroshima | +----+--------+-----------+ 1 row in set (0.00 sec) # delete test database mysql> drop database test_database; Query OK, 1 row affected (0.27 sec) mysql> exit Bye |