Tagged: best MySQl hosting

Linux Cloud Server Hosting with ASPHostPortal.com :: How To Create a New User and Grant Permissions in MySQL

About MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. It has a variety of options to grant specific users nuanced permissions within the tables and databases—this tutorial will give a short overview of a few of the many options.

How to Create a New User

However, in the cases where more restrictions may be required, there are ways to create users with custom permissions.

Let’s start by making a new user within the MySQL shell:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
 Read more »

Ubuntu 12.04 Hosting :: How To Install and Secure phpMyAdmin on Ubuntu 12.04

About phpMyAdmin

phpMyAdmin is an free web software to work with MySQL on the web—it provides a convenient visual front end to the MySQL capabilities.

Setup

The steps in this tutorial require the user to have root privileges on your virtual private server. You can see how to set that up here in steps 3 and 4.

Before working with phpMyAdmin you need to have LAMP installed on your server. If you don’t have the Linux, Apache, MySQL, PHP stack on your server, you can find the tutorial for setting it up here.

Once you have the user and required software, you can start installing phpMyAdmin on your server!
Read more »

Linux Cloud Server Hosting-ASPHostPortal.com:: How To Install MediaWiki on Centos 6.4

MediaWiki is a free open source wiki program that allows users to create their own personal wiki sites. Originally built for Wikpedia, it is now used by thousands of other projects due to its scalability and high customization.Install MediaWiki on your server.

At the time of writing, the latest version of MediaWiki is MediaWiki 1.21.2. To check for the latest version of the platform, visit their website and simply alter the code to match the most updated version (if desirable).
Read more »

Linux Cloud Server Hosting with ASPHostPortal.com :: How To Import and Export Databases and Reset a Root Password in MySQL

How to Import and Export Databases

Export

To Export a database, open up terminal, making sure that you are not logged into MySQL and type,

mysqldump -u [username] -p [database name] > [database name].sql

The database that you selected in the command will now be exported to your panel.

Read more »

Cloud Server Linux Hosting – ASPHostPortal.com :: How To Install and Secure phpMyAdmin on Debian 7

phpMyAdmin

phpMyAdmin is a free web software to work with MySQL on the web. It provides a convenient visual front end to the MySQL capabilities.

Setup

Before working with phpMyAdmin, you need to have LAMP installed on your server. If you don’t have the Linux, Apache, MySQL, PHP stack on your server, you can find the tutorial for setting it up here.
Once you have the user and required software, you can start installing phpMyAdmin on your VPS!

Read more »