For many PHP beginner developers, to build a lamp environment can be used for production is a time-consuming and laborious thing, this article takes ubuntu-server14.04 as an example, gives a tutorial to build the environment for everyone to
Install Apache:Weirubo@weirubo-VirtualBox: ~$ sudo apt-get install apache2 To view the Apache version:Weirubo@weirubo-VirtualBox: ~$ apache2-vapache/2.4. (Ubuntu)2016-04-T18:xx: The above information indicates that Apache installation was
I. EnvironmentOs:ubuntu 14.04Network card requirements: a minimum of two NICs per host, a minimum of three net nodesEth0 as the Management network card, eth1 as the data network card, eth2 as the external network cardNetwork type10.0.0.0/24数据网络(Data
System environment: Ubuntu 12.04 1. Install the sudo apt-get install mysql-server sudo apt-get install mysql-client you will be prompted to set a password during installation, remembering the settings Password. This password is used to log in to the
Using LNMP to install WordPress in the phpMyAdmin database when the strange appearance of phpmyadmin#1045 unable to log into the MySQL server, the solution is as follows:1 change root password-No Line 2 skip-grant-tables, no new user behind-Failed 3
Use the following command to install MySQL:sudo apt-get install mysql-serverThe above command installs the following packages:AppArmormysql-client-5.7Mysql-commonMysql-servermysql-server-5.7mysql-server-core-5.7So there is no need to install
Directory1 preparatory work 32 dependencies required for installing Mysql 32.1 Installing Mysql 33 Common Commands 33.1 Verify that the original host is installed 33.2 Start 43.3 Login 43.4 telnet 43.5 Restart service 43.6 Stop service 43.7
Business requirements
Two servers are equipped with a database, in order to prevent a server problems and affect the operation of the business, need to prepare two servers to run MySQL, and need two server data is kept synchronized. That is to say
This is the operation log of the database, such as update a table, or delete some data, even if the statement does not have matching data, this command will also be stored in the log file, including the time of execution of each statement, will also
If the table contains a column named Auto_increment,
If it is a MyISAM type of engine, then after the latest data is deleted, whether or not to restart MySQL, the last deleted maximum id+1 will still be used after the next insert.
mysql>
Error starting MySQL, view the next status, found that the MySQL is not running,but lock exists:
a netizen said May and log file, so the log file to remove, and then restart MySQL finally OK
Looked for the information, basically is to say:
Take advantage of the 11 period, good writing essays to record their learning, practice and income, the deficiencies, welcome you to make Bricks ~ ~ ~
Tools: Xftp 5, Xshell 5
First, install the JDK
1. Use xftp 5 to upload
With df command checked, and sure enough disk full, because of the system by the default, I do not know why can not automatically expansion! Later on in dealing with this problem! As shown in the figure:
Copy Code code as follows:
Find configuration file
I installed it through sudo apt-get install MySQL. MySQL configuration file in/etc/mysql/my.cnf
If this file is not found, you can run sudo find/-iname ' *.cnf ' to locate all CNF files
Modify configuration file
Add under
1. Introduction
The principle of OpenSSL heart bleeding is the OpenSSL introduction of a Heartbeat (heartbeat) mechanism to maintain the long-term existence of TLS links, the heartbeat mechanism as an extension of TLS, but in code including TLS
Symptom: Data store error:packet for query is too large (2034> 1024). You can change this value on the server by setting the Max_allowed_packet ' variable.
Troubleshooting process: From the error to see is the MySQL max_allowed_packet parameter
At present, mature real-time backup for dual-computer (Master/slave), is based on synchronous log events to achieve, that stand-alone how to achieve an incremental backup? Can borrow the principle of two machines, very simple, the implementation
The recent use of mybatis to do projects when the problem encountered, using MyBatis data for fuzzy query, can only query English, and can not query Chinese, that is: the input parameters for the success of English, Chinese on the search
Ubuntu 12.04, installed MySQL, finished, changed the character compiled, the error. Feel very depressed.
Environment:
root@ubuntu:~# uname-a
Linux ubuntu 3.2.0-23-generic #36-ubuntu SMP Tue Apr 20:39:51 UTC x86_64 x86_64 x86_64 gnu/linux
Using
To manipulate commands in the Ubuntu system:Login: Mysql-uroot-pStart: Service MySQL StartSTOP: Service MySQL stopRestart: Service MySQL restartCreating database: Create database name charset = UTF8;Delete databases: drop database name;View all
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.