MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Articles MySQL

MySQL Tutorials, MySQL Programming, MySQL Workarounds, MySQL GUI

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:

 

Trigger mysql example. Introduction on Mysql triggers.

Print PDF
User Rating: / 80
PoorBest 

How to do the data validation directly from MySQL? Trigger mysql example.

Data Validation

Many times I wanted to do data validation directly when inserting into a MySQL table and leave the source code of my application nice, clean and very readable, but support for that was only in Oracle and other SQL servers but not in MySQL.

Beginning with version 5 of MySQL the development team has added “triggering” to their SQL server engine, to meet the growing demand of users.

 

But what are triggers ?

A trigger is a database object that is associated with a table and is activated when an event occurs for that table. Can be successfully used for database data validation and any other calculations done directly on the database.

 

MySQL & HTTP Tunnel. Remote access to mysql.

Print PDF
User Rating: / 17
PoorBest 

Connection to MySQL using HTTP-tunneling. Mysql remote access.

MySQL Http tunnel

HTTP Tunneling is a technique by which communications performed using various network protocols are encapsulated using the HTTP protocol, the network protocols in question usually belonging to the TCP/IP family of protocols.

The HTTP protocol therefore acts as a wrapper for a covert channel that the network protocol being tunneled uses to communicate.

 

Add MySQL related tables into Data Source Visual Studio 2005

Print PDF
User Rating: / 283
PoorBest 

How create data source in Visual Studio 2005  with data from MySQL tables with FK.

For example, create a new project C# Windows Application.

1. Select  menu  Data - Add New Data Source  Add new Data Source

 

Error 1146 Table 'mysql.proc' doesn't exist.

Print PDF
User Rating: / 43
PoorBest 

error mysql

Sometimes our support team receive a helpdesk request concerning this error message: Error 1146 Table 'mysql.proc' doesn't exist.

The usual problem with such a customers is that almost all of them make recent upgrade of MySQL server. While some releases of MySQL introduce changes in the structure of the system tables in mysql database to add new privileges and support new features, it is necessary to update the system tables as well. Error 1146 Table doesn't exist Fixed!

 


Page 2 of 2
mysql tools