Sets the primary key (increment field) start value of the database table

Alter table Table name AUTO_increment = Start valueCopy the code

Such as:

Forgot your database password? What do I do

  • If you have checked remember password before connecting to the database, it is possible to connect to the database, but to connect through code, how to do?

    • Mysql > select * from user where user = user
    • usingselect password()Calculate the encrypted value of the new password

    • Modify the password field in the user table

    • Don’t forget to refresh the PRIVILEGES Flush PRIVILEGES

    • Test the connection