Tag Archives: Guide

How To Install PhpMyAdmin On Webmin/Virtual

Recently I was working on a project and for that I had got a fresh VPS machine, and that machine has got nothing, so basically it was an unmanaged VPS and I have to work on it from scratch to make it up and running, so for that I install Ubuntu 18.04, Ubuntu is one of my favorite OS when it comes to server. Once I had an OS installed, and machine is booted I can install other things on it, but first thing I wanted to installed  was a Control Panel so that I can easily manage server and do other stuffs on it like add websites, change DNS, add mail, create/edit databases, make allocations and so much more.

PhpMyAdmin Webmin Virtualmin

I can always got with cPanel, which is the most popular Control Panel but it comes with a very hefty cost and as I was working on a small project so I was not interested in buying cPanel, so I decided to go with Webmin, which is a very popular, and free.

So I installed Webmin/Virtualmin and everything was up and running, websites has been added, DNS entries were there, and everything was ready.

But now I need to import database so that I have website in its old state. Webmin/Virtualmin comes with a database manager in which you can make all database related task but I like to use PhpMyAdmin to manage database as it comes with easy to use UI.

Installing PhpMyAdmin is not an issue on Webmin/Virtualmin, all you need to do is login to your Webmin/Virtualmin admin panel and go to Webmin -> System -> Software Packages, and there you can search for PhpMyAdmin and install it.

Webmin Virtualmin PhpMyAdmin Software

But when I did and tried to access it via https://my-ip-address/phpymyadmin, I got error and instead of having login page, I was getting raw code, I tried installing some php modules, but never got it working.

After several trial and error, finally got a work around which we are going to use here.

Installing PhpyMyAdmin on Webmin/Virtualmin –

First we are going to make a sub-domain, let say mydb.mydomain.com, you can make it on any of your website which you have added on your Webmin/Virtualmin.

Once you have sub-domain registered, now select that sub-domain and click on Install Script from sidebar and then you will have PhpMyAdmin option under Available Scripts, select it and install it on your server.

Webmin Virtualmin Install Script

Now we have to create a root user so that you can manage and do all task from it, for this go to Webmin -> Servers -> MySql Database Server, here click on User Permission and then create a new users.

Provide any name, set  password, host will be your localhost, and in permission, select all permissions and Create it.

Now got to your sub-domain on which you had install PhpMyAdmin and you will get login page and you can login with the user you had just created.

[Solved] WordPress Address and Site Address URLs are disabled

The other day I was moving one of my new websites to my other server so that I can fully test it and make some changes to the site, all went smoothly and good. As we are using HTTPS across all of our iTechnixNetwork websites, I decided to change the URL to HTTPS via my WordPress admin dashboard so that by default website will load secure version whenever anyone visits that website.

So for this, I logged into my website admin panel then navigated to Dashboard -> Setting -> General, but there I found out that I am not able to change the WordPress Address (URL) and Site Address (URL) fields as they as disabled or grayed out.

Wordpress Address URL Setting Disable

This usually happens when you move your website but forget to delete some codes or sometimes some themes come with some codes which disable this setting, solution of this problem is very simple, you just need to delete some lines from your WordPress files and you are ready to go.

First login to your FTP client and navigate to the folder where you have installed WordPress, now we have to edit your wp-config.php file*. Once you have opened the wp-config.php file, look for below mentioned two lines.

define('WP_HOME','http://example.com');
define('WP_SITEURL','http://example.com');

Once you have found these lines, either delete them or just comment them out, and you are done, refresh you General setting page and you should be able to edit those fields.

Still not able to do so? Try this.

Sometimes themes come with some code which also disables these fields, to solve this, you have to open function.php file of your theme and look for below-mentioned lines.

update_option('siteurl','http://example.com');
update_option('home','http://example.com');

Again,  either delete them or just comment them out, and you are done.

[*] wp-config.php files is a very secure file which contains sensitive data of your websites, edit it at your own risk.

[Solved] 404 Error On WordPress Post

No doubt on that WordPress is one of the most widely used and popular blogging platforms over the internet and nowadays even companies have started using WordPress for their main website, reason is dead simple, it is simple to use but yet it is a powerful CMS platform, even a newbie with almost no knowledge about coding can start blog in just 10 minutes and start posting on his/her blog.

WordPress Single Post 404 Error

It allows you to customize and tweak it as you want and sometimes a slight tweak can break your website but again what makes WordPress awesome is finding a solution is easy, you can head over WordPress support platform get your problem solved.

Today we are covering a problem which we have faced on one of our blogs, we were tweaking some setting and suddenly when we check our website and try to open any post it shows 404 error page, but posts were there as we can see them in the admin page.

If you are also facing same so first of all don’t panic as all of your posts as safe and you will get them back. The most common reason for this issue is your .htaccess file might get deleted or something happened with that file and causes rewrite rules issue.

A simple solution for this problem is to save your permalink structure again, all you need to do is head over to Setting->Permalink and save it as it is, nothing needs to change over here, just press Save button and you are good to go, just check your blog again and your posts must be showing up now, It updates permalinks settings of your website and flushes the rewrite rules.

WordPress Permalink

If above doesn’t solve your issue then, use FTP client and navigate to your directory and set permission for the .htaccess file as 666 and then repeat the above method and you will be done.

P.S. Don’t forget to change the permission for .htaccess file back to 660 once you are done.

Install WordPress On Hostgator Within 5 Minutes

If you are going to start a blog or even planning to launch a website then we would suggest you to do take a look on WordPress, its an open source platform which is being used by millions of users across the globe. Its free, it has very large community and it comes with lots of customization’s which you can do on your website or blog. If you too planning to start a blog or website then Hostgator is one of the best hosting provider which you can use, Hostgator provides different plans like Shared Hosting, Reseller, VPS and even Dedicated server hosting.

One thing which we liked about Hostgator is that they have very good support staff and its very easy to use as well. Today we are going to show you how you can install WordPress on your Hostgator hosting within just 5 minutes.

WordPress has some basic requirements which you must check before using any web hosting program, and Hostgator fulfills all these requirements of WordPress and makes your blog to run very smoothly without any issue and it can easily handle your traffic.

  • You can use our coupon to get straightaway discount of 25%, use technoarea25

So lets get started, Hostgator comes with a nice option of Quick Install, which you can find on your cPanel, Once you login to your cPanel just look for it, you will find it under Software/Services section.

Hostgator Quick Install

On next screen you will find lots of CMS tools, on the left side of the screen, which you can install on you blog, just click on WordPress and on next screen click on continue.

Wordpress Quick Install

Now you will be served with some basic option like select the domain on which you wants to install WordPress, then you have to provide an email address for the admin, select your Blog Title (show your creativity here), select a admin username, provide your first and last name and at last click on Install Now button.

Hostgator-WordPress Installation Setup

Within a minute QuickInstall will download WordPress package, unpack it, create a new database for  your blog and setup for you. Don’t close that window till you get congratulation message, you can straightaway check your blog to see whether WordPress is installed or not.

Now you have to check your eMail account as your admin password will be sent you in email which you can use to login to your newly WordPress dashboard.

That’s it, you have a new blog running WordPress and we have setup this in just 3-4 minutes.

Friends

TechnoArea TroubleFixing

Copyright© 2014-2019 BloggingMayor
The content is copyrighted to Rahul Sharma and may not be reproduced on other websites.