Remote MySQL connection is disabled on our shared servers due to security reasons, but you can easily set up an SSH tunnel between your PC and our server using SSH-tunneling with the MySQL port (3306) forwarding. To connect to your MySQL database with the Workbench software you should do the following: 1. Contact our hosting […]
Remote MySQL connection is disabled on our shared servers due to security reasons, but you can easily setup SSH tunnel between your PC and our server using SSH-tunneling with the MySQL port (3306) forwarding. To connect to your MySQL database with Navicat software you should do the following: 1. Contact our hosting support via live chat […]
Although remote MySQL connection is disabled on our shared servers due to security reasons, you can still easily set up an SSH tunnel between your PC and our server using SSH-tunneling with the MySQL port (3306) forwarding. It will allow you to connect to the database remotely via the SSH tunnel. To connect to your […]
When it comes to granting someone (e.g., to a friend or a website developer) an access to MySQL databases, several concerns arise. Granting full access to the hosting account in order to modify one database is neither comfortable, nor secure. This article will guide you how to grant remote access to a single MySQL database […]
Remote MySQL connection is disabled on our shared servers due to security reasons, but you can easily set up an SSH tunnel between your computer and our server using an SSH client with the MySQL port 3306 forwarding. After completing it you will have port 3306 on your local machine listening and forwarding to your […]
You can easily import/export your database using phpMyAdmin menu in cPanel. To do so, follow the instructions,It allows processing only the databases that do not exceed 50Mb. If your database is bigger, you will need to use SSH commands. Shell access is disabled on shared servers by default, so if shell access was not enabled […]
In cPanel you can import and export databases using the phpMyAdmin menu which you can find in the Databases section. Note, that only databases of 50MB maximum can be imported/exported in phpMyAdmin. Larger databases have to be imported/exported via SSH. To do this, follow the instructions here or simply submit a ticket to our HelpDesk. […]
Database can store a tremendous amount of information – all the posts, pages, comments, menus and any form of text data. The more developed site you have, the larger its database is. Along with it, the database may become ‘cluttered’ with the unnecessary items, like spam comments, drafts, closed or temporary files, etc. Of course, […]
phpMyAdmin is an application for MySQL databases management. With it you can create, alter, drop, delete, import and export MySQL database tables. You can also run MySQL queries, optimize, repair and check tables, change collation. NOTE: Make sure the database you would like to manage is already created in the MySQL Databases menu. for cPanel […]
This tutorial describes the process of creating and managing MySQL Databases in cPanel. There are two cPanel tools that allow creating MySQL Databases: MySQL Databases menu and MySQL Database Wizard. Let’s find out how each of them actually works. for cPanel paper_lantern theme for cPanel x3 theme for cPanel paper_lantern theme: Creating a database from […]