MySQL的编译安装 朴灿烈づ我的快乐病毒、 2022-06-07 06:49 130阅读 0赞 ### 1.Download and CheckMD5 ### \[root@hadoopcm-01~\]\# cd /usr/local \[root@hadoopcm-01local\]\# wget http://mirror.lug.udel.edu/pub/mysql/MySQL-5.6/mysql-5.6.22-linux-glibc2.5-x86\_64.tar.gz \[root@hadoopcm-01 local\]\# wget [ http://mirror.lug.udel.edu/pub/mysql/MySQL-5.6/mysql-5.6.22-linux-glibc2.5-x86\_64.tar.gz.md5][http_mirror.lug.udel.edu_pub_mysql_MySQL-5.6_mysql-5.6.22-linux-glibc2.5-x86_64.tar.gz.md5] \[root@hadoopcm-01local\]\# more mysql-5.6.22-linux-glibc2.5-x86\_64.tar.gz.md5 f61b0a979d443c8ca63d32cc07825a18 mysql-5.6.22-linux-glibc2.5-x86\_64.tar.gz \[root@hadoopcm-01local\]\# md5sum mysql-5.6.22-linux-glibc2.5-x86\_64.tar.gz f61b0a979d443c8ca63d32cc07825a18 mysql-5.6.22-linux-glibc2.5-x86\_64.tar.gz ### 2.Check isnot install ### \[root@hadoopcm-01local\]\# ps -ef|grep mysqld root2493 2423 0 19:48 pts/3 00:00:00 grep mysqld \[root@hadoopcm-01local\]\# rpm -qa |grep -i mysql ### 3.tar and mv ### \[root@hadoopcm-01local\]\# tar xzvf mysql-5.6.22-linux-glibc2.5-x86\_64.tar.gz \[root@hadoopcm-01local\]\# mv mysql-5.6.22-linux-glibc2.5-x86\_64 mysql ### 4.Create group and user ### \[root@hadoopcm-01local\]\# groupadd -g 101 dba \[root@hadoopcm-01local\]\# useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin \[root@hadoopcm-01local\]\# id mysqladmin uid=514(mysqladmin)gid=101(dba) groups=101(dba),0(root) \[root@hadoopcm-01local\]\# passwd mysqladmin Changingpassword for user mysqladmin. New UNIXpassword: BADPASSWORD: it is too simplistic/systematic Retypenew UNIX password: passwd:all authentication tokens updated successfully. \[root@hadoopcm-01local\]\# \#\# ifuser mysqladmin is existing,please execute the following command of usermod. \#\#\[root@hadoopcm-01local\]\# usermod -u 514 -g dba -G root -d /usr/local/mysql mysqladmin \#\#copy 环境变量配置文件至 mysqladmin用户的 home 目录中,为了以下步骤配置个人环境变量 \[root@hadoopcm-01local\]\# cp /etc/skel/.\* /usr/local/mysql \#\#\#important cp:omitting directory \`/etc/skel/.' cp:omitting directory \`/etc/skel/..' cp:omitting directory \`/etc/skel/.mozilla' ### 5.Create/etc/my.cnf(640) ### \#defualtstart:/etc/my.cnf->/etc/mysql/my.cnf->SYSCONFDIR/my.cnf->$MYSQL\_HOME/my.cnf->-- defaults-extra-file->~/my.cnf \[root@hadoopcm-01mysql\]\# cd /etc/ \[root@hadoopcm-01etc\]\# touch my.cnf \[root@hadoopcm-01etc\]\# vi my.cnf \[client\] port=3306 socket=/usr/local/mysql/data/mysql.sock \[mysqld\] port=3306 socket= /usr/local/mysql/data/mysql.sock skip-external-locking key\_buffer\_size= 256M sort\_buffer\_size= 2M read\_buffer\_size= 2M read\_rnd\_buffer\_size= 4M query\_cache\_size=32M max\_allowed\_packet= 16M myisam\_sort\_buffer\_size=128M tmp\_table\_size=32M table\_open\_cache= 512 thread\_cache\_size= 8 wait\_timeout= 86400 interactive\_timeout= 86400 max\_connections= 600 \# Trynumber of CPU's\*2 for thread\_concurrency thread\_concurrency= 32 \#isolationlevel and default engine default-storage-engine= INNODB transaction-isolation= READ-COMMITTED server-id=1 basedir=/usr/local/mysql datadir=/usr/local/mysql/data pid-file=/usr/local/mysql/data/hostname.pid \#openperformance schema log-warnings sysdate-is-now binlog\_format= MIXED log\_bin\_trust\_function\_creators=1 log-error= /usr/local/mysql/data/hostname.err log-bin=/usr/local/mysql/arch/mysql-bin \#otherlogs \#general\_log=1 \#general\_log\_file= /usr/local/mysql/data/general\_log.err \#slow\_query\_log=1 \#slow\_query\_log\_file=/usr/local/mysql/data/slow\_log.err \#forreplication slave \#log-slave-updates \#sync\_binlog= 1 \#forinnodb options innodb\_data\_home\_dir= /usr/local/mysql/data/ innodb\_data\_file\_path= ibdata1:500M:autoextend innodb\_log\_group\_home\_dir= /usr/local/mysql/arch innodb\_log\_files\_in\_group= 2 innodb\_log\_file\_size= 200M innodb\_buffer\_pool\_size= 2048M innodb\_additional\_mem\_pool\_size= 50M innodb\_log\_buffer\_size= 16M innodb\_lock\_wait\_timeout= 100 \#innodb\_thread\_concurrency= 0 innodb\_flush\_log\_at\_trx\_commit= 1 innodb\_locks\_unsafe\_for\_binlog=1 \#innodbio features: add for mysql5.5.8 performance\_schema innodb\_read\_io\_threads=4 innodb-write-io-threads=4 innodb-io-capacity=200 \#purgethreads change default(0) to 1 for purge innodb\_purge\_threads=1 innodb\_use\_native\_aio=on \#case-sensitivefile names and separate tablespace innodb\_file\_per\_table= 1 lower\_case\_table\_names=1 \[mysqldump\] quick max\_allowed\_packet= 16M \[mysql\] no-auto-rehash \[mysqlhotcopy\] interactive-timeout \[myisamchk\] key\_buffer\_size= 256M sort\_buffer\_size= 256M read\_buffer= 2M write\_buffer= 2M ### 6.chown and chmodprivileges and try first install ### \[root@hadoopcm-01local\]\# chown mysqladmin:dba /etc/my.cnf \[root@hadoopcm-01local\]\# chmod 640 /etc/my.cnf \[root@hadoopcm-01etc\]\# ll my.cnf \-rw-r-----1 mysqladmin dba 2201 Aug 25 23:09 my.cnf \[root@hadoopcm-01local\]\# chown -R mysqladmin:dba /usr/local/mysql \[root@hadoopcm-01local\]\# chmod -R 755 /usr/local/mysql \[root@hadoopcm-01local\]\# su - mysqladmin \[mysqladmin@hadoopcm-01~\]$ pwd /usr/local/mysql \[mysqladmin@hadoopcm-01~\]$ mkdir arch backup \[mysqladmin@hadoopcm-01~\]$ scripts/mysql\_install\_db \#\#\#import InstallingMySQL system tables..../bin/mysqld: error while loading shared libraries:libaio.so.1: cannot open shared object file: No such file or directory \#缺少 libaio.so 包 \#\#\#seeversion \[root@hadoopcm-01local\]\# cat /proc/version Linuxversion 2.6.18-164.11.1.el5 (mockbuild@builder10.centos.org) (gcc version 4.1.220080704 (Red Hat 4.1.2-46)) \#1 SMP Wed Jan 20 07:32:21 EST 2010 \[root@hadoopcm-01local\]\# rpm -qa |grep gcc libgcc-4.1.2-46.el5\_4.2 libgcc-4.1.2-46.el5\_4.2 \[root@hadoopcm-01local\]\# yum -y install libaio ### 7.Again install ### \[mysqladmin@hadoopcm-01~\]$ scripts/mysql\_install\_db --user=mysqladmin -- basedir=/usr/local/mysql--datadir=/usr/local/mysql/data ### 8.Configure mysqlservice and boot auto start ### \[root@hadoopcm-01~\]\# cd /usr/local/mysql \#将服务文件拷贝到init.d 下，并重命名为 mysql \[root@hadoopcm-01mysql\]\# cp support-files/mysql.server /etc/rc.d/init.d/mysql \#赋予可执行权限 \[root@hadoopcm-01mysql\]\# chmod +x /etc/rc.d/init.d/mysql \#删除服务 \[root@hadoopcm-01mysql\]\# chkconfig --del mysql \#添加服务 \[root@hadoopcm-01mysql\]\# chkconfig --add mysql \[root@hadoopcm-01mysql\]\# chkconfig --level 345 mysql on \[root@hadoopcm-01mysql\]\# vi /etc/rc.local \#!/bin/sh \# \# Thisscript will be executed \*after\* all the other init scripts. \# Youcan put your own initialization stuff in here if you don't \# wantto do the full Sys V style init stuff. touch/var/lock/subsys/local su - mysqladmin -c "/etc/init.d/mysql start --federated" ### 9.Start mysql and to view process and listening ### \[root@hadoopcm-01 mysql\]\# su - mysqladmin \[mysqladmin@hadoopcm-01 ~\]$ pwd /usr/local/mysql \[mysqladmin@hadoopcm-01 ~\]$ rm -rf my.cnf \[mysqladmin@hadoopcm-01 ~\]$ mysqld\_safe& \[1\] 11802 \[mysqladmin@hadoopcm-01 ~\]$ 150825 22:53:38mysqld\_safe Logging to '/usr/local/mysql/data/hostname.err'. 150825 22:53:38 mysqld\_safe Starting mysqlddaemon with databases from /usr/local/mysql/data/ 150825 22:53:39 mysqld\_safe mysqld from pidfile /usr/local/mysql/data/hostname.pid ended \[mysqladmin@hadoopcm-01 ~\]\# \[mysqladmin@hadoopcm-01 ~\]$ ps -ef|grepmysqld 5146247 6219 0 17:30 pts/1 00:00:00 /bin/sh/usr/local/mysql/bin/mysqld\_safe 5146902 6247 2 17:30 pts/1 00:00:01/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql \--datadir=/usr/local/mysql/data--plugin-dir=/usr/local/mysql/lib/plugin --log- error=/usr/local/mysql/data/hostname.err--pid-file=/usr/local/mysql/data/hostname.pid -- socket=/usr/local/mysql/data/mysql.sock--port=3306 5146927 6219 0 17:31 pts/1 00:00:00 grepmysqld \[mysqladmin@hadoopcm-01 ~\]$ netstat -tulnp| grep mysql (Not all processes could be identified,non-owned process info willnot be shown, you would have to be root to see it all.) tcp0 0 :::3306:::\*LISTEN 11541/mysqld \[root@hadoopcm-01 local\]\# service mysqlstatus MySQL running (21507)\[ OK \] ### 10.Login mysql ### \[mysqladmin@hadoopcm-01 ~\]$ mysql Welcome to the MySQL monitor. Commands endwith ; or \\g. Your MySQL connection id is 1 Server version: 5.6.23-log MySQL CommunityServer (GPL) Copyright (c) 2000, 2015, Oracle and/or itsaffiliates. All rights reserved. Oracle is a registered trademark of OracleCorporation and/or its affiliates. Other names may be trademarksof their respective owners. Type 'help;' or '\\h' for help. Type '\\c' toclear the current input statement. mysql> showdatabases; +--------------------+ |Database| +--------------------+ |information\_schema | |mysql| |performance\_schema | |test| +--------------------+ 4rows in set (0.00 sec) ### 11.Update password and Purge user ### mysql> use mysql; Database changed mysql> update user set password=password('123456')where user='root'; Query OK, 4 rows affected (0.00 sec) Rows matched: 4 Changed: 4 Warnings: 0 mysql>select host,user,password from user; +----------------+------+-------------------------------------------+ |host| user | password| +----------------+------+-------------------------------------------+ |localhost | root | \*6340BE3C15D246B0D74BAF3F135915ED19E0069F | |hadoopcm-01 | root | \*6340BE3C15D246B0D74BAF3F135915ED19E0069F | |127.0.0.1 | root | \*6340BE3C15D246B0D74BAF3F135915ED19E0069F | |::1| root | \*6340BE3C15D246B0D74BAF3F135915ED19E0069F | |localhost | || |hadoopcm-01 | || +----------------+------+-------------------------------------------+ 6rows in set (0.00 sec) mysql> deletefrom user where user=''; mysql> selecthost,user,password from user; \+----------------+------+-------------------------------------------+ | host| user | password| \+----------------+------+-------------------------------------------+ | localhost | root |\*6340BE3C15D246B0D74BAF3F135915ED19E0069F | | hadoopcm-01 | root |\*6340BE3C15D246B0D74BAF3F135915ED19E0069F | | 127.0.0.1 | root | \*6340BE3C15D246B0D74BAF3F135915ED19E0069F| | ::1| root |\*6340BE3C15D246B0D74BAF3F135915ED19E0069F | \+----------------+------+-------------------------------------------+ 4 rows in set (0.00 sec) mysql> flush privileges; ### 12.Configure .bash\_profile ### \[mysqladmin@hadoopcm-01 ~\]$ vi.bash\_profile \# .bash\_profile \# Get the aliases and functions if \[ -f ~/.bashrc \]; then . ~/.bashrc fi \# User specific environment and startupprograms MYSQL\_BASE=/usr/local/mysql export MYSQL\_BASE PATH=$PATH:$\{MYSQL\_BASE\}/bin:/usr/kerberos/bin:/opt/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X 11:/usr/X11R6/bin:/usr/local/mysql export PATH unset USERNAME \#stty erase ^H set umask to 022 umask 022 PS1=\`uname-n\`":"'$USER'":"'$PWD'":>"; export PS1 alias l="ls -ltr" alias la="ls -la" alias d="df -lk" \#alias rm="rm -i" alias bg="ps -aef|grep mysql" alias base="cd /usr/local/mysql" alias bin="cd//usr/local/mysql/bin" alias dba="cd/usr/local/mysql/dba" alias sh="cd/usr/local/mysql/dba/sh" alias sql="cd/usr/local/mysql/dba/sql" alias config="cd/usr/local/mysql/dba/config" alias dbalog="cd/usr/local/mysql/dba/log" alias arch="cd/usr/local/mysql/arch" alias data="cd/usr/local/mysql/data" \#\# endendend Remark: Error1: File '/usr/local/mysql/arch/mysql-bin.index'not found (Errcode: 13) test2.localdomain:mysqladmin:/usr/local/mysql/arch:>chmod755 \* test2.localdomain:mysqladmin:/usr/local/mysql/arch:>chown–R mysqladmin:dba \* [http_mirror.lug.udel.edu_pub_mysql_MySQL-5.6_mysql-5.6.22-linux-glibc2.5-x86_64.tar.gz.md5]: http://mirror.lug.udel.edu/pub/mysql/MySQL-5.6/mysql-5.6.22-linux-glibc2.5-x86_64.tar.gz.md5
还没有评论，来说两句吧...