CentOS 6下編譯安裝mySQL5

一,準備工作
     1,快速安裝安裝 CentOS6,安裝時選擇最小化安裝.
     2,安裝mysql編譯時需要的庫文件,這時可以選擇做光盤yum
       [root@admin share] # cd /media/
       [root@admin media] # mkdir CentOS
       [root@admin media] # mount /dev/cdrom /media/CentOS
       [root@admin media]# cd /etc/yum.repos.d/
       [root@admin yum.repos.d] # mv CentOS-Base.repo      CentOS-Base.repo.bak
       [root@admin yum.repos.d] # mv CentOS-Debuginfo.repo    CentOS-Debuginfo.repo.bak
        至此,用光盤做的yum就可用瞭;
      [root@admin ~]#yum –enablerepo=c6-media install ncurses*  gcc* perl* -y
      3,準備好安裝包. (這裡以 mysql-5.0.56.tar.gz舉例)
      4,添加mysql 用戶
     [root@admin ~]#groupadd mysql
     [root@admin ~]#useradd -g mysql mysql -s /bin/nologin
 
二,正式安裝
      1. [root@admin software]#tar zxvf mysql-5.0.56.tar.gz   
      2. [root@admin software]# cd mysql-5.0.56
      3. [root@admin mysql-5.0.56]# ./configure  –prefix=/usr/local/mysql  –localstatedir=/data/mysql –enable-assembler —                  enable-static –with-mysqld-user=mysql –with-big-tables –enable-thread-safe-client —                enable-local-infile –with-charset-utf8 –with-extra-charsets=all
      4. [root@admin mysql-5.0.56]# make && make install
      5. [root@admin mysql-5.0.56]# cp support-files/my-medium.cnf /etc/my.cnf
      6. [root@adim share]# cd /usr/local/mysql/
      7. [root@admin mysql]# bin/mysql_install_db –user=mysql
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:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
 
Alternatively you can run:
/usr/local/mysql/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 /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &
 
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
 
Please report any problems with the /usr/local/mysql/bin/mysqlbug script!
 
The latest information about MySQL is available on the web at
https://www.mysql.com
Support MySQL by buying support/licenses at https://shop.mysql.com
 
 
   8. [root@admin mysql]# chown -R mysql.mysql /data/mysql/
   9. [root@admin mysql]#  share/mysql/mysql.server start
Starting MySQL SUCCESS!                           #————–> 看到如此,便知道安裝成功瞭.
  10. [root@admin mysql]# netstat  -tunlp | grep mysql
      tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      13193/mysqld

 

三. 後緒工作
 1.[root@admin ~]# ln -s  /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld
 2.[root@admin ~]# ln -s  /usr/local/mysql/bin/mysql /usr/sbin/mysql
 3.[root@admin ~]# ln -s  /usr/local/mysql/bin/mysqladmin /usr/sbin/mysqladmin
 4.[root@admin ~]# ln -s  /usr/local/mysql/bin/mysqldump /usr/sbin/mysqldump
 5.[root@admin ~]# mysql -uroot -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.56-log Source distribution
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql>

 

本文出自 “OpenSource滴天空” 博客

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。