配置Navicat for MySQLNavicat for MySQL是一款常用MySQL管理软件,专门解决MySQL命令行操作不便的问题。下载地址:安装Navicat for MySQL(1)解压安装包之后打开navicat_trial_11.1.20.0.1449226634.exe并安装(2)寻找到安装根目录(我这里是D:\Program......
文章浏览阅读826次。这是因为自己本地开发环境电脑的IP地址,并没有赋予访问服务器端mysql数据库的权限。解决办法:1.在mysq中运行下面命令:use mysql;create user 'root'@'IP地址' identified by '密码';update user set Password ="密码" wh......
文章浏览阅读507次。# open 3306GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '数据库连接密码' WITH GRANT OPTION;FLUSH PRIVILEGES;# https://blog.csdn.net/gagewang1/article/details/80158150firewall-cmd --zone=public --add-port=3306/tcp --permanentfirewall-cmd --reload.....