AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() If you can provide more information, feel free to add it to this bug and change the status back to 'Open'. Still we don't see NULL dir anywhereĬould you please tell us exact MySQL version you are using? Is it installed using official apt repository or using binary tarball? Please paste the content of my.cnf as is for our reference and to investigate further. If we supply "NULL" (not NULL - this is different), server starts. "haha", server startup complaint and fail. If we supply NULL, no dir named NULL is created i.e in / or in datadir This is the behavior we(including Harin) observed: ![]() To change securefilepriv I first had to find the configuration file. The default value of securefilepriv for the Homebrew install of MySQL 5.7.17 was NULL, which prevented me from writing with outfile entirely. Moreover, it is now possible to disable data import/export operation altogether by setting it to string literal NULL. Many of the forum posts I found were written before this change and were horribly confusing. This directory path is used as default value for secure-file-priv. Operations related to importing and exporting data are disabled Installation process creates mysql-data directory at a level similar to data directory. Operations related to importing and exporting data are disabled T06:25:42.358582Z 0 -secure-file-priv is set to NULL. Data Directory Initialization Procedure Use -initialize for secure by default installation (that is, including generation of a random initial root password). T06:06:55.128511Z 0 -secure-file-priv is set to NULL. Mysql tutorial ERROR 1290 (HY000): The MySQL server is running with the -secure-file-priv option 10,860 views Premiered In this video will learn how to solve ERROR 129 Dislike. No "NULL" dir created in / or even in datadir of mysqld Downloads]# ls -l /|grep Downloads]# ls -l /var/lib/mysql|grep Downloads]#Ĭat /var/log/mysqld.log |grep secure-file Mysql> show global variables like '%secure_%' Downloads]# tail -2 Downloads]# rpm -qa|grep -i mysql|grep -v Downloads]# We just tried to reproduce this using Linux - Generic binary tarball build on OL7 and with rpm based installation instance on OL8. ![]()
0 Comments
Read More
Leave a Reply. |