how to create searchable database in wordpress

First, login WDCP panel background add site In the menu on the left, site management-new site, you can create the new domain name site we need. According to Chinese prompts input we need to set the host name, binding domain name, set directory, directory in the www/web corresponding domain name folder, so easier to find. Second, create a site MySQL

First, the discovery of problems When I tried to edit the WordPress theme of the blog site, I suddenly found that the blog site could not connect, and then prompted the error "Establish database connection error" after refreshing. The natural idea is that MySQL may be wrong, so they landed on the VPS host, trying to start the MySQL service, but prompted failed. Ii. Solutions 1. Open /var/log/mysql/error.

swap file permanent and effective when the system starts, so we'll add the following line to the/ect/fstab fileOpen the file with VI first, then add the following line, and then save it.sudo vi/etc/fstab/swapfile swap swap SW 0 0 Modify Innodb_buffer_pool_size:My VPS is loaded with MARIADB (15 mariadb performance tuning methods). It has four configuration files--each of which is under/etc:MY.CNF.D is a folder: (There are three files, ignoring the bakup file, I modified the seve

/mysql/data/-- User=mysqlSed-i ' s#/usr/local/#/application/#g '/application/mysql/bin/mysqld_safe\CP support-files/my-small.cnf/etc/my.cnf/application/mysql/bin/mysqld_safe--user=mysql Path= "/application/mysql/bin/: $PATH"Echo ' path= '/application/mysql/bin/: $PATH "' >>/etc/profilewhich MySQLSed-i ' s#/usr/local/#/application/#g ' support-files/mysql.server\CP Support-files/mysql.server/etc/init.d/mysqldchmod +x/etc/init.d/mysqld/etc/init.d/mysqld stopLsof-i: 3306/etc/init.d/mysqld startLsof

Tags: BSP ons sage dedicated nbsp res data upd OCADROP DATABASE ' WordPress ';CREATE DATABASE ' WordPress ' DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;CREATE USER ' xxxuser ' @ ' localhost ' identified by ' xxx123 ';GRANT

Tags: http os using AR file data SP AD EFIf you use PHP source program (such as WordPress) to build a station, it is best to learn how to operate phpMyAdmin, so that the maintenance of your website database, is more handy. Perhaps you would ask, what is PhpMyAdmin? Why learn to use PhpMyAdmin?What is PhpMyAdmin?PhpMyAdmin is a php-written, web-based way to control and manipulate MySQL databases. With PhpMyA