激情五月天婷婷,亚洲愉拍一区二区三区,日韩视频一区,a√天堂中文官网8

<ul id="buwfs"><strike id="buwfs"><strong id="buwfs"></strong></strike></ul>
    <output id="buwfs"></output>
  • <dfn id="buwfs"><source id="buwfs"></source></dfn>
      <dfn id="buwfs"><td id="buwfs"></td></dfn>
      <div id="buwfs"><small id="buwfs"></small></div>
      <dfn id="buwfs"><source id="buwfs"></source></dfn>
      1. <dfn id="buwfs"><td id="buwfs"></td></dfn>
        始創(chuàng)于2000年 股票代碼:831685
        咨詢熱線:0371-60135900 注冊有禮 登錄
        • 掛牌上市企業(yè)
        • 60秒人工響應(yīng)
        • 99.99%連通率
        • 7*24h人工
        • 故障100倍補償
        全部產(chǎn)品
        您的位置: 網(wǎng)站首頁 > 幫助中心>文章內(nèi)容

        CentOS 5.6下源碼安裝MySQL 5.1.56

        發(fā)布時間:  2012/8/24 17:15:36

        install_mysql_centos5.6
        總結(jié):其實事情很簡單,答案一直就在跟前,我們卻總很容易將他們忽視掉,用心想,靜靜地看,答案就在那里。

        1. download mysql-5.1.56.tar.gz to /opt/src

        2. $cd /opt/src

        3. $tar -zxvf mysql-5.1.56.tar.gz-
         


        4. $cd mysql-5.1.56

        5. $mkdir -p /opt/apps/mysql-5.1.56 /opt/etc/mysql /opt/var/mysql
                        /opt/tmp/mysql

        6. $./configure --prefix=/opt/apps/mysql-5.1.56/   \
                --sysconfdir=/opt/etc/mysql/          \
                --localstatedir=/opt/var/mysql/  \
                --with-unix-socket-path=/opt/tmp/mysql/mysql.sock \
                --with-tcp-port=3306 \
                --with-charset=utf8 \
                --with-extra-charsets=gb2312,gbk

        7. $make

        8. $make install

        9. $su - root

        10.$sudo cp /opt/src/support-files/my-medium.cnf /etc/my.cnf

        11.$sudo groupadd mysql

        12.$sudo useradd -g mysql mysql

        13.$sudo chown -R mysql:mysql /opt/var/mysql

        14.$sudo chown -R mysql:mysql /opt/tmp/mysql/

        14.$ln -s /opt/apps/mysql-5.1.56 /opt/apps/mysql

        15.$sudo vim /etc/my.cnf
                instead skip-locking by #skip-locking
              add:
                    skip-external-locking

        16.$sudo ./mysql/bin/mysql_install_db --user=mysql
                note:
                    generate the initial privileges or grant tables

        17. 啟動mysql服務(wù)
            $sudo /opt/apps/mysql/bin/mysqld_safe &
                note:
                    starts the mysqld_safe daemon, which will in turn start the MySQL server mysqld.
                    If the mysqld daemon crashes,mysqld_safe will restart it.
                    The ampersand instructs the shell to run the daemon in the background.

        18.關(guān)閉mysql服務(wù)
            $/opt/apps/mysql/bin/mysqladmin -u root shutdown

        19.設(shè)置root密碼
            $/opt/apps/mysql/bin/mysqladmin -u root password 'new-password'

        20.設(shè)置密碼后,關(guān)閉服務(wù)
            $/opt/apps/mysql/bin/mysqladmin -uroot -ppassword shutdown
            或者
            $/opt/apps/mysql/bin/mysqladmin -u root -p shutdown

        21. 登錄mysql
            $mysql -u root -p
            或者
            $mysql -uroot -ppasswd

        22.設(shè)置開機啟動
            $su - root
            #cp /opt/src/mysql-5.1.56/support-files/mysql.server /etc/init.d/mysql
                    注:place the startup file for the server in the server's initial daemons directory
                        with the name mysql.
            #chmod +x /etc/init.d/mysql
            #chkconfig --add mysql 
                    注:set the run level of the service for startup and shutdown

        23. 至此可以通過相關(guān)設(shè)置
            #chkconfig mysql off         //設(shè)置不隨機啟動
            #chkconfig mysql on          //重新隨即啟動

        24.啟動mysql也可以更加方便
            #/etc/init.d/mysql start       //啟動
            #/etc/init.d/mysql stop       //關(guān)閉
            #/etc/init.d/mysql restart
            或者
            #service mysql start
            ....................................


        1. error: No curses/termcap library found
                 sudo yum install ncurses-devel
                curses構(gòu)成了一個工作在底層終端代碼之上的封裝,并向用戶提供了一個靈活高效的API
                (Application Programming Interface 應(yīng)用程序接口)。它提供了移動光標,
                建立窗口,產(chǎn)生顏色,處理鼠標操作等功能。使程序員編寫應(yīng)用程序不需要關(guān)心那些底層的
                終端操作。
                ncurses是最早的System V Release 4.0 (SVr4)中 CURSES的一個克隆。這是一個
                可自由配置的庫,完全兼容舊版本的curses。簡而言之,它是一個管理應(yīng)用程序在字符終
                端顯示的函數(shù)庫。當后面提到curses的時候,同時也可以和NCURSES互換。

        2. exec: g++: not found
                sudo yum install gcc-c++

        3.  錯誤:對 C++ 內(nèi)建類型 ‘bool’ 的重聲明
                重新./configure一下,然后再make就好了。

        4.  '--skip-locking' is deprecated and will be removed in a future release.             Please use '--skip-external-locking' instead.、

        5.  執(zhí)行腳本
            $sudo ./mysql/bin/mysql_install_db --user=mysql
            時,出現(xiàn)的話,你看過嗎,卻傻巴垃圾的去問人,去google.
            Installing MySQL system tables...
        OK
        Filling help tables...
        OK

        To start mysqld at boot time you have to copy
        support-files/mysql.server to the right place for your system

        PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
        To do so, start the server, then issue the following commands:

        /opt/apps/mysql-5.1.56/bin/mysqladmin -u root password 'new-password'
        /opt/apps/mysql-5.1.56/bin/mysqladmin -u root -h net.yy.com password 'new-password'

        Alternatively you can run:
        /opt/apps/mysql-5.1.56/bin/mysql_secure_installation

        which will also give you the option of removing the test
        databases and anonymous user created by default.  This is
        strongly recommended for production servers.

        See the manual for more instructions.

        You can start the MySQL daemon with:
        cd /opt/apps/mysql-5.1.56 ; /opt/apps/mysql-5.1.56/bin/mysqld_safe &

        You can test the MySQL daemon with mysql-test-run.pl
        cd /opt/apps/mysql-5.1.56/mysql-test ; perl mysql-test-run.pl

        Please report any problems with the /opt/apps/mysql-5.1.56/bin/mysqlbug script!


        本文出自:億恩科技【mszdt.com】

        服務(wù)器租用/服務(wù)器托管中國五強!虛擬主機域名注冊頂級提供商!15年品質(zhì)保障!--億恩科技[ENKJ.COM]

      2. 您可能在找
      3. 億恩北京公司:
      4. 經(jīng)營性ICP/ISP證:京B2-20150015
      5. 億恩鄭州公司:
      6. 經(jīng)營性ICP/ISP/IDC證:豫B1.B2-20060070
      7. 億恩南昌公司:
      8. 經(jīng)營性ICP/ISP證:贛B2-20080012
      9. 服務(wù)器/云主機 24小時售后服務(wù)電話:0371-60135900
      10. 虛擬主機/智能建站 24小時售后服務(wù)電話:0371-60135900
      11. 專注服務(wù)器托管17年
        掃掃關(guān)注-微信公眾號
        0371-60135900
        Copyright© 1999-2019 ENKJ All Rights Reserved 億恩科技 版權(quán)所有  地址:鄭州市高新區(qū)翠竹街1號總部企業(yè)基地億恩大廈  法律顧問:河南亞太人律師事務(wù)所郝建鋒、杜慧月律師   京公網(wǎng)安備41019702002023號
          0
         
         
         
         

        0371-60135900
        7*24小時客服服務(wù)熱線