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
[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 *