Today, when a friend is doing a program project, I need to modify MySQL to modify the default character set, can not find me help. Baidu has tried several blog posts in the method, and finally succeeded. But feel those blog post ideas a bit messy,
1. Install MySQLsudo apt-get install Mysql-server 2. Modify the MySQL root user passwordThe root user does not have a password after the default MySQL installation, so first use the root user to enter:$mysql-U root-pMysql>use MySQL; Update user set
MySQL Character set settings• System Variables:–character_set_server: Default internal operation character Set–character_set_client: The character set used by the client source data–character_set_connection: Connection Layer Character
TIMESTAMP the default value for the setting is Current_timestampTIMESTAMP settings automatically update as the table changes is on update current_timestampBut becauseThere can be at most one field set in a table Current_timestampIt is not possible
1, every time after a period of online business will appear the following error:kHost ' XXXXX ' is blocked because of many connection errors; unblock with ' mysqladmin flush-hosts ' Connection closed by foreign host2, need to use mysqladmin
MySQL UninstallYum remove MySQL mysql-server mysql-libs compat-mysql51Rm-rf/var/lib/mysqlRm/etc/my.cnfSee if you have MySQL software:Rpm-qa|grep MySQLSome words continue to deleteMySQL Installation1> If you do not have a local installation package,
When inserting data into MySQL in the project, it was found that the data was not inserted completely, and through debugging, it was found that there were no special errors in the INSERT statement. But it's not going to go in, so open the mysqli
1. Connect Server Login>mysql-h 192.168.0.11-u Root-p2. Modify User Password>mysqladmin-u root-p 654321 Password 1234563. User Rights Management1) The grant command is used to add new users and control their permissions.Grant
Direct backup mysqldump-u user name-p password-h 192.168.1.15-c--default-character-set=utf8 database name >XXX.SQL use gzip compressed backup mysqldump-u user name-p password -H 192.168.1.15-c--default-character-set=utf8 database name | Gzip
EnvironmentCentosMysql 5.1PremiseEpel installed, please refer to the specific installation procedure.http://blog.csdn.net/robinsonmhj/article/details/36184863List of machines
Machine IP
Machine name
192.168.0.135
1.1.1. ERROR 1665 (HY000)"Environment description"msyql5.6.14"Error Message"Error when executing SQL statement:ERROR 1665 (HY000): Cannot executestatement:impossible to write to binary log since Binlog_format = Statementand at least One table uses a
Lamp is a public structure, linux+apache+mysql+php.In the architecture of our system, we have made further progress, linux+apahce+mysql+php+gearman+c
PHP as a page display
Core business logic is implemented by C language, and PHP calls
Original: Batch command bat back up MySQL databaseWorking Environment Windows Server 2003, MySQL installation directory D:\MySQL, WinRAR installation directory C:\Program Files\winrar\winrar.exeThe path to the backup data store is a e:\ data backup,
Related software Download:Apache version: (httpd-2.2.25)PHP version: (php-5.4.24)MySQL version: (mysql-installer-community-5.6.19.0)Configuration Apache:After the Apache HTTP Server installation is complete, the service will start automatically ,
Numeric typeMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of
1. Operating systemCentOS Release 6.2 (Final)2. Create users and Groups[[email protected] ~]# Groupadd MySQL[Email protected] ~]# useradd-r-G mysqlmysql3. Unzip the installation package (unzip to where you want to store the database data)[Email
MySQL contains BLOB fields is a very troublesome thing, export import inconvenient. I'll show you how I do it.1, in MySQL My.ini last add a line configuration Max_allowed_packet = 100M, restart the MySQL serviceAccording to the actual situation to
A novel method for modifying the database name in MySQL.
MySQL introduced a rename database operation in MySQL 5.1, but does not support this command after MySQL5.1.23. It can be said that it is an experimental function, not supported in production (
Share various high-availability technologies in MYSQL (derived from jiangchengyao) and mysql jiangchengyaoShare various high-availability technologies in MYSQL (from Jiangcheng yaoda NIU)
Images and materials from MYSQL Daniel Jiang chengyao (author
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