To change the MySQL Server default port no. 3306,follow the given below steps.
1. Check the aviailbe port in system first:
# netstat -tanp |grep xxxx
How to import a sql file into mySQL in linux
Login as root, typing the command below.
#mysql databasename -u databaseuser -p databasepassword < database.sql
How to using Mytop to monitoring MySQL
To install Mytop, run the following command. Make sure you must have RPMForge or EPEL repository under RHEL/CentOS systems.
# yum install mytop
Creating A MySQL Table
Before you can do anything with your database, you must create a table. A table is a section of the database for storing related information. In a table you will set up the different fields which will be used in that table. Because of this construction, nearly all of a site’s database needs can be satisfied using just one database.
MySQL Delete with PHP
Delete Data In a Database
The DELETE FROM statement is used to delete records from a database table.
Syntax
MySQL Update with PHP
Update Data In a Database
The UPDATE statement is used to update existing records in a table.
Syntax
MySQL Order By with PHP
The ORDER BY Keyword
The ORDER BY keyword is used to sort the data in a recordset.
The ORDER BY keyword sort the records in ascending order by default.
If you want to sort the records in a descending order, you can use the DESC keyword.
Read More
MySQL The Where Clause with PHP
The WHERE clause
The WHERE clause is used to extract only those records that fulfill a specified criterion.
Syntax
SELECT column_name(s)
FROM table_name
WHERE column_name operator value
FROM table_name
WHERE column_name operator value
MySQL Select with PHP
Select Data From a Database Table
The SELECT statement is used to select data from a database.
Syntax
SELECT column_name(s)
FROM table_name
FROM table_name
MySQL Insert with PHP
Insert Data Into a Database Table
The INSERT INTO statement is used to add new records to a database table.
Syntax
It is possible to write the INSERT INTO statement in two forms.
