MySQL Tools Comparison.

  • Increase font size
  • Default font size
  • Decrease font size
Home Articles MySQL
MySQL Tutorials, MySQL Programming, MySQL Workarounds, MySQL GUI

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

Print PDF
User Rating: / 12
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:

 

Trigger mysql example. Introduction on Mysql triggers.

Print PDF
User Rating: / 87
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: / 287
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

 


Page 2 of 3

Selection options GUI tool for mysql for purchase.

'mysql.proc' doesn't exist fixed problem

_

Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...