We can change MySQL User Password by using three methods.
1. Alter User Method
2. SET PASSWORD method.
3. Update User method.(This method deprecated from 8.0.11 onwards)
Change MySQL User Password Examples:
1. Create a MySQL User:
CREATE USER amith IDENTIFIED BY 'Amith@321';
2 .Change Password by using Alter User Method:
Continue reading How to Change MySQL User Password
We can create user in MySQL Server by using CREATE USER statement. For each account, CREATE USER creates a new row in the mysql.user system table. To create user in MySQL Server, user must have CREATE USER privileges.
Syntax to Create User in MySQL:
CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... DEFAULT ROLE role [, role ] ... [REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ... user: (see Section 6.2.4, “Specifying Account Names”) auth_option: { IDENTIFIED BY 'auth_string' | IDENTIFIED WITH auth_plugin | IDENTIFIED WITH auth_plugin BY 'auth_string' | IDENTIFIED WITH auth_plugin AS 'auth_string' }
Examples Create User in MySQL:
Continue reading Create User in MySQL
In this tutorial, we are going to see how to Start and Stop MySQL Server on CentOS operating system. Privileges required to start or stop or restart MySQL Server, user must be superuser.
We can start, stop, and restart the MySQL Server from Linux shell and We can stop and restart MySQL Server Shell.
To check the MySQL Server status execute either of two commands from Linux shell:
service mysqld status
systemctl status mysqld
Continue reading How to Start and Stop MySQL Server on CentOS