Mysqldump is an effective tool to backup MySQL database. It creates an .sql file with DROP table, CREATE table and INSERT into sql-statements of the source database. 1. To back up a database, use the command as below: #mysqldump -u db_username -p [database_name] > dumpfilename.sql Key in the password when requested. 2. To restore a
Remote access to MySQL database on Windows Shared Hosting is enabled by default, simply use SQLyog available at http://code.google.com/p/sqlyog/downloads/list: 1. Install and run SQLyog 2. Click on New… 3. Enter the following info: Host Address: yourdomain.com Username: DatabaseUser Password: DatabaseUserPassword Port: 3306 Database: DatabaseName 4. Click on connect
If your web server does not have phpMyAdmin installed, 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.
Create New Database 1. Login to the mysql client. mysql -u root -p
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
Sometime you may need to use a remote MySQL server in you Directadmin server. The below steps will help you to perform this configuration: 1. SSH to your web server as root. 2. Edit /usr/local/directadmin/conf/mysql.conf to add in the IP of the remote MySQL server as host: user=da_admin host=xx.xx.xx.xx passwd=H&*(h@123 Where xx.xx.xx.xx is an IP
Login to DirectAdmin and go to “MySQL Management” Select the database which the database user is assigned to Click “Modify Privileges” Set the required privileges for the user, then click “Save” Thank you
MySQL is a popular choice of database for using in web applications and is a central component of the widely used LAMP (Linux, Apache, MySQL, Perl / PHP / Python) web application software stack. Here is a step by step guide to allow remote access to MySQL database via DirectAdmin. Step 1: Login to your
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
1. Log into your hosting control panel if you do not know how to access to the mysql database phpMyAdmin page. For plesk users, log into the control panel and go into Database under the Applications & Services category. This will bring you to the page below, where you need to click on the small