MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Articles

Mysql Articles, Using MySQL GUI Tools, MySQL Features



Learn MySQL With Sakila sample Mysql Database

Print PDF
User Rating: / 13
PoorBest 

sakila-database-MySQL

Review a Sample Database Using a SQLyog MySQL GUI Tool

Obtain the example Sakila database from the MySQL website to examine a professionally designed database and use a SQLyog GUI for MySQL instead of the command line.

 

What should I enter as 'hostname' when connecting to a MySQL server at an ISP using mysql GUI.

Print PDF
User Rating: / 6
PoorBest 

Connect-to-mysqlIt depends on the systems and the network settings at your ISP. The systems that ISP's operate are too numerous to mention. Some operate almost all their server programs on one very powerful (UNIX-) machine, others operate a network of many computers that are basically pc-type hardware.

Some use Linux/Unix operating systems other Windows server systems (and some mix it!). And ISP's vary in size from 200 customers to 2.000.000. They can't all operate the same systems!

But the general answer is that probably the ISP operates some nameserver internally. Such nameserver will typically be configured with the some name like 'mysqlserver' pointing to the ip of the mysqlserver on the local network.

 

15 practical examples of using commands Mysqladmin to administer a MySQL server

Print PDF
User Rating: / 11
PoorBest 

15 examples mysqladminIn the 15 examples of the use mysqladmin command below, using the password root Mysql tmppassword. Change it to your password

1. How to change the root password for Mysql?

 

Mysqladmin - Client for Administering a MySQL Server

Print PDF
User Rating: / 8
PoorBest 

mysqladmin all commands

mysqladmin Administering MySQL-server.

mysqladmin is a client for performing administrative operations. You can use it to check the server's configuration and current status, to create and drop databases, and more.
Utility for performing administrative operations. The syntax is:

 

HeidiSQL & HTTP Tunnel - it works!

Print PDF
User Rating: / 53
PoorBest 

HeidiSQL&HTTP Tunnel

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.

HeidiSQL is good and for someone simply irreplaceable tool for working with databases MySQL. This GUI has everything you need to work with the MySQL database. But HeidiSQL missing important functionality is the connection through the HTTP tunnel.

When you can't connect to the MySQL server directly, for example a firewall blocks the access from all network protocols, except HTTP protocol, you can use HTTP tunneling.

In this article I'll show you how to connect to remote MySQL server using HeidiSQL via HTTP Tunnel.

 


Page 2 of 4
mysql tools