命令行netstat -ao | find “3306”, 查看MySQL默认端口号3306对应的进程id(pid)为30016:
使用tasklist | find “30016” 查看pid 30016的进程对应的应用程序名为mysqld.exe:
where mysqld即可查询到mysqld.exe的具体位置:
进入mySQL客户端:
mysql -u root -p
use mysql;
命令行:
INSERT INTO user (Host,User,ssl_cipher,x509_issuer,x509_subject) VALUES ('localhost', 'myUser','','','');
之后即可在mySQL workbench里看见这个新建的user:
要获取更多Jerry的原创文章,请关注公众号"汪子熙":