ERROR 1148: The used command is not allowed with this MySQL version

You can specify that as an additional option when setting up your client connection:

mysql -u myuser -p --local-infile somedatabase

This is because that feature opens a security hole. So you have to enable it in an explicit manner in case you really want to use it.

Both client and server should enable the local-file option. Otherwise it doesn’t work.To enable it for files on the server side server add following to the my.cnf configuration file:

loose-local-infile = 1

Related Posts:

  1. How do I import an SQL file using the command line in MySQL?
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. Unknown column in ‘field list’ error on MySQL Update query
  5. MySQL – Operand should contain 1 column(s)
  6. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  7. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  8. MySQL create table if not exists and insert record only if table was created
  9. How do I use properly CASE..WHEN in MySQL
  10. How can I do a FULL OUTER JOIN in MySQL?
  11. MySQL query String contains
  12. What’s the difference between VARCHAR and CHAR?
  13. Case statement in MySQL
  14. How to declare a variable in MySQL?
  15. MySQL Cannot Add Foreign Key Constraint
  16. How do I import an SQL file using the command line in MySQL?
  17. How to split the name string in mysql?
  18. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  19. mysql Foreign key constraint is incorrectly formed error
  20. MySQL: Invalid use of group function
  21. How can I return pivot table output in MySQL?
  22. Compare dates in MySQL
  23. MySQL “WITH” clause
  24. MySQL Multiple Joins in one query?
  25. Error Code: 2013. Lost connection to MySQL server during query
  26. MySQL syntax for Join Update
  27. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  28. how to drop partition without dropping data in MySQL?
  29. MySQL combine two columns into one column
  30. Simple way to calculate median with MySQL
  31. Error 1046 No database Selected, how to resolve?
  32. MySQL Error 1264: out of range value for column
  33. Remove duplicate rows in MySQL
  34. How to SUM and SUBTRACT using SQL?
  35. Cast from VARCHAR to INT – MySQL
  36. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  37. How do you force mysql LIKE to be case sensitive?
  38. MySQL – UPDATE multiple rows with different values in one query
  39. How to create a MySQL hierarchical recursive query?
  40. Insert into a MySQL table or update if exists
  41. How to round down to nearest integer in MySQL?
  42. MySQL starts with searching issue
  43. Query to convert from datetime to date mysql
  44. Is it possible to GROUP BY multiple columns using MySQL?
  45. MySQL error: key specification without a key length
  46. Best way to test if a row exists in a MySQL table
  47. Check if MySQL table exists without using “select from” syntax?
  48. MySQL equivalent of DECODE function in Oracle
  49. mysql update column with value from another table
  50. The used SELECT statements have a different number of columns
  51. How to delete from multiple tables in MySQL?
  52. MySQL: Can’t create table (errno: 150)
  53. How to copy a row and insert in same table with a autoincrement field in MySQL?
  54. Join vs. sub-query
  55. Alternative to except in MySQL
  56. Equivalent of explode() to work with strings in MySQL
  57. ROW_NUMBER() in MySQ
  58. MySQL OPTIMIZE all tables?
  59. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  60. MySQL – Get row number on select
  61. MySQL error: Unknown column in ‘where clause’
  62. How to truncate the text returned for a column in a MySQL query
  63. Using union and order by clause in mysql
  64. MySQL LIKE IN()?
  65. latency problems with wordpress install (from SQL import)
  66. How can I avoid duplicate primary keys in SQL import?
  67. Cannot delete or update a parent row: a foreign key constraint fails
  68. Rename a column in MySQL
  69. Sql Server equivalent of a COUNTIF aggregate function
  70. Column name or number of supplied values does not match table definition
  71. Simple PHP Pagination script
  72. ORA-12560: TNS:protocol adaptor error
  73. difference between primary key and unique key
  74. How to SUM two fields within an SQL query
  75. DateTime2 vs DateTime in SQL Server
  76. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  77. How do I query for all dates greater than a certain date in SQL Server?
  78. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  79. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  80. SQL Server dynamic PIVOT query?
  81. LEFT function in Oracle
  82. How to get the count of each distinct value in a column?
  83. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  84. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  85. Inserting Post Meta From SQL
  86. WordPress database import: Row size too large
  87. How do I see the mysql query generated by get_posts( $args )?
  88. Better way to migrate to server?
  89. Making a query to the DB using same parameters of loop
  90. SQL command to convert all tags in lowercase?
  91. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  92. Why does changing Database Table Prefixes result in loss of content?
  93. WP MultiSite: Can’t select database error after changing to new domain
  94. Use variable in SQL statement
  95. Help me SELECT thumbnail from SQL and use
  96. Database SQL query error
  97. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  98. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  99. Replace Unwanted Space in Post Content URL
  100. If meta_key exists then don’t select this post?

Leave a Comment