Under Linux installation, start the MySQL

Three or four years is not installed mysql + apache + php environment, I used to do the the bank performance test outsourcing services in the the Party Development Center encountered such environment project is relatively small, mostly WebLogic / WebSphere + Oracle/DB2 architecture of large-scale systems. Get involved in the electricity supplier industry project, had to go to ponder those almost forgotten IIS, apache, MSsql, mysql environment.

An virtual centos4.7 of the platform: VMware

Host: windows

Install mysql preparation:

1, check whether the environment has been installed mysql, check: netstat-ano command to view the mysql port 3306 by default exists; execute mysql command line

2, download mysql installation package

Http://www.mysql.com/downloads/mysql/ # downloads download mysql installation package:

MySQL-server-5.5.28-1.linux2.6.i386.rpm

MySQL-client-5.5.28-1.linux2.6.i386.rpm

Rpm-ivh command to install mysql not say it here.

First take a look at some of the main directory of the default mysql database:

Database directory / var / lib / mysql /

2, the configuration file / usr / share / mysql (of the mysql.server command and configuration files)

Related command / usr / bin (mysqladmin mysqldump command)

4, the startup script / etc / rc.d / init.d / (startup script file mysql directory)

Default port 3306 netstat-ano command to view installed mysql start mysql service if it does not exist, according to the following method.

Start mysql service:

[Root @ localhostmysql] # pwd

/ Usr / share / mysql

[Root @ localhostmysql] #. / Mysql.server start

StartingMySQL ... [OK]

[Root @ localhostmysql] # netstat-ano

ActiveInternet connections (servers and established)

ProtoRecv-Q Send-Q Local Address Foreign Address State Timer

tcp 0 0 0.0.0.0:3306 0.0.0.0: * LISTEN off (0.00/0/0)

[Root @ localhostmysql] # mysql

Welcometo the MySQL monitor. Commands end with; or \ g.

YourMySQL connection id is 1

Serverversion: 5.5.28 MySQL Community Server (GPL)

Copyright (c) 2000, 2012, Oracle and / or its affiliates. All rights reserved.

Oracle isa registered trademark of Oracle Corporation and / or its

affiliates.Other names may be trademarks of their respective

owners.

Type'help; 'or' \ h 'for help. Type' \ c 'to clear the current input statement.

mysql>

mysql>

Start and stop

1 to start

Mysql MySQL installation is complete, start-up file in the / etc / init.d directory, run the following command in the need to start.

[Root @ localhost mysql] # / etc / init.d / mysql start

2, stop

[Root @ localhost mysql] # / usr / bin / mysqladmin-u root-p shutdown

3, automatic start

1) back to mysql automatically start list

[Root @ localhost mysql] # / sbin / chkconfig-list

2) MySQL add to your system startup services group inside to

[Root @ localhost mysql] # / sbin / chkconfig - add mysql

3) to remove the MySQL service group from the start inside.

[Root @ localhost mysql] # / sbin / chkconfig - del mysql