Tag: MySQL database

MySQL - show user grants
 

MySQL – show user grants

In MySQL, you can use the SHOW GRANTS statement to display all grant information for the user. This will display the privileges that have been assigned to the user with the GRANT command. Syntax...

MySQL - show user grants
 

MySQL rename user

The RENAME USER statement is used to rename a user in a MySQL database. Syntax of RENAME USER statement in MySQL RENAME USER user_name TO new_name; Parameters and arguments of the...

MySQL Change user password by SET PASSWORD statement
 

MySQL Change user password by SET PASSWORD statement

The SET PASSWORD statement is used to change a user password in a MySQL database. Syntax to change the password with the SET PASSWORD statement in MySQL SET PASSWORD [ FOR user_name ] = SET...

Check the configuration before starting the MySQL server
 

Check the configuration before starting the MySQL server

MySQL Server supports the validate-config option, which allows checking the startup configuration for problems without starting the server in normal operation mode:If no errors are found,...

MySQL function indexes
 

MySQL function indexes

MySQL indexes: Starting with MySQL 5.7, you can create indexes for expressions, or functional indexes using the generated columns. Basically you need to first use the generated column to define a...

MySQL DROP USER Statement
 

MySQL DROP USER Statement

The DROP USER statement is used to delete a user from a MySQL database. Syntax of DROP USER statement in MySQL DROP USER user_name; Options and arguments of the statementuser_name - the...

MySQL CREATE USER Statement
 

MySQL CREATE USER Statement

The CREATE USER statement creates a database account that allows you to log into a MySQL database. Syntax for CREATE USER statement in MySQL CREATE USER user_name IDENTIFIED BY [ PASSWORD ]...

 
2