A brief introduction to mysqlrenamedatabase
release time：2023-12-05 23:37:25 i want to comment
This article will tell you about mysqlrenamedatabase and the corresponding knowledge points. I hope it will be helpful to you. Don’t forget to bookmark this site. List of contents of this article: 1. I want to change the name of the mysql database, how can I change it 2. How to change the table structure of the mysql database 3. How to change the name of the MySQL database 4. Five recent examples of renaming the mysql database I want to change The name of the mysql database, how to change the name of the MySQL database is as follows: Sentence modification method: RENAME DATABASE db_name TO new_db_name This syntax was added in mysql 7, and it was lost in 23. RENAME DATABASE db_name TO new_db_name this. This syntax was added in mysql 7 and lost in 23. It is said that there is a possibility of data loss. It is better not to use it. The method is as follows: open the folders where mysql.exe and mysqld.exe are located, copy the address, open the cmd call prompt, and enter the folder where mysql.exe is located in the previous step. Enter the call mysqld --skip-grant-tables and press Enter, and the user authentication of mysql is skipped at this time. The safest way is to enter the mysql installation directory and change the library name. System 2 controls mysqladmin, which is a special case declared later. mysqladmin -u root -p password mypasswd After entering this command, you need to enter the original password of root, and then the password of root will be changed to mypasswd. How to modify the structure of the mysql database table 1. Modify the method of the mysql database table mysqlrenamedatabase: use the "ALTER TABLE" statement to modify the structure of the original table, such as adding or deleting fields, modifying the original field data standard Type, rename field or table, change table character set, etc.; syntax "ALTER TABLE table name [change option]". 2. Install the APACHE environment, find the DATA directory of MYSQL, create a new folder, choose a name such as aaa, copy the above file, log in to PHPMYADMIN, you will find a database with mysqlrenamedatabase aaa, click export, save It can be an SQL file. 3. In particular, copy stored procedures and other content. Complicated systems are specialized tools, such as PHPMYADMIN, which can export programs without data. How to change the name of the MySQL database 1. Commonly, there are three ways: If all the tables are of the MyISAM standard type, you can directly change the name of the folder. 2. The safest way is to enter the mysql installation directory and change the library name. 3. RENAME DATABASE db_name TO new_db_name this. This syntax was added in mysql 7 and lost in 23. It is said that there is a possibility of data loss. It is better not to use it. Five basic examples of renaming the mysql database 1. Commonly, there are three main ways: If all tables are of MyISAM standard type, then mysqlrenamedatabase can directly change the name of the folder. 2. The safest method now is to recreate a new database mysqlrenamedatabase, and import the subsequent data tables into the new database. Various methods on the Internet (renaming folders, operating shell scripts, etc.) are all safe If there is a hidden danger, it is not recommended to manipulate it. If there is a better way, all gods are welcome to solve it. 3. Statement modification method: RENAME DATABASE db_name TO new_db_name This syntax was added in mysql 7, and it was lost in 23. 4. First of all, you need to find [SQL Server Configuration Device Manager] from the first menu. Then you will see [SQL Server (MSSQLSERVER)] is running. Right click on it and [Restart] task process. Then open sql2012, select a database, right-click [Rename]. 5. Method 1: Modify the prefix name of the mysql database table by using the sql statement. First of all, mysqlrenamedatabase is what we think of using the sql query statement to modify it. After entering, enter the following language name in the run SQL query box. 6. Restart mysql, now the authorization of mysql is the same as that of the newly installed one, log in with an empty password, and then adjust the authorization by yourself. 6 If there is a backup, check the integrity of some databases in China to prevent them from being altered. The introduction to mysqlrenamedatabase is over here, do you know if you have found the information you need? If you want to know more information about this, remember to bookmark and pay attention to this site.