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
2
votes
1 answer

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
  • 23
  • 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
  • 8
  • 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
  • 2
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,104
  • 3
  • 18
  • 29
0
votes
0 answers

Cannot connect to server via NAVICAT

2013 - Lost connection to MySQL server at 'reading initial communication packet', system error:0 "Internal error/check (Not system error)" I get this error. I am using a docker container and Docker-Traefik, the exposed port is 3308 and it maps to…
ak12
  • 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