Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [navicat]

8 questions
7
votes
3 answers

How do I allow remote access to mysql using xampp?

I'm using xampp and navicat to manage mysql on two dev machines (laptop & desktop). The laptop is my main machine, while the desktop acts as a local dev server for the group. Connecting to mysql via localhost in navicat is working fine on the…
sprugman
  • 213
  • 1
  • 2
  • 4
3
votes
2 answers

Navicat failed to connect to server over ssh tunnel on ubuntu 16.04

I'm trying to connect my database in my ec2 instance running on Ubuntu 16.04 with Navicat. But it keeps coming with SSH: expected key exchange group packet from server. I have another instance running on Ubuntu 14.04, there I have an active…
H. Jabi
  • 33
  • 1
  • 7
1
vote
2 answers

What's the best way to migrate a MySQL database?

We are moving a busy eCommerce site from one server to another. It's a PHP application that uses MySQL. phpMySQL is not installed on either server. We use Navicat Essentials for MySQL to manage databases. The plan is as following: Reduce DNS…
OC2PS
  • 539
  • 2
  • 9
  • 21
1
vote
1 answer

"Access Denied" when trying to access AWS Lightsail database

I'm trying to connect to my AWS Lightsail database instance with Navicat Premium 15.0.21 (newest available version at the time of posting). My database is in public mode. I copied and pasted the endpoint, username, and password straight into…
kryz
  • 13
  • 3
0
votes
1 answer

Decompress a PSC File

I need to restore a database that was backed up using navicat's compressed backup feature. But on the restore, there's an error coming up on one of the tables. I can't look at the SQL statements in the file directly because they're compressed, and I…
Kevin Laity
  • 169
  • 1
  • 3
  • 8
0
votes
1 answer

Migrating mysql 'users' to new machine gives off errors

I have looked at the settings a great number of times but run into the same issue. When connected to my Linux box with the 'exact' same settings, no fault. When run on a fresh machine with xampp for testing: SQLSTATE[28000] [1045] Access denied …
JM4
  • 1,144
  • 3
  • 18
  • 29
0
votes
0 answers

could not load private key asn.1 decoding failure Navicat

I have a Problem with my Navicat when i want to connect with a SSh-Key to our Company Servers i cant because Navicat give the folloing Error: could not load private key asn.1 decoding failure Has anyone an Idea what is going on?
Marvin Fratzke
  • 1
  • 1
-1
votes
2 answers

Install Navicat for MySQL on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a GUI. Now I need to install a front-end to connect…
DanielAttard
  • 129
  • 2
  • 10