Other operations after migration:Disabled functions in PHP The code is as follows:Copy code Example, php_sapi_name, example, example, php_uname, exec, system, passthru, shell_exec, example, example, proc_close, proc_open, ini_alter, dl, example,
I. As in the previous article, install the Apache server
Ii. Install MySQL
1. Download
: Http://dev.mysql.com/downloads/mysql/
Download the following three files:
MySQL-server-5.6.11-1.rhel5.i386.rpm
MySQL-client-5.6.11-1.rhel5.i386.rpm
MySQL-devel-5
Solaris10LowerMySQLInstallation and maintenance
MySQL is a very popular database system in open-source software. However, it cannot be started successfully when it is installed on Solaris according to the installation manual provided on the MySQL
I. Introduction
I have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in windows and thought it would be
PHP Manual Build environment has many combinations, the version number is inconsistent, will lead to build failure.The combination I built is: php5.6+mysql5.6+apache2.4.First, PHP language pack downloadFirst download php5.6
MY.CNF configuration format is as followsVI my.cnf[Client]port=3306Socket=/tmp/mysql.socket[Mysqld]port=3306Server-id=1Datadir=/usr/local/mysql/data[Mysqld_safe]port=3306More parsemy.sh#!/bin/bashcnf=$ (CD ' DirName;p wd) "/MY.CNF"#得到区块数组g_sec= ('
Linux has just installed MySQL, tried to write a program to connect to MySQL, there are only local IP address to connect, and 127.0.0.1 and localhost can not accessSolve this problem main view 3 directions1 does the. hosts have IP mappings 2. Is the
1. Modify Redhat ENTERPRISE5 languageProblem Description: Switching languages
Cd/etc/sysconfigVI i18nWill Lang=en_us. UTF-8Change into lang=zh_cn.gb2312
2.bash:ifconfig:command not foundProblem Description:Switch to the
A. Downloadhttp://dev.mysql.com/downloads/mysql/Select the corresponding version, select "Linux-generic" hereTake the 64-bit system as an example, here are two files to
Question One
111217 23:23:57 Innodb:database is not shut down normally!Innodb:starting crash recovery.innodb:reading tablespace information from the ... ibd files ...innodb:restoring possible Half-written data pages from the
Solve the problem that the Chinese garbled under MySQL is all question mark
is also a headache of Chinese garbled problem, just start I have been using the local database test, this is no problem ah, not a problem, but I forget the Android and the
Change MySQL database storage path and port in Linux
Suppose we change to the/opt/data directory to pour:
1, opt directory to establish the data directory
Mkdir/opt/data
2, stop the MySQL service process
Mysqladmin-u root-p shutdown
3.
Below we understand some MySQL optimization foundation, MySQL optimization I divide into two parts, one is the server physical hardware optimization, the second is the MySQL itself (my.cnf) optimization.
The impact of server hardware on MySQL
Adjust the my.cnf parameters, reconfigure (the system default configuration is too high to directly occupy 400M of memory, small players can not afford to play it)
performance_schema_max_table_instances=200table_definition_cache=200table_open_cache=
First of all, it is an honor to find this article ...
If you have forgotten the MySQL password, try this method below.
1, open My.ini
The code is as follows
Copy Code
[Mysqld]port=3306#skip-grant-tables
Add
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.