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 … Read more
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 … Read more
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. … Read more
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.
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.
Yes, you can connect to your MySQL / MSSQL databases remotely using remote management tools like MySQLYOG for MySQL and for MSSQL (for SQL2000 – SQL Server Enterprise Manager, for SQL2005 – SQL Management Studio Express). You can enable remote access to your databases from your control panel.
