Archives

Top five software applications to access MySQL/MariaDB servers

To manage a MySQL/MariaDB from web you can use the well-known phpMyAdmin script (available from cPanel, from Softaculous etc). But what happens if you want to use a Windows/Linux/Mac program to manage your databases? We will list here some programs that allow you to work with databases. With these programs you can connect to a local MySQL server or to a remote one. Also, all these programs have GUI – graphical user interface.

Notice that most web hosts block MySQL/MariaDB port 3306. Ask your host to add an exception in the firewall for your IP.

The best option is to download and test each of them to see which one do you like the most. So, in no particular order:

1.SQLyog

SQLyog is the most powerful MySQL administration tool for DBAs, developers and database architects.

sqlyog
SQLyog Window – Click image to enlarge

Homepage: SQLyog
Price: from $99($69 license+ $30 support); free updates for 1 year.
Info:
– strong/well-known product
– no Linux/Mac version; only Windows (32/64 bit) version available.

2.MySQL Workbench

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.

MySQL Workbench
MySQL Workbench Window – Click image to enlarge

Homepage: MySQL Workbench
Price: FREE
Info:
– developed by MySQL/Oracle
– has versions for Windows (32/64 bit), Linux, Mac
– can’t use it with MariaDB anymore

3.HeidiSQL

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events.

HeidiSQL
HeidiSQL Window – Click image to enlarge

Homepage: HeidiSQL
Price: FREE
Info:
– free software; you can download installer/portable exe/source code
– no Linux/Mac version; only Windows (32/64 bit) version available.

4.Navicat for MySQL(Support MariaDB)

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development. Connect to MySQL and MariaDB databases simultaneously within a single application. This all-inclusive front-end provides an intuitive and powerful graphical interface for database management, development, and maintenance. It delivers a comprehensive set of tools for those new to MySQL/MariaDB as well as professional developers.

Navicat for MySQL
Navicat for MySQL Window – Click image to enlarge

Homepage: Navicat for MySQL
Price: from $169
Info:
– available for Windows (32/64 bit), Mac, Linux

5.dbForge Studio for MySQL

dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database administration, development, and management. The IDE allows to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface.

dbForge Studio for MySQL
dbForge Studio for MySQL – Click image to enlarge

Homepage: dbForge Studio for MySQL
Price: FREE and Paid from $119.95 (support and upgrades for 1 year)
Info:
– no Linux/Mac version

Share this post:

Use phpMyAdmin to manage your databases

phpMyAdmin is a PHP web script that allows you to manage databases.
cPanel includes phpMyAdmin. Also, you can install phpMyAdmin from Softaculous. But if for any reason, you can’t access it in cPanel or Softaculous, you can just set it up on your web hosting account.

How to configure phpMyAdmin on your account:

  1. Download the latest version archive from https://phpmyadmin.net/downloads/
  2. Extract the files to your computer.
  3. Create a folder on your web hosting account (like /public_html/mymysql).
    You should password protect this directory. Check out our article How to password protect a directory via cPanel
  4. Upload the files you extracted at 2. (it can take some time as there are ~4,843 files)
  5. Now access the phpMyAdmin script at yourdomain.com/mymysql/
  6. Enter your MySQL/MariaDB database Username and Password and click the Go button to login.

phpMyAdmin Login Screen

On all our web hosting plans you have access to phpMyAdmin from cPanel. Also you can easily install phpMyAdmin from Softaculous. If you need any help, don’t hesitate to contact us. Thank you.
Share this post:

Set up an Apache+PHP+MySQL local environment

You want to have a local Apache web server to test your new site? We’ll show you how to setup a web server and an MySQL server using XAMPP. XAMPP is a software that will install Apache+PHP+MySQL on your computer. Of course, you can download Apache, PHP and MySQL and install them by yourself, but using a suite like XAMPP will make the things much easier.

This tutorial is for XAMPP on Windows OS. XAMPP is also available for Linux and Max OS.

So, the steps to install the Apache+MariaDB(MySQL) development environment are:

1.Download XAMPP from https://www.apachefriends.org/index.html (the Windows Installer is about 110MB)

XAMPP Site

2. Install XAMPP. During the installation, choose the components you want to install.

XAMPP Installer Components

3. Start XAMPP Control Panel. 

4. Start the modules you want to run – in our case Apache(which includes PHP) and MySQL.

XAMPP Control Panel

You can now access the web server on your web browser at http://localhost/. The root folder of the web server is c:\xampp\htdocs\ In this folder you will put your site’s files.

To manage the database server go to http://localhost/phpmyadmin/. phpMyAdmin is a graphical tool that allow you perform various database operations.

And the video tutorial:

Resources: https://www.apachefriends.org/index.html

Share this post:

How to access phpMyAdmin from cPanel

You want to manually edit something in your MySQL tables? (for example to edit something in the WordPress configuration) Then, cPanel can help you via the phpMyAdmin. phpMyAdmin is a free tool that allows you to manage your MySQL databases.

For phpMyAdmin documentation, please visit the web site.

How to access phpMyAdmin from cPanel:

  1. Enter your cPanel area (go to yourdomain.com/cpanel and enter the username and password)
  2. From the DATABASES section select phpMyAdmin
  3. A new web page will be opened and you will be redirected to phpMyAdmin start page.
  4. On the left side you can see the databases/tables. Select the table you want to modify. On the right side you will see many options for that table.
  5. When done editing just close the browser window and log out of cPanel.
cPanel phpMyAdmin
cPanel phpMyAdmin

And here is the video tutorial:

Steps presented in this tutorial will work on both MySQL and MariaDB server. We use and recommend the MariaDB server. Check our web hosting offers! Thank you.
Share this post: