Ask Ubuntu
Ask Ubuntu

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).

124 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,475
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
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
18
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
  • 181
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
14
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,522
14
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
  • 171
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
  • 481
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
9
votes
4 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
8
votes
7 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
  • 81
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
  • 103
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
  • 223
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,331
5
votes
4 answers

PHP 7.4 Warning: Unable to load dynamic library 'sqlsrv.so' and 'pdo_sqlsrv.so'

After installing the sql server, I tried to install the php drivers, sqlsrv and pdo_sqlsrv php extensions, following these commands: sudo pecl install sqlsrv sudo pecl install pdo_sqlsrv sudo su printf "; priority=20\nextension=sqlsrv.so\n" >…
Carolina
  • 181
1
2 3
…
8 9