During installation, MySQL creates three user accounts that should be considered reserved: The above image shows the default user accounts. Clicking it displays the Objects tab, which includes all of the registered users for the MySQL connection. User management functionality is accessible via the User button. Today's blog describes the three default MySQL user accounts and how the secure the root user.Īlthough we'll be using Navicat Premium for the purposes of this blog, keep in mind that Navicat for MySQL includes the same functionality, but specifically targeting MySQL. In this series, we'll explore how to perform common user administration tasks from within Navicat. For DBAs who prefer something a little more sophisticated, Navicat for MySQL and Premium includes everything you need to manage your MySQL users so that you don't ever have to launch a separate command window.
You can use it to check the server's configuration and current status, to create and drop databases, and more. MySQL ships with the mysqladmin command-line client for performing administrative operations. 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. Managing the users of a database is one of the key responsibilities of the database administrator (DBA). By Robert Gravelle Part 1: Securing the Root Account
