Category : dbeaver

I run the sh "bash" script for running mssql server and try to connect the server using dbeaver on Ubuntu. I get some errors which are posted below. Could you please give me some insights. Thanks in advance. One of them is : The TCP/IP connection to the host localhost, port 1433 has failed. Error: ..

Read more

In a project I am currently doing. I can run MySQL in Docker. This is my docker-compose.yaml: version: ‘3.7’ services: database: image: ‘mysql:latest’ environment: MYSQL_ROOT_PASSWORD: password MYSQL_DATABASE: main ports: # To allow the host machine to access the ports below, modify the lines below. # For example, to allow the host to connect to port ..

Read more

I run docker-compose up with this docker-compose.yml version: ‘3.4’ services: mariadb: image: mariadb:10.6 environment: MYSQL_ROOT_PASSWORD: [email protected] MYSQL_DATABASE: mydb MYSQL_USER: user MYSQL_PASSWORD: 123456 ports: – 3306:3306 restart: always volumes: – ./mariadb:/var/lib/mysql and it’s works. (I try to connect container MySQL command line on my local machine window10) But I can’t connect with DBeaver(21.0.4) mariadb driver 2.7.1 ..

Read more

I have a problem with connection to MSSQL Docker database created from docker-compose.yml file and additional .sql file with ready-to-go empty database configuration. To connect to the MSSQL database i have used DBeaver. During the connection this error occured: Login failed for user ‘system’. ClientConnectionId:23649321-6526-4ec2-a6ed-9943e64ca019 Probably i have wrong docker-compose.yml file or wrong .sql configuration ..

Read more

i have ran those commands: docker run –name mysql-standalone -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=test -e MYSQL_USER=sa -e MYSQL_PASSWORD=password -d mysql:5.6 then docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 35da304532c8 mysql:5.6 "docker-entrypoint.s…" 4 hours ago Up 4 hours 3306/tcp mysql-standalone docker exec -it mysql-standalone bash [email protected]:/# mysql -uroot -p -A Enter password: Welcome to ..

Read more

I have setup DB2 v11.5.5.1 in a Docker container and accessed it via DBeaver. I want to run a script with a CREATE PROCEDURE statement on DB2 database. But it returns SQL Error [42601]: An unexpected token "END-OF-STATEMENT" was found following "E IF EXISTS TEMP_IDS". The sample script I tried is here. –#SET DELIMITER $$ ..

Read more

I’m running an out of the box mysql docker container inside docker play ground at https://labs.play-with-docker.com/ [node1] (local) [email protected] ~ $ docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES f0f8ae352373 mysql "docker-entrypoint.s…" 2 hours ago Up 2 hours 0.0.0.0:3306->3306/tcp, 33060/tcp memories [node1] (local) [email protected] ~ $ Now if I have to connect to ..

Read more

My goal is to connect a client DB (DBeaver, Aginity Pro) to a PostgreSQL running on a docker container. From inside the container, the connection with Postgres is successful. I used Adminer and also PSQL and the connection works. I could create databases, tables, load data. However, using the same connection string from a client ..

Read more