In previous post we saw how to change MySQL password using mysqladmin command at shell prompt. But there is another way to do it by updating the MySQL database. As usernames and passwords are stored in a user table in MySQL database so you can directly change password of any user by following the below […]
Articles Tagged: MySQL
How To Set / Reset MySQL Password?
Changing password is quiet a regular type of task for many webmasters and the same is also applicable to database administrators also. Here I would like to share the procedure of changing the password of MySQL. Root user is the admin of a MySQL account. Remember that it is different than login to root account […]
What Is Index In MySQL Database?
Let the web hosting account be of any type either Windows Web Hosting or Linux Hosting, MySQL supports to both type of web hosting services and is very popular as a database. The websites which has large data in their MySQL databases are supposed to be optimize it which enable them for enhanced collation of data and […]
Process to take backup on a Dedicated server using SSH connection.
Following are the mentioned steps for taking the backup of back-end files which are mostly known as MySQL database on Dedicated servers. Many of us know that SSH (Secure Shell) is one of the best utility for establishing connection with web servers. Log in to your Dedicated server using SSHMake sure that you log in as root […]
MediaWiki Web Hosting
MediaWiki is one of the very famous server based application available for users. MediaWiki is being licensed for free under the GNU General Public License. MediaWiki is mostly preferred by big websites with increasing traffic and users. MediaWiki provides a effective and scalable platform using PHP as front end and MySQL to display the stored data. Its very convenient to use MediaWiki, you don’t require to have a technical background for using MediaWiki.
XOOPS Web Hosting
XOOPS is an Open Source Content Management System released under the GNU General Public License
Drupal Web Hosting
Drupal is a leading open source CMS (Content Management System) written in PHP programming language and is available for free.