Search our database

Archive | Database RSS feed for this section
Viewing 1 to 10 of 42 items

Exporting and Importing Database Dumps in Plesk 12.5

A database dump is a file containing a database structure and content. You can use it for backup purposes. In earlier Plesk versions, dumps could be created only using database management tools. Now Plesk offers a quicker way to create database dumps, store them, and deploy previously created dumps on the server.In Plesk, to export […]

How to change ‘da_admin’ User Password in MySQL

Login to mysql server using current da_admin include the following commands in the shell prompt:1. Use mysql database(type command at mysql> prompt):         mysql> use mysql;2.  Change password for user da_admin, enter:         mysql> update user set password=PASSWORD(“NEWPASSWD”) where User=’da_admin’;3. Finally, reload the privileges with: mysql> flush privileges; mysql> quit;4. DirectAdmin will need to be configured with […]

How to create new database with user login in MSSQL Management Studio

1. Login to your MSSQL managment studio. 2. At the left side panel, under Security -> right click Logins -> New Login 3. Insert all the details as image. Rememeber to select SQL Authentication 4. After created the login, proceed to create Databases 5. Insert the database name, then click on “…” to assign user […]

How To Backup And Download MySQL Database In Plesk 9

It’s good to perform backup of your MySQL databases frequently so that you have the latest version of database to restore if and ever your databases crashes and requires a restoration. Step 1 – Login to your Plesk control panel. Step 2- Under “Application & Services”, click on “Databases”.   Step 3 – Select the […]

Backup a Database In Plesk 10

It is very important that you perform your own back up as often as you can. With Plesk 10, it’s really easy to back up your database and in this tutorial guide, you will teach you how to do so step by step.1. Login into Plesk 10.2. Click Websites & Domains. 3. Click Backup Manager. 4. Click […]

How To Create New Database In Plesk

You can manually create a new database in Plesk by following the steps below. Step 1 – Login into Plesk10 Step 2 – Click on “Databases”.   Step 3 – Click on “Add New Database”.. Step 4 – Depending on the web application you are going to use, select the type of database you need. […]

How To Install MySQL Database Using “mysql_secure_installation”

There are two ways to install MySQL database and it is recommended that you do so by using “mysql_secure_installation” as it removes the test database and its user account, both which could compromise your server. Step 1 – Login into your MySQL server. mysql -uroot -pmysql -uroot -p   Step 2 – Execute mysql_secure_installation: mysql_secure_installationmysql_secure_installation […]

How To Create MySQL Database In cPanel

Almost all web software require a database to operate and one of the most popular RDMS (Relational Database Management Software) is MySQL. A web server is pre-installed with LAMP, but if yours do not, you can refer to our earlier tutorials on how to install LAMP on your server for CentOS and Ubuntu. 1) Login into […]

How To Allow Access To Remote MySQL Database Using SSH

If your web server is not installed with phpMyAdmin, you may add remote host for your database by first accessing your web server via SSH. Step 1 – Login into MySQL server. Step 2 – If you wish to allow database user “ips1” to access database “myDatabase” at IP address ““, execute the following command. […]

How To Enable MySQL Query Log

It is best to enable MySQL query log so that you can backtrack your codes and steps for troubleshooting purposes. To do so, you will need to edit your MySQL configuration file.Step 1 – Login into your web server via SSH.Step 2 – Edit your MySQL configuration file by running the following commands. vi /etc/my.cnf […]