教程

MySQL Documentation精
零基础如何自学MySQL数据库？ ——— W3C_SCHOOL
老夫整理的1000行MySQL学习笔记传授有缘人精
javatpoint文档精

• DB和DBMS（Database Manage System），RDBMS：关系型数据库管理系统
• 关系型数据库（Relational）和非关系型数据库(NO SQL: not only sql)

  安装配置

  怎样在 Ubuntu Linux 上安装MySQL (如果安装5.7，也是下载同一个deb包，只是第一步server选择5.7)
  链接数据库时重置密码
  卸载mysql
  修改数据目录 datadir
  mysql配置文件：/etc/mysql/mysql.conf.d/mysqld.cnf ```shell [mysqld] pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock datadir = /home/username/database/mysql log-error = /var/log/mysql/error.log

  By default we only accept connections from localhost

  bind-address = 127.0.0.1

  Disabling symbolic-links is recommended to prevent assorted security risks

  symbolic-links=0

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

<a name="ygeAG"></a>
# 启动停止
```bash
 // 验证MySQL安装
mysqladmin --version
sudo systemctl status mysql.service
// 创建root用户的密码
mysqladmin -u root password "new_password";
// 链接到mysql服务器
mysql -u root -p
// 检查mysql服务器是否启动
ps -ef | grep mysqld
// 关闭mysql服务器
cd /usr/bin
./mysqladmin -u root -p shutdown
Enter password: ******
// 开启、关闭、重启
service mysql start
service mysql stop
service mysql restart

图形工具（dbeaver）

文档
Ubuntu 数据库客户端 DBeaver 安装、使用及常用的快捷键
DBeaver 连接MySql 8.0报错 Unable to load authentication plugin ‘caching_sha2_password’
切换数据库：

You can change the currently selected database when you create new sql tabs by selecting 
it from the dropdown.
When you do so be sure to double-click on the schema you want to bring into focus. 
Then you can open new sql editors with ctrl+].