mysql cnf

Mysql master-slave database synchronization environment: Master server: centos 5.2 mysql 5.1.35 source code IP: 192.168.1.22 Slave server: centos 5.2 mysql 5.1.35 source code IP: 192.168.1.33 Configuration: I. master server 1.1 Create a replication user with the replication slave permission. Mysql> grant replication sl

directoryThe default data file storage directory of MySQL is/var/lib/mysql. To move the directory to/home/data, perform the following steps:1. Create a data directory under the home DirectoryCd/homeMkdir data2. Stop the MySQL service process:Mysqladmin-u root-p shutdown3. Move the entire/var/lib/mysql directory to/hom

I. Linux kernel and released version uname-acatetcissue II. glibc version liblibcso6 --- dynamic link library without man function data III. MySQL version MySQL binary distribution version file name format: mysql-VERSION-OStargz for example: Linux-Gener 1. Linux kernel and release VERSION Uname- Cat/etc/issue II. glibc version /Lib/libc. so.6 --- dynamic link li

/chkconfig-del mysql Change MySQL directory The default data file storage directory of MySQL is/var/lib/mysql. To move the directory to/home/data, perform the following steps: 1. Create a data directory under the home Directory Cd/home Mkdir data 2. Stop the MySQL service pr

this ......The mysql_install_db script only needs to be run once during the initial installation, and does not need to be run any more. I set MySQL. server copy to/etc/rc. d/init. d/, run chkconfig MySQL. the MySQL server starts automatically every time it starts up. You only need to set the path and enter MySQL on th

Document directory 17.2.1 start and set binary logs 17.2.2. View binary logs 17.2.3 Delete binary logs 17.2.4. Restore the database using binary logs 17.2.5. temporarily disable the binary log function. 17.3.1. Start and set error logs 17.3.2. View error logs 17.3.3 delete error logs 17.4.1. Start and set general query logs. 17.4.2. View error logs 17.4.3. Delete common query logs. 17.5.1. Start and set slow query logs. 17.5.2. View slow query logs. 17.5.3 Delete slow query logs

Analysis of MYSQL Chinese input in Ubuntu BitsCN.com MYSQL in Ubuntu is installed with apt-get, and the configuration process is skipped. Therefore, Chinese characters cannot be entered by default. 1. find the cnf file location of MySQL. Find/-iname '*. cnf '-print/etc/ssl/o

/dataMkdir-p/u01/app/mysql/data/mysql3306/logMkdir-p/u01/app/mysql/log/mysql3306/iblogMkdir-p/u01/app/mysql/log/mysql3306/binlogMkdir-p/u01/app/mysql/data/mysql3306/tmp5. Configure my. cnfCp/usr/my. cnf/u01/app/mysql/data/mysql330

Operating system environment: RHEL4.6 and MySQL 6 Symptom: Tomcat is installed on this computer as a web server, and a project is deployed to connect to the mysql database through jdbc. However, Chinese input and output are garbled. Solution: 1. Find the mysql configuration file The mysql configuration file is/etc/my.

debian is simple and has apt source.2) add MySQL to the startup service group of your system.[Root @ test1 local] #/sbin/chkconfig? Add mysql3) delete MySQL from the startup service group.[Root @ test1 local] #/sbin/chkconfig? Del mysql 　7. change the MySQL Directory The default data file storage directory of

Command provided in the official documentation does not provide the -- basedir and -- datadir parameters, because it uses the/etc/my. cnf configuration file by default. Some Linux distributions may generate the mysql configuration file and save it in the/etc directory by default during installation, while basedir and datadir in the default configuration file are commented out, there is no actual content, s

.150610 17:04:37 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist150610 17:04:37 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysql/rh55.pid ended View the mysql configuration file: [Root @ rh55 ~] # Cat/etc/my. cnf [mysqld]port = 3306socket = /

fail, The second is to ensure that the mysql account has the "writable" permission on the mysql database directory, not the "writable" permission, To ensure that there is no accident, it is best to delete the old mysql-bin and mysql logs before mysql, and then restart

database configuration file Run show variables like 'basedir' on the console if my. ini in the MySQL installation directory does not know the installation directory. Locate # server section [mysqld]. The previous # server section indicates that the following configuration is for the MySQL SERVER. Slave database configuration file Yes. The/etc/my. cnf/etc folde

/local directory 5. Unzip the tar zxvf mysql-5.0.45-linux-i686-icc-glibc23.tar.gz 6. ln-s mysql-5.0.45-linux-i686-icc-glibc23 mysql 7. cd/usr/local/mysql 8. chown-R mysql. 9. chgrp-R mysql. 10. scripts/mysql_install_db -- user =

a lot of disk I/O, and thus a lot of time. When data must be connected, this problem is more complicated, because multi-row data at both ends of the connection must be compared. Of course, table scanning does not always cause problems. sometimes reading the entire table is more effective than selecting a part of the data from it (the query planner in the server process is used to make these decisions ). If the index is very inefficient or cannot be used at all, the query speed will be slowed do

// install the dependency package[Root @ localhost xtrabackup] # rpm-ivh percona-xtrabackup-2.2.4-5004.el6.x86_64.rpm // reinstallWarning: percona-xtrabackup-2.2.4-5004.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEYPreparing... ######################################## ### [100%]1: percona-xtrabackup ##################################### ###### [100%] Note: Xtrabackup 2.2.4 does not support mysql 5.1.73. Therefore, if you want to

Mysql entry-level series: running multiple MYSQL servers most people run a single MySQL server on a specified machine, but in some cases, running multiple servers is advantageous: You can test the new version of server when the finished server is running. In this case, different servers will run. The operating system usually limits the total process on the numbe

for Windows Japanese | 3 | + ---------- + Japanese + -------- + above view MySQL character set commands, applicable to Windows and Linux. 1. find/-iname '*. cnf '-print/usr/share/mysql/my-innodb-heavy-4G.cnf/usr/share/mysql/my-large.cnf/usr/share/mysql/my-small.cnf/usr/shar

/chkconfig-del mysql 7. Change the MySQL directory The default data file storage directory of MySQL is/var/lib/mysql. To move the directory to/home/data, perform the following steps: 1. Create a data directory under the home DirectoryCd/homeMkdir data 2. Stop the MySQL servi