Search our database

Archive | MySQL RSS feed for this section
Viewing 1 to 10 of 28 items

How to change mysql ‘da_admin’ user password

1)   Login to mysql server using current ‘da_admin’ type the following command  at shell prompt: Use mysql database(type command at mysql> prompt):          mysql> use mysql;  Change password for user da_admin, enter:          mysql> update user set password=PASSWORD(“NEWPASSWD”) where User=’da_admin’; Finally, reload the privilegies with: mysql> flush privileges; mysql> quit; After that, we need to […]

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 […]

How To Backup 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. Step 1 – Login into Plesk10. Step 2 – Click “Websites & […]

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 -p   Step 2 – Execute mysql_secure_installation: mysql_secure_installation   Step […]

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) […]

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 “192.168.1.1“, 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 […]

How to recover an orphan InnoDB database from .ibd file

Orphan InnoDB database incident mostly happened when: – user accidentally remove ibdata1 file. (mostly in /var/lib/mysql/ibdata1). – ibdata file courrupted. Note: To use this guide, we assumed: – You have enabled “innodb_file_per_table” in my.cnf beforehand – You have enabled “innodb_force_recovery=5” in my.cnf before you try to use this guide – Your database folder (/var/lib/mysql/database_name/) and […]