Not generally but many a times website owners require knowing their hostname and server IP address, it is only useful in certain situations like many security plugins and SSL certificate extensions asks you for your IP and host information to set up configuration settings and there are many more reasons.
Unlike to SANGKRIT.net’s hosting accounts, there are many hosting providers who give you a limited amount of MySQL databases and resources. So in this tutorial we will be telling you how you can run multiple WordPress installations on a single MySQL database. Yes, a single database can run multiple websites including single and multisite WordPress installations or even you can also run other CMS application like Mediawiki with in that. Let us see how.
Generally there are two ways webmasters use for optimization database tables, some do it via phpMyAdmin which works from your webserver or your web hosting account and the other way is using a database optimization plugin which is more easy and user friendly way. There are hundreds of database optimization plugins available in WordPress plugin repository which confuses the new WordPress users.
With PHP/MySQL CPU performance statistics WordPress plugin you can check your CPU performance of your PHP and MySQL database time to time right from your WordPress admin area dashboard.
WPDBTotalCleaner is the new WordPress plugin which provides you a very easy way to clean up unnecessary Database tables from your WordPress site. The plugin is simple, lightweight and is compatible with bot single and multisite WordPress installations.
We have already discussed about changing your website domain name or URL by editing functions.php file and by editing wp-config.php file. Now this tutorial explains you how you can update your website web address to new one (when you are migrating your website to a new domain) directly by updating your WordPress site’s MySQL database.
Thinking of migrating your blog to WordPress, here are 5 cool plugins that can help you doing that in a better and easy way possible and ofcourse I am takling about WordPress.Org self hosted blog not WordPress.Com. If you are migrating your blog from Blogger then you must read this post.
WordPress developers launched WordPress.Com’s debug bar for Self Hosted WordPress Blogs . It adds a debug menu to WP admin bar that shows query, cache, and other helpful debugging information. Good for developers.
Display your host’s PHP, MySQL & Memcached (if installed) information on your WordPress site dashboard.
Yes you can access PhpMyAdmin section for managing your WordPress site’s MySQL database direct from your WP admin area dashboard.
Sometimes when you activate any wrong conflicting plugin, your WordPress admin section disappears. You can easily overcome this by three different methods discussed here.
You can make WordPress to automatically repair your site’s database. Open wp-config.php file (present in your site’s root directory) and add the following code, just above the Happy Blogging line: