目录
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