1. install Apache
Modify the configuration file httpd. conf after the apache_2.2.8-win32 installation is complete
Open the conf folder in the installation directory, find and open the httpd. conf file for configuration.
① Locate DocumentRoot
Introduction: This is from PhP MySQL.ArticleThe details page of the management system describes PHP, related knowledge, skills, experience, and some PHP source code.
Class = 'pingjiaf' frameborder = '0' src = 'HTTP: //
I have encountered this problem and I have been looking for a long time to solve it. I want to help you!
Operating System: WINDOWS-XP System
Database Version: MySQL 5.x
Tip: Access denied for user 'root' @ 'localhost' Using password yes/no
It
Today, when I log on to the management backend of the Internet site, a prompt is displayed.MySQL error: Can't create/write to file' # SQL _5c0_0.myd'MySQL server error:Can't create/write to file 'C:/WINDOWS/TEMP/# SQL _a80_0.myd' (Errcode: 17)
MySQL provides different storage engines for different functional requirements. The so-called storage engine is the specific implementation of specific interfaces in MySQL.
FEDERATED is a specific implementation of remote databases. Generally, when
Enable slow log
There are two activation methods:
1. In my. cnf, log-slow-queries [= file_name]2. When the mysqld process is started, specify the five common tools to be compared using the -- log-slow-queries [= file_name] Option.
Mysqldumpslow,
SQL lock table and unlock mysql tutorial statements
For MySQL, there are three lock levels: page-level, table-level, and row-level.
A typical page-level engine is BDB.A typical table-level engine is MyISAM, MEMORY, and ISAM, which was a long time
Script in/home/user/mysql tutorial _ backup. sh
Crontab
# Crontab-l
# M h dom mon dow command
28 16 ***/home/user/mysql_backup.sh
The script is as follows:
#! /Bin/sh
# Mysql_backup.sh: backup mysql databases and keep newest 5 days backup.
#
# Last
There are many ways to delete duplicate records. Here I summarize a variety of SQL statements for deleting restart records, such as deleting duplicate id data and searching for duplicate records, remove the smallest record, delete the repeat record,
This article will share with you a good tutorial on configuring Linux MySQL master-slave Replication (Replication) (MySQL Data Synchronization). Thank you for your reference.
MySQL is an open-source relational database system. Replication is a
SQL Server has many useful small functions, but sometimes these functions in turn cause you trouble. One of these problems is the use of Alias users. This tip teaches you how to find a security vulnerability when creating an alias user in a database.
Fire Station building school (bkjia.com) MySQL newsMySQL released the latest stable version 5.1.33 of the 5.1 series this morning. This is the third version after the official GA version of The November 26 last year series was released in 5.1. The
With regard to the Mysql database BACKUP method, helper's editor summarizes all the current BACKUP methods, including mysqldump, mysqlhotcopy, backup table, SELECTOUTFILE, or binlog backup, or directly copy data files and related configuration files.
Although order by does not match the ORDER of the index, the index can still be used, as long as the unused index part and all the additional order by fields are included in the WHERE clause.Use the index MySQL OrderThe following queries use indexes
In MySQL, The While statement loop is different from that in SQL Server, and the code passes the test.In MSSQL, The while statement is used to generate data cyclically:Sample Code:Copy codeThe Code is as follows:Declare @ a intSet @ a = 1While @ a
DATE_ADD (Date, INTERVALExpr Type) DATE_SUB (Date, INTERVALExpr Type)
These functions perform date operations.DateIs a DATETIME or DATE value, used to specify the start time.ExprIs an expression used to specify the time interval value added or
Mysql my. ini configuration file details# BEGIN CONFIG INFO# DESCR: 4 gb ram, only InnoDB, ACID, a small number of connections, large queue Load# TYPE: SYSTEM# END CONFIG INFO## This mysql configuration file example is for 4 GB memory# Mainly use
Related methods:Service mysqld stopOrKillall-TERM mysqldNext, run the following command to restart mySQL:/Usr/bin/safe_mysqld -- skip-grant-tables &(Please pay attention to your itinerary. Please turn it into your program path)Start mySQL and type:
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