The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
49 views

Moved offices and now cannot connect remotely to postgres

Everything was working in my previous office. I've now moved to a new office, and cannot connect remotely to postgres. SSH works though. My IP is currently 70.90.155.138. Could not connect to ...
0
votes
1answer
31 views

Providing database connection via web server

I am creating a database (in PostgreSQL, but this question is hopefully independent of the underlying DBMS) that will be hosted remotely. Most access will be provided through a web-based front end ...
1
vote
1answer
116 views

What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?

Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question ...
2
votes
1answer
1k views

Connection to SQL Server 2008 R2 Database Server is SLOW

The database server is a VM running SQL Server 2008 R2 on top of Windows Server 2012, 24GB RAM allocated and 2TB of disk space. Overall, the database connections are very slow and one thing that ...
0
votes
1answer
143 views

SQL Server 2005 Linked Server using SSMS from laptop vs RDP

I connect to work network via Cisco VPN from my work laptop, which is on AD. Edit I am using SQL authentication to connect from Server A to B; in scenario #1 I can connect. I can even connect from ...
0
votes
1answer
928 views

can't connect to mysql with a host

I have mariadb installed and running. I can connect to it with this: mysql -u dev -p or mysql -h localhost -u dev -p but I can't connect to it using mysql -h 127.0.0.1 -u dev -p It asks me ...
0
votes
2answers
308 views

How would I allow access to a VPS based MySQL database only from AWS East based IPs?

I have a MySQL database on my VPS that I only want to be accessible by my local IP (no problem in doing that) and an IroneWorker Ruby app, which may use any of these AWS East IPs. So far, the only ...
2
votes
1answer
591 views

Should a connection pooler be run on my database server or my app server?

I'm getting ready to start using PGBouncer, but I'm unsure of whether it should be used on my database server or on the app servers. If it's on the app servers, there will necessarily be multiple ...
2
votes
1answer
60 views

What is the most efficient way to connect my application on one VM to my Postgres DB on another VM?

I have 1 physical machine with 2 VMs (VMWare esxi) - one for database (PostgreSQL 9.2.1), and one for application. I'd like my application to connect to my database in an efficient way, and I've heard ...
-1
votes
1answer
159 views

Can I connect VM to Wamp installation of Mysql running on same machine? [closed]

On my Windows 7 PC I have Virtual Box running a Centos VM that has PHP installed on it but no MySQL that I brought from the office. I am trying to set up a database for it. I have Wamp installed on ...
0
votes
1answer
112 views

Error 1045 while configuring mysql

I can install the mysql but while configuring it i am getting error like this: ** 1045 : access denied for user root@loaclhost.** i can install it i cant configure it. Please help...I am quite new to ...
1
vote
1answer
355 views

Performance factors in remote database access

I have a Java application which accesses a database. I tested it on my local machine with local database and it works just fine. But when I test it in our test environment where the application server ...
0
votes
2answers
6k views

How to connect MySQL database of local server in NetBeans 7.0.1 ( windows)? [closed]

I am using NetBeans IDE 7.0.1 on Windows 7 very first time for my php. Actually in my company there is a local server ( 192.168.1.99) where all projects resides and we access phpmyadmin of ...
1
vote
2answers
2k views

How to connect to MySql in another Ubuntu machine?

Hi How do i connect to MySql from another Ubuntu machine. I tried this mysql -h 'IP' -P 3306 -u test -ptest I get ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (111). then i tried ...
2
votes
6answers
12k views

How to mass kill connections to MySQL?

I've opened too many connections to MySQL and now I can't access it. It says "Too many connections". How can I close all of these connections? I also don't know how to restart it, which may resolve ...
1
vote
3answers
1k views

How to tell if any MySQL connections has been dropped or timed out?

A client is using PHP to connect to MySQL. The PHP scripts and the MySQL database are located on 2 different Linux servers. He complained that database connections were being dropped or timed out and ...
1
vote
2answers
274 views

cannot at all find sql instance (while installing an asp.net app on IIS)

So I'm really not a DBA, I'm an app dev. I had to install my asp.net mvc3 app on my client's(a large company) IIS6 + Win2k3 machine, with absolutely no help from their sysadmins. The final problem ...
5
votes
1answer
431 views

Find what is causing failed connections in mysql

I have a replicated MySQL environments were the master db gets a continuous "Aborted_connects". How can I find out what IP and what user are causing the aborted connections. There are about 500 ...