Init ubuntu for cpp dev

sudo apt update;sudo apt upgrade -y;

sudo apt-get install open-vm-tools-desktop;
sudo apt-get install open-vm-tools;

wget https://dl.google.com/linux/direct/google-chrome-stable_current_amd64.deb;
sudo dpkg -i google-chrome-stable_current_amd64.deb;
sudo apt install -f;

wget https://vscode.cdn.azure.cn/stable/1a5daa3a0231a0fbba4f14db7ec463cf99d7768e/code_1.84.2-1699528352_amd64.deb?1
sudo dpkg -i code_1.84.2-1699528352_amd64.deb

 

//sudo snap install --classic code;

sudo apt install gcc-13 g++-13 -y;
sudo apt install uuid-dev;

sudo apt install mysql-server -y;
create user 'sam'@'localhost' identified by 'password_value';
grant all privileges on *.* to 'sam'@'localhost' with grant option;
show grants for 'sam'@'localhost';

create database db;
use db;

CREATE TABLE `t1` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT primary key,
`author` varchar(40) NOT NULL default '',
`comment` varchar(40) NOT NULL default '',
`content` varchar(40) NOT NULL default '',
`header` varchar(40) NOT NULL default '',
`isbn` varchar(40) NOT NULL default '',
`memory` varchar(40) NOT NULL default '',
`object` varchar(40) NOT NULL default '',
`result` varchar(40) NOT NULL default '',
`summary` varchar(40) NOT NULL default '',
`title` varchar(40) NOT NULL default '',
`topic` varchar(40) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

sudo apt install libmysqlcppconn-dev -y;

 

show grants for 'sam'@'localhost';
mysql> show grants for 'sam'@'localhost'\G;
*************************** 1. row ***************************
Grants for sam@localhost: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `sam`@`localhost` WITH GRANT OPTION
*************************** 2. row ***************************
Grants for sam@localhost: GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `sam`@`localhost` WITH GRANT OPTION
2 rows in set (0.00 sec)