Phenomenon 1
Found in PHP error log:PHP Warning:mysqli::mysqli (): (hy000/2003): Can ' t connect to MySQL server on ' XXX.XXX.XXX. XXX ' (In/u1/www/xxxx.php on line 10PHP Warning:mysqli::close (): couldn ' t fetch mysqli in/u1/www/xxxx.php on line 1
SET sql_mode= "No_auto_value_on_zero"; ----Database Tutorial: ' MySQL tutorial new '-- -- -------------------------------------------------------- ----The structure of the table ' test '-- CREATE TABLE IF not EXISTS ' test ' (' ID ' int (a) not NULL
Cause: It's too slow to make count (*) statistics on the InnoDB table, so find a way to see if it's going to be faster.
Phenomenon: First look at a few test cases, as follows
First, the test on the Sbtest table
Show CREATE TABLE Sbtest\g1. Row ***
The connection parameter connects to a server and must specify the connection parameters, such as user name, host name, password, port number, socket. The MySQL utilities provides three ways to provide these parameters, all of which need to be
My WordPress database Wp_postmeta table has more than 10,000 lines, if the use of two cycles to find the judge, although we are not tired, but the program runs very tired AH.
If I want to query with a single statement to get all the data that
Free 50g php Tutorials/mysql Tutorials/ftp/No advertising space
Free cpanel (backyllc.com subdomain)-1GB of disk space-50GB of monthly bandwidth-No forced advertising
Free cpanel (helphousehosting.net subdomain)-1GB of disk space-50GB of monthly
When you invoke a micro-interface, if you encounter a nickname or message that contains an expression, you will see an error similar to incorrect string value: ' \xf0\x8f ' for column ' XXX ' when you write the data to MySQL. The reason is that the
Because to debug the relationship of the program, from the background to modify the MySQL settings, set tojoin_buffer_size=512kAfter the result is saved MySQL cannot connect immediately, reboot Lu-restart,mysql-restart cannot connect.
Operation
Change root password and restore MySQL tutorial root userI accidentally deleted the MySQL root account. What am I going to do? "and" I lost my root password? This problem is met, then you touch this kind of problem is to back up the data, reinstall
Linux Forget MySQL tutorial password retrieve methodToday we mainly talk about Linux forget MySQL password processing method, below provides 5 kinds of Linux forget MySQL password to retrieve the method oh.Method One:
#/etc/init.d/mysql Stop
Preferred to use Putty to connect to Linux servers for command lineEnter mysql-u+ database user-p+ Database passwordSet up database user is the root password is 123, should be like the following is the correct:Mysql-uroot-p123-U and-P connection
# Check and Uninstall
The code is as follows
Copy Code
Rpm-qa|grep httpdRPM-E httpdRpm-qa|grep MySQLRPM-E MySQLRpm-qa|grep PHPRpm-e PHP
# Delete the default Apache
The code is as follows
Copy
You can put this script into the crontab, his configuration file in the/etc/crontab every morning, the automatic backup of this script only once a day, and keep only the last five days of backup on the server.
The code is as follows
This link is not guaranteed to be permanent and if it fails please go to rpm search to download the corresponding package.
1. Run the following command
#wget http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm#wget http://
Chkconfig
Chkconfig is used frequently on command line operations. It makes it easy to set up and query system services at different run levels. This can be well mastered, with proficiency, you can easily manage your startup service.
Note: Keep in
The MySQL architecture is master-slave (master-slave), and the master node is automatically switched to slave when the master node fails. You can also set it to a dual master, but there is a drawback: when the pressure on the master is very high,
Frequent errors are reported when a scheduled script select table is used. Specific errors include :...... general error: 2006 MySQL server has gone away. the SQL statement executed was: SELECT * FROM ......, after checking, it is found that this is
What MySQL users can execute. The system administrator of the MySQL server or computer can perform additional optimization measures. For example, some server parameters are attached to the query processing process and can be adjusted, and some
Preparation:1. Configure the firewall and enable port 80 and Port 3306.Vim/etc/sysconfig/iptables-A input-m state -- state NEW-m tcp-p tcp -- dport 80-j ACCEPT # Allow port 80 to pass the firewall-A input-m state -- state NEW-m tcp-p tcp -- dport 33
Xtrabackup has two main tools: xtrabackup and innobackupex.(1) xtrabackup can only back up InnoDB and XtraDB data tables, but cannot back up MyISAM data tables.(2) innobackupex-1.5.1 encapsulates xtrabackup, which is a script encapsulation, so
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