Keeping a backup of your WordPress site keeps your content safe. Know how to complete backup your WP site including backup of wp-content directory, plugins, themes etc.
[...]
 |
Keeping a backup of your WordPress site keeps your content safe. Know how to complete backup your WP site including backup of wp-content directory, plugins, themes etc. [...] MySQL 5.6 includes built-in memecached daemon with InnoDB backing GRANT command is be used for giving privilege to any user for accessing database. GRANT PRIVILEGES ON DATABASE OBJECTS TO USER@HOST IDENTIFIED BY ‘PASSWORD’; Example: For granting privilege to user admin Use: GRANT ALL PRIVILEGES ON *.* TO ‘admin@localhost’ IDENTIFIED BY ‘secret’;
For showing all database: SHOW DATABASES; In case you need to filter database by name: SHOW DATABASES LIKE ‘pattern’; For complex filtering of database use WHERE Clause: SHOW DATABASES WHERE conditions; With WHERE clause one can use regular expressions like ‘<’ [...] Installing LAMP Server Open your Linux Terminal. Type: sudo apt-get install lamp-server^ Press Enter Checking the Installation Open a web browser Type: http://localhost/ If your browser shows the message: “It Works” then you have successfully installed LAMP Tasksel Method Other than the above given method you may [...] Ceil() float ceil (float value) Rounds up the supplied float value to the next integer and returns the result. Example: <?php $a = 2.444; echo ceil($a); // 3 ?> Can also be used to check if a number divides evenly with another Example: <?php $num1 = 5; $num2 = 7; $div = $num2 / [...] Inserting value1 into Column1, value2 into Column2, and value3 into Column3: INSERT INTO TableName (Column1, Column2, Column3) VALUES (value1, value2, value3) Insert one record (values are inserted in the order that the columns appear in the database): INSERT INTO TableName VALUES (value1, value2, value3) Insert two records: INSERT INTO TableName VALUES (value1, value2, value3), (value4, [...] Grant command is used for this purpose: GRANT PRIVILEGES ON DATABASE OBJECTS TO USER@HOST IDENTIFIED BY ‘PASSWORD’; For example: GRANT ALL PRIVILEGES ON *.* TO ‘lamp@localhost’ IDENTIFIED BY ‘secret’; It will create the user lamp that can access anything locally. To change to the lamp user at MySQL command prompt, type: exit Then start MySQL [...] You need to connect MySQL database before assessing it. This is done by mysql_connect function. You should know the following terms before getting connected to MySQL server: Name of the server. The default server name is localhost. Username and Password. <?php $con = mysql_connect(“localhost”,”Admin”,”1234″); *above given server name, username and password are just examples. Practically [...] |
       |
||||
|
|
||||||
