07、常用开发工具连接MySQL

目录

1、shell连接MySQL

2.python连接MySQL数据库

---

1、shell连接MySQL

创建测试库测试表

CREATE USER 'shell_rw'@'%' IDENTIFIED BY 'Idyq8_a1';
GRANT create,alter,insert,delete,select,update,show view ON *.* TO 'shell_rw'@'%';
​
use martin
CREATE TABLE products (
  id int NOT NULL AUTO_INCREMENT,
  name varchar(255) NOT NULL,
  price decimal(10, 2) NOT NULL,
  PRIMARY KEY (id
);
​

通过Linux命令行连接MySQL

mysql -ushell_rw -p'Idyq8_a1' -e "show databases"
也可以查看某个表
mysql -ushell_rw -p'Idyq8_a1' martin -e "show tables"
查询一张表的数据
mysql  -ushell_rw -p'Idyq8_a1' martin  -e "select * from t1 limit 1"

在shell脚本里执行MySQL的增删改

#!/bin/bash
​
# 设置MySQL连接信息
mysql_host='localhost'
mysql_user='shell_rw'
mysql_pass='Idyq8_a1'
mysql_db='martin'
​
# 执行写入操作
mysql -h"$mysql_host" -u"$mysql_user" -p"$mysql_pass" $mysql_db -e "insert into products (name,price) values ('apple',10.50)"
​
# 查询数据
mysql -h"$mysql_host" -u"$mysql_user" -p"$mysql_pass" $mys