MySQL 5.5.32綠色版安裝配置

專注于為中小企業(yè)提供成都做網(wǎng)站、成都網(wǎng)站制作服務(wù),電腦端+手機(jī)端+微信端的三站合一,更高效的管理,為中小企業(yè)徐聞免費(fèi)做網(wǎng)站提供優(yōu)質(zhì)的服務(wù)。我們立足成都，凝聚了一批互聯(lián)網(wǎng)行業(yè)人才，有力地推動(dòng)了近千家企業(yè)的穩(wěn)健成長(zhǎng)，幫助中小企業(yè)通過網(wǎng)站建設(shè)實(shí)現(xiàn)規(guī)模擴(kuò)充和轉(zhuǎn)變。

1. 基本信息

系統(tǒng)版本：CentOS 6.6

MySQL版本：5.5.32 綠色版

1. 初始化MySQL，出現(xiàn)×××部分兩個(gè)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...

OK

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!

1. 改變/application/mysql所屬主和組，cp配置文件，改變MySQL啟動(dòng)腳本里的路徑

[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 &  ###以后臺(tái)進(jìn)程方式啟動(dòng)MySQL

1. 查看MySQL是否正常啟動(dòng)

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

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

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

1. 配置環(huán)境變量

[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

1. 登陸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>

1. 配置傳統(tǒng)方式啟動(dòng)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  ###殺死之前啟動(dòng)的mysql進(jìn)程

[root@lnmp02 ~]# lsof -i:3306   ###確認(rèn)是否已殺死m(xù)ysql進(jìn)程

[root@lnmp02 ~]#/etc/init.d/mysqld start  ###以傳統(tǒng)方式重新啟動(dòng)mysql進(jìn)程

1. 設(shè)置mysql管理員密碼，默認(rèn)管理員是root用戶

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

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

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

1. 查看錯(cuò)誤日志

[root@lnmp02 ~]# cat /application/mysql/data/lnmp02.err   ###該錯(cuò)誤日志文件是以主機(jī)名加.err后綴命名的

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。

新聞標(biāo)題：CentOS6.6MySQL5.5.32綠色版安裝配置-創(chuàng)新互聯(lián)
文章URL：http://chinadenli.net/article6/dipeig.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站策劃、全網(wǎng)營(yíng)銷推廣、關(guān)鍵詞優(yōu)化、域名注冊(cè)、App開發(fā)、微信小程序

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)