MySQL Installation notes
After learning RedHat for a period of time, it is necessary to take notes. The following are the installation notes of MySQL,I hope you will correct the error.
● Install MySQL# Tar zxvf mysql-5.0.32.tar.gz#
Hello everyone! I haven't seen anyone for a long time. The last time I wrote a PHP chat room through file operations, of course, it was full of loopholes, and every time I refreshed the screen, it was terrible! I have been thinking for a long time.
For the description of the valid format of the value range of each type and the specified date and time value, see 7.3.6 Date and Time type.
Here is an example of using the date function. The following query Selects all records. The value of
I recently wrote some mysql stored procedures and functions, and found that there are few valuable documents on the Internet. Most of them are copied from the manual. Some practical problems cannot be solved, such as using variables as table names.
Mysql 3.0 Injection
The injection of mysql mainly relies on union queries, but union only applies to version 4. 0 or more useful, for 3. 0 or less will be useless ..........
Therefore, in mysql 3.0 databases, union cannot be used for cross-table
Two UPDATE injection modes (mysql + php)
Text/security Angel SuperHei 2005.8.11
I. test environment:
OS: Windows XP sp2
Php: php 4.3.10 (
Mysql 4.1.9
Apache 1.3.33
2. Test the database structure:----- Start ----- Database: 'test'--
-----------
By default, PHP sessions are saved through files. This has the following Disadvantages:
Session files are usually very small, but there are many files. It is a waste of space to save many such small files in the file system, and the efficiency is
Haha, haipi. I am thinking about how to write the IIS + PHP configuration tutorial. I accidentally found a video tutorial on the Internet, which really saves a lot of time, it's convenient for me. You can rest assured that the virus has been
Content Abstract: some experience in using MySQL services, mainly from the following aspects of MySQL service planning and design. For high-load sites, PHP and MySQL running together (or any application and database running together planning) is the
I. data definition language)
A document language is a language defined for the format and form of a document. It is the first thing that every database needs to create, the table relationships, column primary keys in the table, and the reference
Example I wrote
Copy codeThe Code is as follows: Require ("adodb/adodb. inc. php ");
$ Conn = newadoconnection ('mysql ');
$ Conn-> connect ("localhost", "root", "2027205", "bh38") or die ("connection failed ");
$ Conn-> execute ("set names gb2312 ")
In WINXP, APACHE2.052-win32 + php4.39-win32 + mysql4.022 is configured through
Apache, php4, and mysql can be accessed online,
I just wrote my own experiences for you to share.
(1) apache configuration
1. Install APACHE_2.0.52-win32, the default
Skip this step if you are completely new to the installation.
Find the ragnarok database directory under your Mysql database directory, for example, install Mysql inUnder the D: \ mysql directory, find the ragnarok database directory under the D: \
Unlimited classification is mainly implemented by storing the id and path of the upper-level classification. Because the structure of the data is simple, to display the classification relationship in a tree, I can only think of Recursive
System Configuration: win2000 English version + JDK1.4.1 + TOMCAT4.0.5 + APACHE2.043
Development cycle: the development cycle lasts for nearly 15 days.
Functions:
1. Gallery:
Submit, display, and delete images and related text by page.
2.
The MySQL administrator should know how to set up the MySQL user account and specify which user can connect to the server, where to connect, and what to do after the connection. MySQL 3.22.11 introduces two statements to make this work easier: GRANT
######################################## #######
This article is original. If it is referenced, please indicate the author's information.
Author: Cool-hearted madman
Email: edincur@yeah.net
Http://safebase.yeah.net
###################################
When accessing phpmyadmin, "mysql extension cannot be loaded. Check the PHP configuration ". Check that "php_mysql.dll" cannot be loaded.
For php 4.x users, follow discuz! 4.0 the user manual description in the program can be done in general. The
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