MySQL

MySQL database in the use of the process will often appear password forgotten, or password verification failed, the occurrence of a situation, I summarized here the following two ways:The first method:Error code:Mysqladmin:connect to server at '

First step: [[email protected] ~]# Yum List | grep MySQL View package information for MySQL databaseStep two: [[email protected] ~]# yum-y install mysql-server mysql mysql-devel installing MySQL packetStep three: [[email protected] ~]# Rpm-qi

Novice Road-mysql InstallationDirectory structure Windows platform MySQL Installation Sample Data Import Linux Platforms CentOS System Ubuntu system FAQ Password Generation

A site that uses a MySQL database, "Too many connections" error occurs when there are too many access connections. There are two cases of this error, one is that the Web site access is too large, the server can not afford, at this time should

ObjectiveIn the database is a sheet of inextricably linked tables, so the table design is good or bad, will directly affect the entire database. While designing the table, we will focus on one issue and what storage engine to use. Wait a minute,

Grant WGDP user Query permission: Grants select on wg_dp.* to ' WGDP ' @ '% ' identified by ' weigou123 ';Grant all privileges on * * to' Yangchao ' @ '% 'identified by ' weigou123 'Query MySQL Other user rights: show grants for WGDP; cancel WGDP

1. Use the Explain statement to view performance mysql> explain select product_id from Orders where order_id in (123, 312, 223,, 224) \g2. Why create a composite index? If there is only one index, the 2 query criteria will first go to the index to

1. Check the MySQL character setting: If it is not GBK, make the relevant settingsMysql>set character_set_client =gbk ;Mysql>set character_set_connection = gbk;Mysql>set character_set_database = gbk ;Mysql>set

Alter Table' User_movement_log 'ADD columnGatewayidint not NULL default 0After ' RegionID ' (which field is added later)Alter TableX_connectionAdd' FEX-N752 'varchar(Ten)default NULL;//PRIMARY KeyAlter TableTabelnameAddnew_field_idint(5)

Just learned a few days of PHP, and then just have a backstage management project to do, holding the purpose of learning PHP, it is intended to use PHP to start writing. Backstage is to several tables to make additions and deletions to check and

Configuration   Installation of MySQL under Linux RMP-IVH mysql-server-4.1.22-0.glibc23.i386.rpm--NODEPSRMP-IVH mysql-client-4.1.22-0.glibc23.i386.rpm--nodeps See if the installation succeeds NETSTAT-ATLN command see 3306 Port Open instructions

Environment: CentOS 6.5[[email protected] software]# yum -y install gcc gcc-c++[[email  protected] software]# tar -zxvf cmake-2.8.5.tar.gz[[email protected] software]#  cd cmake-2.8.5[[email protected] cmake-2.8.5]# ./configure --prefix=/usr/local/

Implementation features: Upload Excel files and import them into the database according to the formatFind Phpecel on the internet but Phpexcel is too big, its own limited ability is not very good to streamline, finally found phpexcelreader this

First, the main advantagesThe concept of dual-machine hot standby simply say, is to maintain the status of two databases automatically synchronized.Operations on any one database are automatically applied to another database, keeping two of the

First, installation environmentoperating system:LinuxMysql version:mysql-5.6.24Second, the required softwareMysql-5.6.24.tar.gzthird, installation steps(1) Upload the installation packageMkdir/usr/setupupload mysql-5.6.24.tar.gz to /usr/setup(2)

1: Delete column ALTER TABLE "table name" DROP "column name" 2: Add column ALTER TABLE "table name" Add "column name" INT not NULL COMMENT ' comment description ' 3: Modify column type information "ALTER TABLE" table name Word "Change" column Name "

SameShowThe timestamp column is displayed in the same format as the datetime column. In other words, the display width is fixed at 19 characters, and the format is Yyyy-mm-dd HH:MM:SS.DifferentRangedatetime Retrieves and displays datetime values in

20 + best experiences in MySQL performance optimization (1) Today, database operations are increasingly becoming the performance bottleneck of the entire application, especially for Web applications. Concerning the database performance, this is not

MySQL database recovery (using the mysqlbinlog command)MySQL database recovery (using the mysqlbinlog command) 1: Enable binlog LoggingModify the mysql configuration file mysql. ini and add it under the [mysqld] node.Copy the Code as follows: #

Mysql database notes-Basic queries (grouping and Aggregate functions) Select count (*) FROM T_Employee WHERE FAge = 23; // view the number of students alter table T_Employee ADD FSubCompany VARCHAR (20); alter table T_Employee ADD FDepartment