How to create username and password in mysql

How to create username and password in mysql: Execute the [CREATE USER 'username' IDENTIFIED BY 'password';] statement to create it successfully.

SQL statement:

(Recommended tutorial: mysql video tutorial)

CREATE USER '用户名' IDENTIFIED BY '密码';

Such as:

CREATE USER 'kfcx' IDENTIFIED BY 'kfcx123';

What should I do if I forget my Mysql password?

1. Stop the mysql service

2. Open the command line window and execute it in the mysql installation directory bin

mysqld-nt --skip-grant-tables

Such as:

D:mysql\bin\mysqld-nt --skip-grant-tables

3. If it is For mysql5.0 or above, you can directly double-click mysql.exe

4 in the bin of the mysql installation directory. 4. use mysql --select the mysql database

  update user set password=password('新的密码')where user='要修改密码的用户名';
   flush privileges;
   exit;

5. Kill the mysqld-nt process and restart mysql. Just log in to the service with a new password.

Related recommendations: mysql tutorial

The above is the detailed content of How to create username and password in mysql. For more information, please follow other related articles on the PHP Chinese website!