mysql grant user access to database workbench

Most of the columns of the user table that store the values like boolean i.e either true or false have the datatype of an enum having values ‘Y’ that stands for true and ‘N’ that specifies false i.e enum(‘N’,’Y’) datatype that informs whether the certain privilege is assigned to the user or not. Then, in that case, you can choose privilege related columns as done in the following SELECT query:Įxplanation: Similarly, other columns can also be retrieved whichever you want using the select query. Step 4: Suppose, you want to retrieve assigned privilege-related information of the users. To retrieve more information about users, we can add the columns we want to retrieve in the select query as follows:

Step 3: To retrieve the data from the user table of the MySQL database, you first need to login to MySQL using MySQL -u root pg command if you are using MySQL from command-line through terminal or by entering the credentials in case if you are using any IDE or editor such as sqlyog of workbench.Īn alternative to using the above select query, you can firstly fire the command to select the MySQL database and then simply fire the following select query that will produce the same output as above: Step 2: We will first retrieve the names of all the users from the user table using the following SELECT query:Įxplanation: We can see that four users are present for my database server. If your current chosen database being used is MySQL or you can use: Step 1: To view the complete list of the columns of the user table you can describe the user table using the following query: Some of them are user, host, ssl_type, ssl_cipher, max_questions, max_connections, authentication_string, password_expired, account_locked, password_lifetime, password_last_changed, and other columns related to privileges assigned to the user for different database operations. This table contains a total of 45 columns to store user information. User-related information in the user tableĪs discussed previously, there is a database named MySQL that stores the user-related information in the table named user.

Hadoop, Data Science, Statistics & others 1.

Mysql grant user access to database workbench