Today, I set up a PHP environment on the local machine and recorded the process. The windows system configuration method is similar. The following describes the software used in this description:
Apache 2.2.4 -- www.apache.comPHP 5.2.0 --
Data Type
Description
Bytes
Recommended
Smallint
Integer in the range of-32000 to + 32000
2
Store relatively small integers.For example, age and quantity
Int
Integer in the range of-2000000000 to +
Original article: http://www.phpv.net/html/my.cnf_configure.html
From hi! A copy of the configuration copied by the admin. The notes are very good.
# Begin config info# Descr: 4 gb ram, only InnoDB, acid, a small number of connections, large
ArticleDirectory
Install the MySQL Module
Connect to database
Focus on inserting and updating data
Install the MySQL Module
Sudo easy_install mysql-Python Connect to database
1 # ! /Usr/bin/ENV Python 2 # Coding =
Shortly after I first came into contact with MySQL, I found that many enterprise-level functions were missing. I wanted to view the SQL statements executed by MySQL in real time, similar to the event probe in MSSQL. I searched for them online, the
Recently, the project used the data layer combination of hibernate3.0 C3PO MySQL, and the development and deployment were smooth. However, every morning when accessing the application, the cocould not open hibernate session for transaction exception
First, set the show database permission for this user.
Grant select, insert, update, delete on redmine1. *JIRA @ "%"Identified by" Jira ";
The syntax of the grant statement is as follows:Grant privileges (columns)On whatTo user identifiedby
Error message:InnoDB: Unable to lock./ibdata1, error: 11Solution:PS-Ef | grepMysqld, killing dead processes
Then restart MySQL
---------------------------------------------------------------------------------
Error message:Error while loading
Mysql itself does not have a Data Consistency Verification tool (mainly for master-slave). It is easy to see data inconsistency between master-slave, so someone developed such a tool, more famous is maatkit a series of tools, but the background it
Taking Windows XP, IIS 5.1t, and amfphp 1.9 beta 2 as examples, we will describe how to configure a web application that supports amfphp.
1. install PHP
1. Download
Download PHP 5.2.1 zip package at http://www.php.net/and decompress it to the
1. MySQL Command Line Mode settings:Desktop> my computer> Properties> environment variables> New>Path = "; path \ mysql \ bin;" where path is the bin path of MySQL.
(If there is a path, you can directly add the bin path of MySQL)
2. A brief
First, downloadMySQL connector/ODBC 3.51 downloads
Download the package and go to Control Panel> Management Tools> data source (ODBC). Double-click it and click Add,
Select MySql ODBC 3.51 driver
Then, the MySQL parameter configuration
1.PHP Use of arrays inIn operationDatabaseWhen using the associated array (Associatively-indexed Arrays) Very helpful. Let's look at a basic number format array traversal:
$ Temp [0] = "Richmond ";
$ Temp [1] = "Tigers ";
$ Temp [2] =
Select distinct. patientid,. patientcode,. patientsex,. mobileno,. homephoneno,. userage,. patientname,. patientidcard, date_format (. registdate, '% Y-% m-% D') as registdate,
Case when B. usedstarttime is not null and B. usedendtime is null then '
Problems with importing access data from MYSQL:
1. The encoding varies with MySQL clients.
It is best to install several more clients, such as MySQL-front, sqlyog, navicat, and MySQL GUI tool. Each has its own advantages. If you only install
Yesterday, I watched ghost.ArticleThe idea is good, but it feels too messy,There was another mistake. Maybe this old man has a tight schedule, so the exam is not comprehensive. Today I have reorganized it here, and I have done some experiments to
Friend host (Windows2003 + IIS +PHP+MySQL) Recently MySQL service process (mysqld-nt.exe)CPUThe usage rate is always 100%. This host has about 10 databases, which are called for 10 Websites respectively. According to a Friend test, lead to mysqld-nt.
The code I wrote is useless to the DB class library on the Internet. The class library is very powerful, but I have no time to learn it, I just want to write a few small functions I use. This code is reserved as a personal record.
All codes have
MySQL mysqldump is used for export. The basic usage is shell> mysqldump [Options] database [Tables]. If you do not specify any table, the entire database will be exported. Run mysqldump -- help to obtain the option table supported by your mysqldump
From: http://www.php100.com/html/webkaifa/database/Mysql/2011/0324/7781.html
What if MySQL forgets its password sometimes? I will give a case and explanation! Solve the problem!
The actual operations in windows are as follows:
1. Disable running
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