mysql issues

MySQL has become one of the most widely used databases on the network, especially for Web applications. it occupies the absolute advantage of small and medium applications. All of this comes from its small and easy-to-use, secure and effective, open

1 Character Set issuesProblem: Executing the./manage.py createdb command in Django appears:Django.db.utils.OperationalError: (1366, "Incorrect string value: ' \\xC4\\x9A\\xC2\\x81vi ... ' for column ' file ' at row 1" )To view the MySQL

First, MySQL's character set problem is mainly two concepts, one is character sets, one is collations, the former is character contentand coding, which are some of the rules for comparing operations on the former. These two parameter sets can be

As far as my current tests are concerned, this vulnerability has two reasons:1. Use the default mysql installation method. The mysql User does not have the permission to access the configuration file/etc/mysql/my. cnf;2. If selinux or apparmor is

How to securely use MySQL has become one of the most widely used databases on the network. especially for Web applications, MySQL occupies the absolute advantage of small and medium applications. All of this comes from its small and easy-to-use,

There are many security questions about mysql database Elevation of Privilege, such as remote Elevation of Privilege, root user Elevation of Privilege, and usage of UDF security issues. Let's take a look at these questions. I. Usage of UDF security

1, problem one: Use update mysql.user set password= ' root ' change password, cannot log inWORKAROUND: The operating procedure is as follows.(1) Close MySQL (Kill the mysqld process), then use the command:Mysqld--skip-grant-tables(2) Start the

Installation RequirementsInstallation Environment: CentOS-6.3Installation method: Source code compiled and installedSoftware Name: mysql-cluster-gpl-7.2.6-linux2.6-x86_64.tar.gz: http://mysql.mirror.kangaroot.net/Downloads/Software Installation

13th. The extensible design of MySQL ReplicationObjective:MySQL Replication is a very distinctive feature of MySQL, and he is able to copy the data from one MySQL server Instance to the Instance of another MySQL server. Although the replication

Ibdata1 & mysql-bin Problem: Disk space alert, found that ibdata1 and Mysql-bin logs occupy too much space (where ibdata1 exceeds 120g,mysql-bin by more than 80G)Cause: IBDATA1 is the storage format, in InnoDB type data state, IBDATA1 is used to