mysql 编译安装 -1

以谁为师

Mysql                 已测
安装路径 /data/local/mysql

和mysql源文件放（mysql-5.6.17.tar）一个目录
编辑vi setup-mysql.sh  ;权限 chmod o+x setup-mysql.sh ;运行 ./setup-mysql.sh

1. #!/bin/bash
   
2. #Auto-install mysql by Logos
   
3. . /etc/rc.d/init.d/functions
   
4. PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
   
5. export PATH
   
6. 
   
7. yum -y install gcc gcc-c++ make cmake ncurses-devel bison
   
8. if [ ! -d "/data/local/mysql/" ]
   
9.    then
   
10. tar xzvf mysql-*
    
11. cd mysql-*
    
12. 
    
13. cmake -DCMAKE_INSTALL_PREFIX=/data/local/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS:STRING=utf8,gbk -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/data/local/mysql/data -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306 -DSYSCONFDIR=/etc -DINSTALL_SHAREDIR=share
    
14. 
    
15. make && make install
    
16. cd ..
    
17. fi
    
18. 
    
19. mkdir -p /data/mysql/data/log/
    
20. chown -R root:mysql /data/local/mysql/
    
21. chown -R mysql:mysql  /data/local/mysql/data
    
22. ln -s /data/local/mysql/support-files/mysql.server /etc/init.d/mysqld
    
23. chmod a+x /etc/init.d/mysqld
    
24. chkconfig --level 35 mysqld on
    
25. 
    
26. source /etc/profile
    
27. /data/local/mysql/scripts/mysql_install_db --user=mysql --defaults-file=/etc/my.cnf --basedir=/data/local/mysql --datadir=/data/local/mysql/data
    
28. cp  /data/local/mysql/support-files/my-large.cnf /etc/my.cnf
    
29. chown -R mysql:mysql  /etc/my.cnf
    
30. MANPATH /data/local/mysql/man/
    
31. echo "export PATH=/usr/local/mysql/bin/:$PATH" >> /etc/profile
    

复制代码

##################################
       
        修改vim /etc/my.cnf
        [root@Logos mysql]# cat /etc/my.cnf
        [mysqld]
        datadir=/data/local/mysql/data
        socket=/tmp/mysql.sock
        user=mysql
       
        [mysqld_safe]
        log-error=/data/mysql/data/log/
        pid-file=/data/local/mysql/data/Logos.ljj.com.pid
       
       
         MySQL从5.5版本开始，取消./configure进行编译配置，使用cmake
        > service mysqld start
        > mysqladmin -u root password ‘密码’
        > mysql -u root -p
        > show databases;