mysql 操作 远程访问 错误:mysql Table 'performance_schema.session_variables' doesn't exist
来源:互联网 发布:json 双引号 编辑:程序博客网 时间:2024/04/28 18:06
授权:
例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;(后面这句必须要有,否则不成功;)
如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器,并使用mypassword作为密码
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;(后面这句必须要有,否则不成功;)
如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器的dk数据库,并使用mypassword作为密码
GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;(后面这句必须要有,否则不成功;)
---------------------------------------------------------------------------------------------------
错误处理:
如果出现错误:mysql Table 'performance_schema.session_variables' doesn't exist
1.按”win+R“或者进入cmd进入mysql的安装目录下的bin文件夹下面,我的是在C:\Program Files\MySQL\MySQL Server 5.7\bin这个目录下;
2.执行:mysql_upgrade -u root -p --force
- mysql 操作 远程访问 错误:mysql Table 'performance_schema.session_variables' doesn't exist
- mysql Table 'performance_schema.session_variables' doesn't exist
- 【笔记】mysql Table 'performance_schema.session_variables' doesn't exist
- mysql error:Table 'performance_schema.session_variables' doesn't exist
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist
- java连接mysql、 Table 'performance_schema.session_variables' doesn't exist
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist
- 关于连接myEclipse连接mysql时出现 Table 'performance_schema.session_variables' doesn't exist错误解决方法
- Table ‘performance_schema.session_variables’ doesn’t exist
- Table 'performance_schema.session_variables' doesn't exist
- Table ‘performance_schema.session_variables’ doesn’t exist
- Table 'performance_schema.session_variables' doesn't exist.
- 解决方法Table 'performance_schema.session_variables' doesn't exist
- Table 'performance_schema.session_variables' doesn't exist
- 关于MySQL升级和安装中Table 'performance_schema.session_variables' doesn't exist(某表不存在)的错误
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist 解决的方法是:
- Mysql 升级重装后连接出错 Table \'performance_schema.session_variables\' doesn\'t exist
- mysql 查询 出现Table 'performance_schema.session_status' doesn't exist错误
- Android okHttp拦截请求头和响应头
- webstorm 2016破解
- iOS学习笔记-048.UINavigationController——导航控制器
- Tomcat服务器原理详解:三部曲
- Kotlin开发Android入门(一)
- mysql 操作 远程访问 错误:mysql Table 'performance_schema.session_variables' doesn't exist
- 从零移植uboot 2017 到nuc970(第七天)
- const,static关键字用法归纳
- 简单工厂模式的练习==商场收银
- 【剑指Offer】对称的二叉树
- Cranking the Coding Interview: C1 Array and String
- hdu 5929 Basic Data Structure 找规律 模拟
- JZOJ 3636. 【BOI2012】Mobile
- 食物链