How to fix – DBeaver Native client is not specified for connection ?

Native client is not specified for connection

Download Mysql or Postgres or (appropriate database ) Server

Do the step of DBEAVER client configuration

Find bib files for mysql – open terminal and execute followin command

which mysql
--> /usr/local/bin/mysql

if using a mac to allocate mysql server bin files location

command + shift + G

Paste the path in there such as

/usr/local/mysql-5.7.28-macos10.14-x86_64/bin/

Voila you can enjoy most amazing feature of DBeaver !

Mysql Open remote access

Connect

mysql -u root -p
USE mysql;
SELECT user,host FROM user;

grant privileges

from specific IP

GRANT ALL PRIVILEGES ON *.* TO root@my_ip IDENTIFIED BY ‘root_password‘ WITH GRANT OPTION;

From everywhere

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY ‘root_password‘ WITH GRANT OPTION;

Flush privileges

FLUSH PRIVILEGES;

How to resolve ERROR 1148 (42000): The used command is not allowed with this MySQL version ?

Solution

mysql> SHOW VARIABLES LIKE 'local_infile';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| local_infile  | OFF   |

+---------------+-------+

1 row in set (0.21 sec)
mysql> SET GLOBAL local_infile = 1;

Query OK, 0 rows affected (0.00 sec)
mysql> SHOW VARIABLES LIKE 'local_infile';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| local_infile  | ON    |

+---------------+-------+

1 row in set (0.00 sec)
mysql> load data local infile '/Users/davidr/Desktop/dob.csv' INTO TABLE dob FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;
Query OK, 109093 rows affected (1.88 sec)
Records: 109093 Deleted: 0 Skipped: 0 Warnings: 0