1, check and modify the MySQL my.ini configuration file
Copy Code code as follows:
Default-character-set=utf8
2, the establishment of the database is to specify the character set
Copy Code code as follows:
Because my MySQL did not know why suddenly can't open and reported a 10061 error, check the next reason is because the database is connected to conflict, the trouble died so reload, in the last step of the start service stopped, installation failed,
See Example:Data table collect (ID, title, info, VType) on these 4 fields, which title with fixed length, info with text, ID is gradual, VType is Tinyint,vtype is index. This is a simple model of the basic news system. Now fill in the data and fill
If you are accustomed to using Windows database, that is, in the graphical interface to manipulate the database, then when you operate on the command MySQL will be unfamiliar, in fact, as long as you master some basic commands, and often used,
In the script you can set up a list of database tables that need to be backed up, and the backup files will be compressed by gzip. It should be noted that this script only applies to environments where data consistency requirements are not high.
method One: the best approach is to change the float field to decimal (16,6). Specific methods: You can set a temporary field, combined with the MySQL keyword binary for accurate replication and so on.
method Two: use binary keyword to solve. The
This article analyzes the process of mysqld process shutdown, and how to safely and gently close the MySQL instance, the process is not clear to the students can refer to.
Shutdown process:
1, initiate shutdown, send out sigterm signal
2, if
In the MySQL data type, the range of tinyint is: The signed range is 128 to 127. The unsigned range is 0 to 255 (see official "MySQL 5.1 reference Manual" http://dev.mysql.com/doc/refman/5.1/zh/column-types.html).
The tinyint occupies 1 bytes of
Environment:
Os:windows 2003
db:mysql5.5
1. Normal installation of the first MySQL (Installation steps omitted)
2. Stop the first MySQL service in the control Panel
3. Copy all directories and files under the C:\Program files\mysql directory to
Use the load command in MySQL to load the contents of the TXT file into a database table, for example, to create a table, the name is User, a field username; there is currently a db.txt file with a space-separated username, for example: Xiaowang
View database status:service mysqld Status
Start database:service mysqld start
Access to the database:mysql-u root-p123456;
List database: showdatabases;
Select database: UsedatabaseName;
List table: showtables;
Displays the properties of the
First, the environment description:
Copy Code code as follows:
[ROOT@BEANVM ~]# Cat/etc/redhat-release
Red Hat Enterprise Linux Server Release 6.2 (Santiago)
[ROOT@BEANVM ~]# Uname-a
Linux BEANVM 2.6.32-220.el6.i686 #1 SMP Wed
In the database, the most significant performance impact includes the database lock policy, caching policy, indexing policy, storage policy, and execution plan optimization strategy.
The indexing policy determines the efficiency of the database to
This two-day project has a problem, limit use after the error.
The demand is like this, I have 3 tables, infor information table, mconfig material configuration table, maaply material request form, request to read out which person in the
1, view log situation
Copy Code code as follows:
Mysql> show global variables like '%log% ';
+---------------------------------+---------------------------------+
| variable_name | Value |
+---------------------------------+------------
Modify Password:
Copy Code code as follows:
Select Database
Use MySQL;
Modify password
Update user set Password=password (' New password ') where user= ' root ';
Take effect immediately
Flush Privileges
Forget administrator
MySQL add field:
ALTER TABLE ' User_movement_log '
add column Gatewayid int not null default 0 after ' RegionID ' (added after which field)
To delete a field:
ALTER TABLE ' user_movement_log ' drop column Gatewayid
To
1. Open the terminal, input: cd ~
Will enter the ~ folder
2. Then enter: Touch. Bash_profile
When a carriage return is executed,
2. Re-enter: Open-e. bash_profile
This file is opened in TextEdit (if you have not previously configured an
MySQL Index overview
All MySQL column types can be indexed. Using indexes on related columns is the best way to improve the performance of select operations. Defines the maximum number of indexes and the maximum index length per table based on the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service