mysql select into outfile默认文件保存路径是C:\ProgramData\MySQL\MySQL Server 8.0\Data
2023-09-14 09:11:45 时间
找到my.ini,
修改u secure_file_priv = '' 然后保存并且退出。
重启mysql 正确的解决方法是:
搜索“服务”并进入:
下拉找到Mysql
左上角处可以进行重启动。如果以后想要通过命令行来重启,那么:
可以看到我的服务名应该是mysql57而不是mysql。
select "hello world" into outfile "hello2.txt"; show variables like '%secure%';
————————————————
相关文章
- Mysql远程连接数据库报错排查:pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '**.**.**.**' (timed out)")
- Mysql:is not allowed to connect to this MySQL server
- PHP连接MySQL报错:SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket 'MySQL' (2)
- 用Navicat连接mysql报错:2003-Can't connect to MySql server on '10.100.0.109'(10039)
- navcat导入mysql.sql出现:2006, 'MySQL server has gone away'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var mysql 启动不了
- Java通过mysql-connector-java-8.0.11连接MySQL Server 8.0遇到的几个问题
- 【问题解决方案】MySQL安装后无法启动-net start mysql服务名无效
- MySQL(Navicat)运行.sql文件时报错:[Err] 2006 - MySQL server has gone away 的解决方法
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
- Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
- piap.excel 微软 时间戳转换mssql sql server文件时间戳转换unix 导入mysql
- error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
- MySQL数据库加密和解密~认证登陆密码(mysql.user)和MySQL不区分大小写
- ERROR! MySQL server PID file could not be found!
- Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)
- Linux MySQl 5.7.17 MySQL ERROR 1366(HY000):Incorrect string value 解决方法
- pmm-server监控mysql
- MySQL之自带四库之mysql库
- 【MySql】MySQL数据库--什么是MySQL的回表 ?