Features of MySQL Database Server

MySQL is a relational database management system. Whether you’re involved with a Web site that processes millions of requests a day like eBay or Yahoo!, or a smaller site such as your own online shop or training course, the data must be stored in an organized and structured way for easy access  and processing. This is handled by a database management system such as MySQL where the data is stored in tables rather than in a flat file. MySQL...

Read More

MySQL with php

The basic steps of performing a query, whether using the mysql command-line tool or PHP, are the same:Connect to the database.Select the database to use.Build a SELECT statement.Perform the query.Display the results. When connecting to a MySQL database, you will use two  new resources. The first is the link identifier that holds all of the information necessary to connect to the database for an active connection. The other resource is...

Read More

Advantages of MySQL and PHP

Certain technologies play together better than others. PHP, a simple and powerful scripting language, and MySQL, a solid and reliable database server, make a perfect marriage between two modern technologies for building databasedriven, dynamic Web sites. Some of the advantages of both PHP and MySQL are:•  High performance•  Built-in libraries•  Extensibility•  Relatively low cost•  Portability•  Developer community• ...

Read More

top Database management system-PHP

This summary is not available. Please click here to view the po...

Read More

Web and Database Port Listing

Table A-1. HTTP/1.1 Methods and Field Definitions Web and Database Port Listing Port Server 66 Oracle SQL*Net 80 Hyper Text Transfer Protocol (HTTP) 81 HTTP Proxy, Alternative HTTP Port, Cobalt Server Administration Port 443 Secure Socket Layer (SSL) 445 Microsoft SQL Server over NetBIOS 457 UnixWare/Netscape FastTrack Server 1080 SOCKS Proxy 1100 Oracle...

Read More

Adding New User Privileges to MySQL

You can add users two di erent ways: by using GRANT statements or by manipulating theMySQL grant tables directly. The preferred method is to use GRANT statements, becausethey are more concise and less error-prone. The examples below show how to use the mysql client to set up new users. These examplesassume that privileges are set up according to the defaults described in the previous section.This means that to make changes, you must be on the...

Read More

why need For a relational database?

A database or database management system that stores information in tables—rows and columns of data—and conducts searches by using data in specified columns of one table to find additional data in another table. In a relational database, the rows of a table represent records (collections of information about separate items) and the columns represent fields (particular attributes of a record). In conducting searches, a relational database matches...

Read More

Relational Databases-MySQL

MySQL is a relational database. An important feature of relational systems is that a single database can be spread across several tables as opposed to our flat-file phone book example. Related data is stored in separate tables and allows you to put them together by using a key common to both tables. The key is the relation between the tables. The selection of a primary key is one of the most critical decisions you'll make in designing a...

Read More

Backing Up and Restoring Data MySQL

Even the best maintained databases occasionally develop problems. Hardware failures, in particular, can really throw a monkey wrench into your web pages. Now that you're using a database, just backing up the files (HTML, PHP, and images) on your web server isn't enough. There's nothing worse than informing your web users that they have to reenter information, such as their accounts, or have to recreate your catalog items. Having a complete...

Read More

Managing the Database

Creating Users To create users above and beyond the default privileged root user, issue the grant command. The grant command uses this syntax: GRANT PRIVILEGES ON DATABASE.OBJECTS TO'USER'@'HOST' IDENTIFIED BY 'PASSWORD'; For example: GRANT ALL PRIVILEGES ON *.* TO 'michele'@'localhost' IDENTIFIED BY 'secret'; This creates the user michele who can access anything locally. To change to the michele user, at the mysql command prompt, type: exit Then start MySQL from the command line with the new username and password. The syntax...

Read More

Why MySQL Database?

MySQL has its own client interface, allowing you to move data around and change database configuration. Note that you must use a password to log in. Assigning database users allows you to limit access to server tables that have multiple users. Each MySQL server, where tables are grouped together, can host many databases. Normally, a web application has its own proprietary database. You may have installed MySQL yourself or have access through...

Read More