Ask Ubuntu Stack Exchange
Ask Ubuntu Stack Exchange

Questions tagged [sql]

SQL is a programming language designed for managing data in relational database management systems (RDBMS).

SQL is a programming language designed for managing data in relational database management systems (RDBMS).

118 questions
56
votes
5 answers

How to install SQL Developer on Ubuntu 14.04?

I am trying to install SQL Developer on Ubuntu 14.04. I have followed some tutorials but none of them worked. So I am asking you if you know how to install SQL Developer.
vladmateinfo
  • 1,395
  • 2
  • 13
  • 11
28
votes
4 answers

Connecting MS SQL using freetds and unixodbc: isql - no default driver specified

I am trying to connect to the MS SQL database using freetds and unixodbc. I have read various guides how to do it, but no one works fine for me. When I try to connect to the database using isql tool, I get the following error: $ isql -v TS username…
Dejan
  • 281
  • 1
  • 3
  • 3
20
votes
5 answers

Unable to install msodbcsql17 on Ubuntu 18.04

I installed the sqlserver based on the Microsoft Documentation. The following commands are executed correctly. wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - sudo add-apt-repository "$(wget -qO-…
Hossein Bajan
  • 303
  • 1
  • 2
  • 10
16
votes
5 answers

How to use SQL in terminal?

I want to create simple tables, insert values in it, and do queries. How to perform them in the terminal?
user198612
  • 161
  • 1
  • 1
  • 3
14
votes
2 answers

Not prompted to input the root password when installing mariadb-server on Ubuntu 16.04 LTS

I just had a fresh install on my pc the Ubuntu 16.04 LTS. When I tried to install MariaDB by typing: sudo apt-get install mariadb-server The installation went smoothly but during the process I was not prompted to input the password for the mysql…
user6133116
  • 143
  • 1
  • 1
  • 5
13
votes
4 answers

SQL modeling and design tools?

I would like to know which tool do you use for modeling tables, relationships, etc, generic database modeling, in Ubuntu. It would be good if that tool generate SQL scripts, and a plus with those scripts are SQLite compatible, but thats not…
Pedro Dusso
  • 471
  • 3
  • 6
  • 14
13
votes
1 answer

Jetbrains Datagrip icon cannot lock to the launcher

I downloaded Jetbrains' Datagrip application on Ubuntu 16.04 and started it by running it's datagrip.sh file on the terminal. When I try to select Lock to launcher by right clicking it's icon on the launcher, it does nothing. Can you explain me why…
Nuwan Thisara
  • 2,412
  • 6
  • 31
  • 52
11
votes
3 answers

How to execute SQL statement from command line?

I'm a longtime GUI user trying to switch to command line, and I'm not sure how to execute an SQL statement from the Ubuntu command line. I'm using postgres. I can use \c to connect to the database and \d to see the tables in it. I can also see the…
j450n
  • 141
  • 1
  • 2
  • 6
10
votes
2 answers

Can I run SQL Server on Ubuntu?

My company develops software with two sides: client and server. I've installed Microsoft SQL Server on Windows and am running the client side on Ubuntu with some configuration. But I'm wondering: is there a way to run Ubuntu as the server instead…
Jester
  • 103
  • 1
  • 1
  • 4
9
votes
3 answers

how to install sql developer (.rpm file) on lubuntu 18.04

How to install sql developer on lubuntu 18.04 I tried the below link from Oracle (served as installation notes when you download sql developer) but that dint…
Amar Singh
  • 113
  • 1
  • 1
  • 5
7
votes
1 answer

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server

I am not able to run sqlcmd command My OS (18.04) is $ uname -a Linux Linux 4.15.0-23-generic #25-Ubuntu SMP Wed May 23 18:02:16 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux $ sqlcmd -S localhost -U SA -P 'password' Sqlcmd: Error: Microsoft ODBC…
Raakh
  • 93
  • 1
  • 1
  • 6
6
votes
4 answers

What standalone databases with GUI are available for Ubuntu?

I have googled for this information and I am simply lost. I just need a simple, standalone and a single table database with GUI. I tried Libraoffice base, but it keeps giving me an error "S1000 java.lang.Null" and destroys all the record in the…
ThN
  • 213
  • 3
  • 11
6
votes
1 answer

How to disable MySQL server from constantly running in the background?

This website explains MySQL server installation in Ubuntu 18.04. Basically you issue the command sudo apt install mysql-server. The same website then explains that: Once the installation is completed, the MySQL service will start automatically.…
Display name
  • 2,121
  • 5
  • 22
  • 33
6
votes
6 answers

How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"

mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) The connection to the controluser as defined in your configuration has failed..
islem GUESMI
  • 61
  • 1
  • 2
  • 7
4
votes
1 answer

Cannot run Sqlectron

I have installed sqlectron v1.28.0 from the .deb file available here but I cannot run it. The icon appears in my system. When I click on it nothing happens. I'm running 14.04 btw. Please help.
Red Bottle
  • 173
  • 1
  • 9
1
2 3 4 5 6 7 8