Skip to main content

Posts

Showing posts with the label MySQL

MySQL Workbench :: Visual database design tool

 MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system. The first preview version of MySQL Workbench was released in September 2005, and was not included in the MySQL GUI Tools Bundle. Development was started again in 2007 and MySQL Workbench was set to become the MySQL GUI flagship product. Prominent features of MySQL Workbench are :  General Database Connection & Instance Management SQL Editor Data modeling Database administration Performance monitoring Database migration Since its introduction MySQL Workbench has become popular within the MySQL community. It is now the second most downloaded product from the MySQL website with more than 250,000 downloads a month. Official Website :- http://mysql.com/products/workbench/ Release :- https://github.com/mysql/mysql-workbench/releases

The used command is not allowed with this MySQL version

The reason can be the server variable 'local_infile' is set to FALSE or 0. We can verify by executing:  SHOW VARIABLES LIKE 'local_infile' ; If you have the privilege, we can enable it by using  SET GLOBAL  local_infile = 1; Another option is to change the config in my.cnf file [client] loose-local-infile=1 We have an another option by changing the MySQL connector string by adding the parameter allowedLoadLocalInfile=true Eg:- jdbc:mysql//<IP>:<PORT>/<DB>?allowLoadLocalInfile=true&useSSL=false