We are using MariaDB on an Ubuntu server powered by Webmin and Virtualmin. The MariaDB […]
Showing posts from Tag: mysql
show all postsThis is a very simple example on how to use SlimPHP and PDO in a […]
Use the following command to export the query rows to a file on the server […]
Use the following command in your server to allow user to connect from anyhost:
|
1 2 |
RENAME USER 'root'@'localhost' TO 'root'@'%'; FLUSH PRIVILEGES; |
Commands: sudo nano /etc/mysql/my.cnf Look for [mysqld] and bind-address Edit the new address that matches […]
A great tutorial to do so can be found here: https://www.howtoforge.com/tutorial/install-apache-with-php-and-mysql-lamp-on-debian-jessie/ Please remember to prefix […]
Use the following commands to change the URL of a WordPress website directly inside the […]
This is an interesting tutorial on MySQL Joins: Understanding JOINs in MySQL and Other Relational […]
Reset the term count:
|
1 |
UPDATE wp_term_taxonomy tt SET count = (SELECT count(p.ID) FROM wp_term_relationships tr LEFT JOIN wp_posts p ON (p.ID = tr.object_id AND p.post_type = 'post' AND p.post_status = 'publish') WHERE tr.term_taxonomy_id = tt.term_taxonomy_id) WHERE tt.taxonomy = 'tag'; |
The information here helped. Reducing the buffer pool size was not enough. In the next […]
To delete the media files without leaving traces in the database, do the following: Connect […]
Use the following code in your script to set the internal php encoding to UTF-8: […]