24
votes
Accepted
Unable to install msodbcsql17 on Ubuntu 18.04
After searching around, I have found the requested package, it is located on Microsoft Ubuntu 18.04 repository, in order to install the package you have to add the repo first.
This will install ...
- 15.7k
14
votes
How to execute SQL statement from command line?
Edit: OP's actual problem apparently is table name that entirely consists of digits. According to SQL-92 standard table names cannot start with a digit, but otherwise can contain digits. For such case,...
- 108k
13
votes
How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"
I know this post is old, but here is what happened to me. I was upgrading and the phpmyadmin installer asked what the phpmyadmin user password should be, or to leave it blank to random generate a ...
- 131
13
votes
PHP 7.4 Warning: Unable to load dynamic library 'sqlsrv.so' and 'pdo_sqlsrv.so'
Finally got it to work. You need to set the cli version to 7.4
sudo apt install php7.4-dev
sudo update-alternatives --set php /usr/bin/php7.4
sudo update-alternatives --set php-config /usr/bin/php-...
- 331
11
votes
Accepted
How to disable MySQL server from constantly running in the background?
Does this imply that once I install mysql-server it will always be running in the background
Yes.
unless I explicitly kill the process upon each reboot?
No, never ever ever kill mysql. Killing it ...
- 312k
11
votes
Unable to install msodbcsql17 on Ubuntu 18.04
I had the same issue but above solutions didn't workout for me. So here's how I solved this problem.
sudo apt-get install -y libodbc1
sudo apt update
sudo apt install unixodbc
Following commands from ...
- 211
8
votes
Accepted
how to install sql developer (.rpm file) on lubuntu 18.04
The easiest way to install the Oracle SQL Developer program in all currently supported versions of Ubuntu is to install sqldeveloper-package from the default Ubuntu repositories. sqldeveloper-package ...
- 124k
8
votes
Accepted
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server
we have same problem,
and i have fixed that,
just replace localhost with 127.0.0.1
sqlcmd -S 127.0.0.1 -U SA
- 198
8
votes
Cannot run Sqlectron
if you try to launch it from Terminal, you will notice an error like this
sqlectron: error while loading shared libraries: libgconf-2.so.4:
cannot open shared object file: No such file or ...
- 303
7
votes
How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"
With root privileges on the command line, use the mysql database create the user identified by your password, grant all select, update, delete privileges on all the databases on all the tables to the ...
- 733
6
votes
How to install SQL Developer on Ubuntu 14.04?
I installed version 17.4 on Ubuntu 16.04 GNOME like so.
Verify installation of OpenJDK 8 and location at /usr/lib/jvm/java-8-openjdk-amd64 If absent, install with sudo apt install openjdk-8-jdk. Newer ...
- 3,919
6
votes
how to install sql developer (.rpm file) on lubuntu 18.04
sudo apt-get install alien openjfx
Then:
Follow the link https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Click "Accept license agreement" that looks like a radio ...
- 163
6
votes
Why I can't insert a picture into database?
Standard MySQL in Ubuntu runs with secure_file_priv enabled, which means that you can't just load from (and write to) any file on your system: the file must reside in a particular directory. You can ...
- 30.9k
4
votes
Accepted
error while loading shared libraries: libqjson.so.0
The file is provided by package libqjson0.
sudo apt install libqjson0
Try again sqlprofiler then.
You can use the https://packages.ubuntu.com/ to search for the package containing a specific file, ...
- 15.7k
4
votes
nzsql: error while loading shared libraries: libcom_err.so.2: wrong ELF class: ELFCLASS64 on Ubuntu 18.04
You should confirm this by running
file /usr/local/nz/bin/nzsql
but it's likely your netazza application is a 32bit application on an x86-64 (i.e. 64bit) installation; you will need to install the ...
- 1,151
4
votes
How to install Adventure Works DB on Ubuntu 16.04?
You can download the sample database here:
https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2017.bak
Now, restore the database:
RESTORE DATABASE [...
- 41
3
votes
Accepted
Set environment variable UBUNTU 18.04 (bionic) - Crontab
cron runs jobs in its own minimal environment and doesn't itself read any of the shell startup files such as those in /etc/profile.d/ - by default it's just something like
LANGUAGE=en_CA:en
HOME=/...
- 145k
3
votes
PHP 7.4 Warning: Unable to load dynamic library 'sqlsrv.so' and 'pdo_sqlsrv.so'
In case someone is wondering still relevant for Php 8.2
sudo apt install php8.2-dev
sudo update-alternatives --set php /usr/bin/php8.2
sudo update-alternatives --set php-config /usr/bin/php-config8.2
...
3
votes
Are there no graphical desktop MySQL clients in Ubuntu official apt repo?
It is more than a MySQL / MariaDB client, but you can install the excellent DBeaver Community either standalone or as an Eclipse plugin. The standalone version is available as a Snap, Flatpak or deb ...
- 2,506
2
votes
Accepted
How to upload sqlite3 database to webserver?
From your other question I see that you use tuptime.
To keep the DB synchronized you would need to copy it to your webserver every time it is locally updated. This assumes that your local computer is ...
- 14k
2
votes
how to install sql developer (.rpm file) on lubuntu 18.04
I just installed SQL Developer on Ubuntu 20.04 today without either an .rpm package or make-sqldeveloper-package.
It ended up being quite straightforward:
Download the "Other Platforms" zip ...
- 5,891
2
votes
how to install sql developer (.rpm file) on lubuntu 18.04
I was able to finally install SQL Developer after trying a whole bunch of things. Experts please improve this answer!
I used the Alien tool/utility/command to install SQL Developer.
the file i ...
- 113
2
votes
SQL Server add respository
The error you received is a "dummy error" and should be ignored.
Run the following command to verify:
cat /etc/apt/sources.list | grep micro
you should see an output that says something like this:
...
- 45.4k
2
votes
Problems installing MS SQL Server and MySQL on Ubuntu 22.04
not sure i understood exactly your problem. But i'm gonna take a shot.
First Step - Cleaning
Since seems to be some stuff that don't agree to work togheter, uninstall everything and let's re-install ...
1
vote
SQL Server add respository
I had accidently installed a 32bit (i386) version and not 64bit. Cause identified by mchid in the comments.
Under 64bit it worked fine.
- 41
1
vote
Accepted
LetsEncrypt for SQL Server on Linux
Paraphrased from MariaDB SSL configuration - using Let's Encrypt certificate
The key is in the wrong format, and can be converted with openssl to
different format.
openssl rsa -in ./privkey.pem -...
- 22k
1
vote
How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"
For me the solution after uninstall of MySQL 8.0 to remplace it by MariaDB, has been to combine a part of @Wuijin answer with a part of the @Mahmoud one.
open /etc/phpmyadmin/config-db.php, copy the ...
- 281
1
vote
How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"
In addition to @Wuijin's instructions, I needed to created a new user called 'phpmyadmin' since it was not present.
To be sure that the phpmyadmin user exists, run this query inside MySQL CLI:
SELECT ...
- 111
1
vote
Unable to install msodbcsql17 on Ubuntu 18.04
It was not enough in my case, and I was made to execute the following commands:
sudo apt install libodbc1
sudo apt install unixodbc
- 111
1
vote
Unable to install msodbcsql17 on Ubuntu 18.04
I had similar problem but not same. In my case error was
can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1' : file not found
I was uninstalling msodbc and then reinstalling ...
Only top scored, non community-wiki answers of a minimum length are eligible