如何添加远程访问用户？

在navicat数据库连接工具中，新建查询，运行以下sql

use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'lingdang'@'%' IDENTIFIED BY 'lingdangcrm123!@#' WITH GRANT OPTION;
FLUSH PRIVILEGES;

 

-- user: lingdang
-- pswd: lingdangcrm123!@#

添加远程访问用户.sql