To connect to the server, you will usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. If the server runs on a machine other than the one where you log in, you will also need to specify a host name.
Getting Started with MySQL Proxy MySQL / General Guides
MySQL Proxy is a lightweight binary application standing between one or more MySQL clients and a server. The clients connect to the Proxy with the usual credentials, instead of connecting to the server. The Proxy acts as man-in-the-middle between client and server.
Working with SQL Server MySQL / General Guides
In this lesson, you'll learn how to connect and log into SQL Server, how to issue SQL Server statements, and how to obtain information about databases and tables.
How To Set Up Database Replication In MySQL MySQL / Replication and Backup
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.
Improve The Performance Of Your MySQL Server MySQL / General Guides
MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks! Learn how to get the best performance from you MySQL database server.
MySQL System Architecture MySQL / General Guides
In this article, we're going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together.
MySQL Optimization Hints MySQL / Optimization
Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.
MySQL System Architecture MySQL / General Guides
We are going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together. MySQL's implementation is a fascinating mix of technology that is truly a remarkable achievement - an achievement born from the sweat and inspiration of numerous developers overmany years.
Running Multiple MySQL Versions MySQL / General Guides
Sometimes we may require to run multiple versions of MySQL on the same Server. This can happen if you either need to test a new MySQL release or you need a new MySQL version and you don't want to make any changes to the existing system.
MySQL Configuration MySQL / General Guides
In this lesson you will read about the configuration of MySQL. The MySQL server configuration normally started during installation process.
MySQL Command Line Help MySQL / General Guides
We tend to use MySQL from the interactive command line shell quite a bit (SSH to your db server and type the command mysql to start). We noticed today that there is a pretty extensive built in help system in this command.
Managing Security MySQL / General Guides
The basis of security for your MySQL server is this: Users should have appropriate access to the data they need, no more and no less. In other words, users should not have too much access to too much data.
Using MySQL to analyze web usage from Windows ISA logs MySQL / General Guides
This tutorial will teach you how to import a tab delimited file in to a MySQL database. We built a program to do this for Windows ISA Server logs which contained over 500,000 lines which was way too many for Microsoft Excel to handle and too much for notepad to handle properly.
Backup and Restore MySQL Databases MySQL / Replication and Backup
It is a good idea to backup your MySQL data occasionally as a precautionary measure. It is also a good idea to create a backup before making any major changes, incase something goes wrong and you need to revert to the unmodified version. Database backups can also be used to transfer your database from one server to another if you change web hosts.
Backing Up And Restoring Your MySQL Database MySQL / Replication and Backup
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.