PHP

Embed responsive Google Map into WordPress post or page without plugin

From personal blog, travel blog to company web page, we need to embed Google Map to show proper location. There are few WordPress plugins available to serve the same feature. But I always intend to not using WordPress plugins if it can be served by writing code. We can create a simple WordPress shortcode to …

Embed responsive Google Map into WordPress post or page without plugin Read More »

How to convert MySQL collation from utf8mb4 to utf8

Recently I faced a tough situation with one of my WordPress site at the time of exporting MySQL database. My development MySQL server supports utf8mb4 collation but the production MySQL server does not support that. So, I had to convert all the tables of the MySQL database from  utf8mb4 to utf8.  The actual task was conversion from …

How to convert MySQL collation from utf8mb4 to utf8 Read More »

How to set password to your root user in XAMPP

By default XAMPP has no password to it’s ‘root’ user but we can set password for this user by the following steps: 1. Open phpmyadmin 2. Click on SQL tab 3. Copy & paste the following query: UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’; FLUSH PRIVILEGES; 4. Refresh the page & will get an error message …

How to set password to your root user in XAMPP Read More »