今天朋友在做某个程序项目时,需要修改MySQL修改默认字符集,搞不好找我帮忙。百度了试了好几篇博文中的方法,最后终于成功了。但是感觉那些博文思路有点乱,所以自己总结下,希望可以帮到遇到同样问题的人。
原创博文地址:http://www.cnblogs.com/xingyunblog/p/3836299.html
好了,下面言归正传:
修改MySQL修改默认字符集,一共有两种方法。
一种是通过修改my.ini文件配置,一种是通过mysql命令。
(不过推荐第一种方法,因为第二种好像不太奏效,因为我测试时,当通过命令修改成功后再次打开时发现又自动恢复原来的字符集啦。)
*************************************************************
第一种方法:
1.首先找到你的MySQL安装路径,比如我的安装路径是:
D:/Program Files/MySQL/MySQL Server 5.1
2.打开my.ini文件,修改[mysql]处的默认字符集和[mysqld]处的默认字符集,我这里已经把原来的latin1修改成utf8啦。
3.修改好后保存文件,并重启mysql服务即可。
第二种方法:通过mysql命令修改。
1.按下快捷键ctrl+r,打开运行窗口,输入cmd后回车。
2.输入"d:"后按下回车键,进入D盘根目录。
3.切换到mysql安装目录,输入命令:
cd D:/Program Files/MySQL/MySQL Server 5.1
4.登陆数据库,输入命令:(注意-u和root之间没有空格,-p和密码之间也没空格)。
mysql -uroot -p密码
5.出现下图所示,说明登陆成功。
6.查看当前mysql默认字符集命令:
show variables like 'character_set%';
7.输入下列命令进行一个一个修改即可。
mysql> set character_set_client=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_connection=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_database=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_results=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_server=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_system=utf8;Query OK, 0 rows affected (0.01 sec)mysql> set collation_connection=utf8;Query OK, 0 rows affected (0.01 sec)mysql> set collation_database=utf8;Query OK, 0 rows affected (0.01 sec)mysql> set collation_server=utf8;Query OK, 0 rows affected (0.01 sec)
8.查看当前mysql字符字符集命令:
mysql> show variables like 'character_set_%';
************************************************************************
mysql服务重启方法有两种:
1.dos命令;
2.图形用户界面操作。
************************************************************************************************
第一种方法:通过dos命令
1.按下快捷键ctrl+r,打开运行窗口,输入cmd后回车。
2.停止mysql服务命令:
sc stop mysql
3.开启mysql命令:
sc start mysql
*****************************************************************************
第二种方法:图用用户界面操作。
1.鼠标左键选中我的电脑,右键单击后选择管理;
或者按下快捷键ctrl+r,打开运行窗口,输入命令:
services.msc
2.在“服务和应用程序”下找到服务,具体如图所示:
关于这个问题其他写的相对好点的博客:MySQL修改默认字符集

InnoDBBufferPool reduces disk I/O by caching data and indexing pages, improving database performance. Its working principle includes: 1. Data reading: Read data from BufferPool; 2. Data writing: After modifying the data, write to BufferPool and refresh it to disk regularly; 3. Cache management: Use the LRU algorithm to manage cache pages; 4. Reading mechanism: Load adjacent data pages in advance. By sizing the BufferPool and using multiple instances, database performance can be optimized.

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.

MySQL is worth learning because it is a powerful open source database management system suitable for data storage, management and analysis. 1) MySQL is a relational database that uses SQL to operate data and is suitable for structured data management. 2) The SQL language is the key to interacting with MySQL and supports CRUD operations. 3) The working principle of MySQL includes client/server architecture, storage engine and query optimizer. 4) Basic usage includes creating databases and tables, and advanced usage involves joining tables using JOIN. 5) Common errors include syntax errors and permission issues, and debugging skills include checking syntax and using EXPLAIN commands. 6) Performance optimization involves the use of indexes, optimization of SQL statements and regular maintenance of databases.

MySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

MySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.

SQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.

The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

Atom editor mac version download
The most popular open source editor

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment