This article explains how to provide all privileges to a user in MySQL. The MySQL privilege system authenticates a user to make specific changes in a database. Based on the privileges granted in cPanel, a user can carry functions like SELECT, INSERT, UPDATE, DELETE, etc. on the database. Follow these steps to provide all privileges […]
Articles Tagged: MySQL
How To Reset MySQL Password Using MySQL Command
In the 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 the MySQL database so you can directly change the password of any user by […]
How To Set / Reset MySQL Password?
Changing passwords is quite 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. The root user is the admin of a MySQL account. Remember that it is different than login into the […]
What Is Index In MySQL Database?
Let the web hosting account be of any type either Windows Web Hosting or Linux Web Hosting, MySQL supports both types of web hosting services and is very popular as a database. The websites which have large data in their MySQL databases are supposed to optimize it which enables them for enhanced collation of data and indexing. […]
The process to take Backup on a Dedicated Server using an 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 utilities for establishing connections 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.