mysql 命令

🧙 Questions

• 登录mysql

☄️Ideas

安装mysql客户端

• https://dev.mysql.com/downloads/shell/

登录mysql

# 密码的p没有空格
# sudo docker exec -it isxcode-mysql bash
# mysql -h localhost -u root -pisxcode123 -P 30201 
# mysql -u root -p
mysql -h ${host} -p${passwd} -u ${user} -P ${port}

mysql执行本地文件

# 上传脚本 C:\Users\ispong\AppData\Roaming\MobaXterm\home
mysql -u dehoop -h 172.16.56.35 -P 30102 -p密码 < dehoop-admin.sql

# 执行保存日志
mysql -u root -p dehoop < /root/dehoop.sql > /root/import.log 2>&1

# 指定db执行
mysql -h 192.168.74.69 -P 2883 \
  -u 'dpdba@data_platform_prod#erzhong' \
  -p'JUB58V8AwN' \
  -D data_biz_prod \
  < dehoop_platform_new_server_20260812.sql \
  > import.log 2>&1

🔗 Links

• mysql website
• mysql command website