mysql sock

[...] Location ~. php$ { root /usr/share/nginx/html; Try_files $uri =404; Fastcgi_pass Unix:/var/run/php-fpm/php5-fpm.sock; Fastcgi_index index.php; Fastcgi_param script_filename $document _root$fastcgi_script_name; Include fastcgi_params; } [...]Finally reload Nginx:Systemctl Restart Nginx.serviceOnce this is configured, a Php5-fpm.sock file is automatically generated in the/var/run/php-fpm/directory, and then everything is O

Most of our default Nginx connection mode for php-cgi monitoring 127.0.0.1:9000, just tested the use of socket connection, fast!Nginx Configuration method:Location ~ \.php$ {Fastcgi_pass Unix:/dev/shm/php-fpm.sock;Fastcgi_index index.php;Fastcgi_param Script_filename/opt/www_data/code/public_html$fastcgi_script_name;Include Fastcgi_params;}This article is from the "Enjoy programming" blog, so be sure to keep this source http://kure6.blog.51cto.com/2398286/1565807PHP-FPM Configuration using

In the VC knowledge Base I learned a lot of knowledge, a very short time I mastered the VC, mainly in your station under a lot of source code back analysis, learning. Look at you. A person will be net send package to the source code of mass message, have seen the internet, such as mass message software to buy, so feel oneself to write a mass message small program. Characteristics: VC source code, based on the IP/UDP protocol sock programming, accord

Use sock technology to send mail without server support. The speed is fast!! Copy Code code as follows: function Send_mail ($to, $subject, $body) { SMTP information that can be modified to your////////// $loc _host = "Longbill"; The computer name of the letter, can be arbitrary $SMTP _ACC = "Longbill.mail"; The user name of the SMTP authentication, $SMTP _pass = "Longbill"; SMTP authenticated password, $SMTP _host = "smtp.163.com";

Original http://www.51bbo.com/archives/2194 Theme Nginx php-fpm Most of the default Nginx connection mode for PHP-FPM monitoring 127.0.0.1:9000, in fact, PHP-FPM also has a socket connection configuration, compared to the default speed is better

/mysql/bin/mysqld_safe -- user = mysql 4793 4507 0? 00:00:03/usr/local/mysql/bin/mysqld -- basedir =/usr/local/mysql ....... Kill 4793 and start again. It's normal. Ps: kill the process under root: 4507 is not Mysql Troubleshooting: 'Can't connect to local

reasons. 1. disable remote connection: First, disable Port 3306, which is the default listening port of MySQL. MySQL only serves local scripts, so remote connection is not required. Although the built-in security mechanism of MySQL is very strict, listening to a TCP port is still dangerous, because if the MySQL pr

/and find *. copy one of the cnf files to/etc/and change it to my. cnf. The command is as follows:[Root @ test1 mysql] # cp/usr/share/mysql/my-medium.cnf/etc/my. cnf 5. edit the MySQL configuration file/etc/my. cnf.To ensure that MySQL works properly, you must specify the location where the

-- Unzip the installation package # Tar-zxvf mysql-5.5.17.tar.gz # Cd mysql-5.5.17 2. Compile and install LMySQL instance 1: (Port: 3306, installation directory:/usr/local/mysqla, data file directory:/data/lib/mysqla) -Custom compilation # Cmake-DCMAKE_INSTALL_PREFIX =/usr/local/mysqla-DMYSQL_TCP_PORT = 3306-DMYSQL_DATADIR =/data/lib/mysqla-DMYSQL_UNIX_ADDR =/data/lib/mysqla/

cmake compilation and installation. here we install mysql 5.5.23. here we record the installation steps and procedures of CMAKE for future reference. If a missing toolkit is found during compilation and installation, use yum install to download and install it separately and then continue. The following installation involves several issues that need to be explained in advance: Mysql will be installed in

mysql_data.gz/media/raid10/mysql/3306/data Then mv mysql_data.gz/media/raid10/htdocs/blog/wordpress/ Because my/media/raid10/htdocs/blog/wordpress/is the main directory of Nginx Therefore, you can use wget to download the file on slave, decompress the file, and overwrite the data file on slave. Note: it is best to back up the source file before overwriting. 3. configure my. cnf for The master and add the following content: Add the following fields in

1. Touch/dev/shm/php-fpm.sock chmod 777/dev/shm/php-fpm.sock Chown Www:www/dev/shm/php-fpm.sock 2. Nginx Configuration Location ~ \.php$ {#fastcgi_pass 127.0.0.1:9001;Fastcgi_pass Unix:/dev/shm/php-fpm.sock;Fastcgi_index index.php;Fastcgi_param

: mysql/opt/mysql3.10 check whether the dependent lib library is secure # Ldd/usr/local/mysql/bin/mysqld 4. Configure the my. cnf parameter and database initialization 4.1 configure the my. cnf Parameter (1) backup/etc/my. cnf # Mv/etc/my. cnf/etc/my. cnf_backup (2) create a new/etc/my. cnf File # Vi/etc/my. cnf [Client]Port = 3306Socket =/tmp/mysql.

The-S parameter is invalid when mysql is logged on to mysql on 111mysql. [environment description] mysql5514 [problem description] Multi-instance 1 instance 2datadirhomemysql_3306homemysql_3307basedirusrs 1.1.1 [Environment description] Mysql5.5.14 [Problem description] Multi-instance configuration Instance 1 Instance 2 Datadir /Home/mysql_3306 /Home/mysql_3307 Base

closed, how does the local program connect to the MySQL database? The local program uses mysql. sock is faster than network connection. sock specific circumstances MySQL backup usually uses SSH for execution 2. prohibit MySQL fro

connect to local MySQL server through socket '/tmp/mysql. sock' [Root @ localhost mysql] # mysqlERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql. sock

....... Kill 4793 and start again. It's normal. Ps: kill the process under root: 4507 is not Mysql troubleshooting: 'Can't connect to local MySQL server through socket '/tmp/mysql. sock' [Root @ localhost mysql] # mysql ERROR 2

/zlm. pid -- socket =/tmp/mysql. sock -- port = 3306 root 3493 0.0 0.0 3912 pts/0 R + grep mysql [root @ zlm mysql] # mysqladmin shutdown [root @ zlm mysql] # ps aux | grep mysql root 3501 0.0 0.0 3912 668 pts/0 R + grep

-5.0.15-0.i386.rpm # Rpm-ivhuMySQL-client-5.0.15-0.i386.rpm Q: How to install a compiled mysql binary package A: first download the appropriate binary package, such as downloading the file mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz # Groupadd mysql # Useradd-g mysql # Cd/usr/local # Tar zxf

/local/mysql/scripts/mysql_install_db -- basedir =/usr/local/mysql -- datadir =/data0/dbdata/mysql/3306 -- user = mysql #/Usr/local/mysql/scripts/mysql_install_db -- basedir =/usr/local/mysql -- datadir =/data0/dbdata/