User Management

SQLyog provides a powerful tool for adding, editing, deleting users and managing privileges on the selected databases, tables and other database objects. Note that everything managed here is stored on the server. SQLyog does not (and a client should not) verify user's details and privileges. The MySQL server does this. Every time a connection is established the server verifies that the user details are valid and every time a user executes a query the server will check that the user has sufficient privilege to execute that statement. Accordingly users already created during installation of the server or users created with other clients can be used by SQLyog and what SQLyog creates is available for other clients as well.