Detailed introduction to the method of forgetting the password, resetting the password, and ignoring the case of table names and column names in MySQL under Linux system

This article introduces the Linux systemMySQLforget the password, reset the password, and ignore the case of table names and column names. Friends in need can refer to the following

When MySQL has just been installed on a linunx system and you forget the password you set or the password cannot be set during the installation process, try to guess the commonly used passwords, such as: 1,11,111,1111,11111,111111,123456,000000,1234321, etc. I tried the simplest default password, but it turned out that it was not correct even after trying it all. I still couldn't enter mysql. The reason may be that the password you set was relatively complex and was later forgotten. The more likely reason is that you were not allowed to set a password during the installation process. Such a password is usually a large string of uppercase and lowercase letters, numbers and symbols randomly generated by MySQL. complex password. Such a password does not need to be tried in vain. This needs to be solved in a special way, which is to change the configuration file /etc/my.cnf.

Steps:

1. Enter su - and password to enter root permissions.

2. Stop MySQL and enter service mysqld stop

3. Enter vi /etc/my.cnf and enter the configuration file my.cnf for editing

4. Find [mysqld] and add a line below skip-grant-tables=1

5. The mysql newly installed in the Linux system is generally sensitive to the case of the database table name. Yes, you can add another line

lower_case_table_names=1 under [mysqld], which means ignoring case, and equal to 0 means it is case sensitive

6. Cursor movement Go to the bottom, enter: wq (with colon) to automatically save and exit

7. Start mysql, enter service mysqld start

8. Enter mysql -uroot -p, when prompted to output the password, directly Press Enter and ignore it, you can enter

9. Enter use mysql;

10. Change the password. Enter update user set password=PASSWORD('12345678') where user="root"; ---Set the root password to 12345678

11. Enter exit to exit

12. Don’t forget to unmark skip-grant-tables=1, enter vi /etc/my.cnf again, find the skip-grant-tables=1 you just added, add # in front of it, :wq, exit and save. out.

13. Restart mysql, service mysql restart,

14. Enter mysql -uroot -p again, enter the password 12345678, the login is successful!

Note:

After mysql is installed under Linux, it is the default: table names are case-sensitive, but column names are not case-sensitive.

After logging in with the root account, add lower_case_table_names=1 after [mysqld] in /etc/my.cnf, restart the MYSQL service, and the setting is successful: the table names are case-insensitive.

0: case-sensitive, 1: case-insensitive

MySQL's case rules for database names, table names, column names, and aliases under Linux are as follows:

1. Database names and table names are strictly case-sensitive;

2. Table aliases are strictly case-sensitive;

3. Column names and column names Aliases are case-insensitive in all cases;

4. Variable names are also strictly case-sensitive;

MySQL is not case-sensitive under Windows Write.

The above is the detailed content of Detailed introduction to the method of forgetting the password, resetting the password, and ignoring the case of table names and column names in MySQL under Linux system. For more information, please follow other related articles on the PHP Chinese website!