Navicat Blog

Jun 5, 2018 by Robert Gravelle

Part 2: Creating a New User

In Part 1, we learned how to secure the MySQL root account using the Navicat Premium User Management Tool. Today's blog will focus on setting a new user's account details, account limits, and SSL settings.

May 29, 2018 by Robert Gravelle

Part 1: Securing the Root Account

Managing the users of a database is one of the key responsibilities of the database administrator (DBA). Coordinating how users in your organization access your database typically entails many separate tasks, from adding new users, blocking access to users who have left the organization, and helping users who cannot log in.

May 23, 2018 by Robert Gravelle

The Virtual Group feature provides a mechanism for logical grouping of the Navigation Pane's database objects by category, so that all objects are more effectively organized. It can be applied to many different object types, including:

May 15, 2018 by Robert Gravelle

All of Navicat's database management and design products, i.e. Navicat MySQL, MariaDB, SQL Server, SQLite, Oracle, PostgreSQL, and Premium, include a Navigation Pane. It provides more than a means to navigate between your connections, schemas, databases and database objects. In Non-Essentials Editions, it also features Virtual Grouping, which is a logical grouping of objects by categories. In today's tip, we'll be going over how to manage your connections within the Navigation Pane. In part 2 we'll learn how to utilize Virtual Grouping.

May 8, 2018 by Robert Gravelle

In What to Monitor on SQL Server (Part 1), we reviewed two of the four main categories of performance metrics to monitor in order to gauge SQL Server efficacy, namely Disk Activity and Processor Utilization. Today's blog will cover Memory and Server operations.

Navicat Blogs
Feed Entries
Blog Archives