CentOS 6.6 MySQL 5.5.32 綠色版安裝配置

基本資訊

系統版本：CentOS 6.6

MySQL版本：5.5.32 綠色版

初始化MySQL，出現黃色部分兩個OK，表示初始化正确

[root@lnmp02 tools]# useradd -s/sbin/nologin -M mysql

[root@lnmp02 tools]# tar zxvfmysql-5.5.32-linux2.6-x86_64.tar.gz

[root@lnmp02 tools]# mvmysql-5.5.32-linux2.6-x86_64  /application/mysql-5.5.32

[root@lnmp02 tools]# ln -s/application/mysql-5.5.32  /application/mysql

[root@lnmp02 application]#/application/mysql/scripts/mysql_install_db --basedir=/application/mysql/--datadir=/application/mysql/data/ --user=mysql

Installing MySQL system tables...

OK

Filling help tables...

To start mysqld at boot timeyou have to copy

support-files/mysql.server tothe right place for your system

PLEASE REMEMBER TO SET APASSWORD FOR THE MySQL root USER !

To do so, start the server,then issue the following commands:

/application/mysql//bin/mysqladmin-u root password 'new-password'

/application/mysql//bin/mysqladmin-u root -h lnmp02 password 'new-password'

Alternatively you can run:

/application/mysql//bin/mysql_secure_installation

which will also give you theoption of removing the test

databases and anonymous usercreated by default.  This is

strongly recommended forproduction servers.

See the manual for moreinstructions.

You can start the MySQL daemonwith:

cd /application/mysql/ ;/application/mysql//bin/mysqld_safe &

You can test the MySQL daemonwith mysql-test-run.pl

cd/application/mysql//mysql-test ; perl mysql-test-run.pl

Please report any problems withthe /application/mysql//scripts/mysqlbug script!

改變/application/mysql所屬主群組，cp配置檔案，改變MySQL啟動腳本裡的路徑

[root@lnmp02 ~]# chown -Rmysql.mysql /application/mysql/

[root@lnmp02 ~]# cp /application/mysql/support-files/my-small.cnf /etc/my.cnf

[root@lnmp02 ~]# sed -i's#/usr/local/mysql#/application/mysql#g' /application/mysql/bin/mysqld_safe     ###修改腳本裡的安裝路徑

[root@lnmp02 ~]#/application/mysql/bin/mysqld_safe &  ###以背景程序方式啟動MySQL

檢視MySQL是否正常啟動

[root@lnmp02 ~]# lsof -i:3306

[root@lnmp02 ~]# netstat-tulpn|grep 3306

[root@lnmp02 ~]# ps -ef|grepmysql

配置環境變量

[root@lnmp02 ~]# echo"PATH=/application/mysql/bin:$PATH" >>/etc/profile

[root@lnmp02 ~]# source/etc/profile

[root@lnmp02 ~]# which mysql    ###确定是否是綠色版的MySQL而不是yum安裝的MySQL

/application/mysql/bin/mysql

登陸MySQL

[root@lnmp02 ~]# mysql

Welcome to the MySQLmonitor.  Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.5.32 MySQLCommunity Server (GPL)

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

Oracle is a registeredtrademark of Oracle Corporation and/or its

affiliates. Other names may betrademarks of their respective

owners.

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

mysql>

配置傳統方式啟動MySQL

[root@lnmp02 ~]# cp/application/mysql/support-files/mysql.server /etc/init.d/mysqld

[root@lnmp02 ~]# sed -i's#/usr/local/mysql#/application/mysql#g' /etc/init.d/mysqld  ##修改mysql安裝路徑

[root@lnmp02 ~]# killall mysqld   ###殺死之前啟動的mysql程序

[root@lnmp02 ~]# lsof -i:3306    ###确認是否已殺死mysql程序

[root@lnmp02 ~]#/etc/init.d/mysqld start   ###以傳統方式重新啟動mysql程序

設定mysql管理者密碼，預設管理者是root使用者

[root@lnmp02 ~]# mysqladmin-uroot password "123456"

[root@lnmp02 ~]# mysql -uroot-p123456   ###登陸mysql，注意，-p和密碼之間不能有空格

[root@lnmp02 ~]# mysqladmin-uroot -p123456 password "wangning" ###更改密碼

檢視錯誤日志

[root@lnmp02 ~]# cat  /application/mysql/data/lnmp02.err    ###該錯誤日志檔案是以主機名加.err字尾命名的

本文轉自 茁壯的小草 51CTO部落格，原文連結：http://blog.51cto.com/wn2100/1941597，如需轉載請自行聯系原作者