mysql dat_sub,MySQL/mysql的部署及常规使用

1，部署方式：

(1)rpm包 yum install mysql-server

yum install mysql-client

部署简单但是目录固化

(2)二进制部署 部署麻烦但是目录定制化

2，如何安装

(1)在cd /usr/local路径上传jdk和mysql安装包

(2)上传好了

(3)打开路径cd /usr/local

创建jajva文件夹：mkdir -p /usr/java

将安装包移到java目录下：mv jdk-8u45-linux-x64.gz /usr/java/

(4)解压：tar -xzvf jdk-8u45-linux-x64.gz

画面太长了，截不了图。。。

(5)注意注意：解压后的用户组的有问题的，要改过来

chown -R root:root jdk1.8.0_45

(6)配置环境变量：

vi /etc/profile

export JAVA_HOME=/usr/java/jdk1.8.0_45

export PATH=JAVAH​OME/bin:RZDATA_HOME/bin:$PATH

(7)生效：source /etc/profile

确认which一下：which java

看看java版本：java -version

3，Check isnot install检查是否安装：

ps -ef|grep mysqld

rpm -qa |grep -i mysql

4，tar and mv

(1)/usr/local下解压tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz

(2)重命名为mysql：mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql

5，Create group and user

(1)groupadd -g 101 dba

(2)useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin

(3)id mysqladmin

(4)cp /etc/skel/.* /usr/local/mysql

6，Create /etc/my.cnf(640)

(1)cd /etc/

(2)touch my.cnf

(3)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

Try number of CPU’s*2 for thread_concurrency

thread_concurrency = 32

#isolation level 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

#open performance 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

#other logs

#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

#for replication slave

#log-slave-updates

#sync_binlog = 1

#for innodb 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

#innodb io features: add for mysql5.5.8

performance_schema

innodb_read_io_threads=4

innodb-write-io-threads=4

innodb-io-capacity=200

#purge threads change default(0) to 1 for purge

innodb_purge_threads=1

innodb_use_native_aio=on

#case-sensitive file 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

修改:

innodb_buffer_pool_size = 1024M(生产上一般放8G/12G)

7，chown and chmod privileges and try first install

(1)chown mysqladmin:dba /etc/my.cnf

(2)chmod 640 /etc/my.cnf

(3)chown -R mysqladmin:dba /usr/local/mysql

(4)chmod -R 755 /usr/local/mysql

(5)创建binlog文件

yum -y install libaio

[mysqladmin@hadoop000 ~]$ scripts/mysql_install_db --user=mysqladmin --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

8，Configure mysql service and boot auto start

(1)cd /usr/local/mysql

(2)cp support-files/mysql.server /etc/rc.d/init.d/mysql

(3)chmod +x /etc/rc.d/init.d/mysql

(4)chkconfig --add mysql

(5)chkconfig --add mysql

(6)vi /etc/rc.local加上touch /var/lock/subsys/local

9，Start mysql and to view process and listening

(1)su - mysqladmin

(2)rm -rf my.cnf

注意：环境变量要配置([mysqladmin@hadoop000 ~]$ vi .bash_profile)export MYSQL_HOME=/usr/local/mysql

export PATH=$MYSQL_HOME/bin:$PATH

确认环境变量生效：

(3)mysqld_safe &(然后要按回车 直接后台)

(4)ps -ef|grep mysqld

(5)netstat -tulnp | grep mysql

10，Login mysql

(1)[mysqladmin@hadoop000 ~]$ mysql

(2)mysql> show databases;

11，Update password and Purge user

(1)mysql> use mysql

(2)mysql> select user,password,host from user;

用户 密码 能够允许外在的机器来访问

(3)mysql> update user set password=password(‘123456’) where user=‘root’;

(4)mysql> select host,user,password from user;

(5)mysql> delete from user where user=’’;删空账号

(6)mysql> select host,user,password from user;重新查一下

(7)flush privileges;刷新权限

12，create database ruozedb;

(1)登陆root账号，报错密码不对，因为上面设置了密码，所以要密码登陆

(2)创建ruozedb：

mysql> create database ruozedb;

mysql> show databases;

(3)grant all privileges on ruozedb.* to ruoze@’%’ identified by ‘123456’;

(4)flush privileges;刷新权限

另外开一个窗口测试一下