MySQL命令查看当前连接的本地IP

2019-07-26 数据库 1750

通过mysql命令行查看当前客户端真实IP地址

  • mysql -uroot -p 登录MySQL

![登录mysql](/uploads/article/20190726/2be709479b9ccacdbc5209d576d1f1abd88c33f2.png "登录mysql")
  • show processlist; 查看客户端IP地址

![查看mysql客户端IP](/uploads/article/20190726/66f46df5028ffda386aec673d0a4d18ba73c8b1f.png "查看mysql客户端IP")
0