0
votes
1answer
31 views

Creating user with password or changing password doesn't work in PostgresQL

I'm trying to create a new user role or change existing one's password to be able to work locally with PostgresQL. I'm working on Ubuntu. I can modify the attributes of an user, but for some reason ...
0
votes
1answer
71 views

Multiple requests shut down MySQL

I have some problems with my MySQL database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems: Every day at the ...
0
votes
1answer
252 views

Trouble connecting to LibreOffice Base database in split database mode using HSQL 2.2.8

I am trying to install a split database (starting with a file copy) using an upgrade to HSQL 2.2.8. I got HSQL 2.2.8, and have followed the instructions from another post on this site ( How to set up ...
1
vote
3answers
7k views

How to connect to MySQL server in LAN?

Here is the technical description. My laptop's config: IP Adress:192.168.2.5 MySQL Server 5.0 on port 3306 Operating System: Ubuntu The database is in this machine My friend's laptop config: ...
1
vote
2answers
3k views

Linux Mint (Ubuntu) Microsoft Access Replacement?

I've just switched over from Window to Linux Mint, and the only thing I'm missing is a replacement for Microsoft Access. I'm aware of LibreOffice (which comes installed), are there any others I ...
0
votes
1answer
78 views

Can an application running as user foo log onto a database as (database) user foobar?

I am writing a simple application that will run as user foo (i.e. Ubuntu user foo). However, the application will connect to my database as (database user foobar). IIRC, database users have nothing ...
0
votes
1answer
2k views

SQL Error (2003): Can't connect to MySQL server on 'X.X.X.X.' (10051) - What does this error mean?

I get following error when i try to connect via "HeidiSQL" to my database server (local network) SQL Error (2003): Can't connect to MySQL server on 'X.X.X.X.' (10051) SSH Connection via Putty works ...
0
votes
1answer
59 views

Ubuntu Server Edition

I just installed the lasted version of Ubuntu server with LAMP my goals to build my own site and database (php mysql). is there a list of all the useful commands somewhere? is there a good how to ...
0
votes
1answer
162 views

How do I create a postgresql user and database from a fresh install?

I just installed postgresql onto an ubuntu box. How can I create user foo with password bar and database baz, so that foo owns baz? foo is not a unix user.
1
vote
1answer
435 views

Advise on VMWare hardware requirements and host OS

I'm a newbie developer wanting to learn a bit about Virtualization (from the IT point of view, not theoretical/academic). What I'd like to do: Prepare a machine Install VMWare or VirtualBox ...
4
votes
5answers
6k views

What FLOSS DB design tool for Linux would you recommend?

I want to find a relational DB design tool for Linux, that could export DB schema for MySQL, SQLite and PostreSQL at least. And it should be handy, of course. Good-looking GUI is also a plus ;-) I use ...
0
votes
1answer
59 views

migrating berkeley database from XP to linux box

I am in the process of migrating from XP to Linux (Unbuntu 9.10). I need to migrate a larg(ish) BDB database (approx 5Gb) from my XP machine to the Linux machine). The berkeley database was created ...
1
vote
2answers
362 views

How do I recover my database?

I exported my database to test whether it works. I then deleted the database and then it went to the "Trash" (I'm using Ubuntu). I then deleted it from "Trash" accidently. Is there a way to recover ...
4
votes
2answers
1k views

To have Vim Psql's editor

I have a Fresh Ubuntu installation. I have no personal dot-files active. I run unsuccessfully \e file.sql in Psql, when I have the following in my .bashrc, since Nano opens instead of Vim export ...