MySQL 安装与使用步骤详解

[1] 选择安装类型：`developer default`
[2] 检查依赖项：自动安装必要组件
[3] 配置认证方式：`use strong password encryption`
[4] 设置root密码：需包含大小写字母+数字
[5] 配置服务名称：保持默认`mysql80`

# 添加至path环境变量
c:\program files\mysql\mysql server 8.0\bin

mysql --version
# 预期输出：mysql  ver 8.0.xx for win64 on x86_64

sudo /usr/local/mysql/support-files/mysql.server start    --启动 mysql
sudo /usr/local/mysql/support-files/mysql.server stop     -- 停止mysql
sudo /usr/local/mysql/support-files/mysql.server restart  --重启 mysql

mysql -u root -p 或  /usr/local/mysql/bin/mysql -u root -p  -- 进入默认用户：root

create database school;
use school;

create table students (
  id int primary key auto_increment,
  name varchar(50) not null,
  score decimal(5,2),
  created_at timestamp default current_timestamp
);

-- 插入数据
insert into students (name, score) values ('张三', 92.5);
-- 查询数据
select * from students where score > 90;
-- 更新数据
update students set score = 95.0 where name = '张三';
-- 删除数据
delete from students where id = 1;

show databases;        -- 查看数据库列表
drop database  text;   -- 删除指定 数据库，如：text
desc students;         -- 查看表结构

- mysql workbench (官方工具)
- navicat for mysql
- dbeaver (开源免费)

create user 'teacher'@'localhost' identified by 'securepass123!';
grant select, insert on school.* to 'teacher'@'localhost';
flush privileges;

mysqldump -u root -p school > school_backup.sql

mysql -u root -p school < school_backup.sql