-mysql-部署1

最新推荐文章于 2022-06-08 11:14:09 发布
最新推荐文章于 2022-06-08 11:14:09 发布
阅读量231 收藏
点赞数
分类专栏： SQL体系 文章标签： MySQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/chen_2_2/article/details/94154588
版权

MySQL rpm 安装

[root@hadoop001 ~]# rpm -e mysql-libs-5.1.73-8.el6_8.x86_64   删除原有的里屋包
[root@hadoop001 ~]# rpm -e --nodeps mysql-libs-5.1.73-8.el6_8.x86_64   有依赖关系，加上--nodeps

[root@hadoop001 ~]# yum search mysql    搜索
[root@hadoop001 ~]# yum install mysql-server.x86_64 mysql.x86_64   安装
[root@hadoop001 ~]# service mysqld start   启动
Starting mysqld:                                           [  OK  ]
[root@hadoop001 ~]# mysql   进入

出现这种报错的解决方案

[root@hadoop001 ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


[root@hadoop001 ~]# ps -ef|grep mysql
root      9441     1  0 23:08 pts/2    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql     9527  9441  0 23:08 pts/2    00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/hadoop001.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root      9555  8017  0 23:11 pts/2    00:00:00 grep mysql

[root@hadoop001 ~]# mysql --socket=/var/lib/mysql/mysql.sock
mysql> 
mysql>

MySQL tar安装

1.Upload tar

rz  上传

在这里插入图片描述

ll  查看
[root@hadoop001 ~]# mv mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz /usr/local     移动
[root@hadoop001 ~]# cd /usr/local
[root@hadoop001 local]# ll
total 304512
drwxr-xr-x. 2 root root      4096 Jun 27 09:22 bin
drwxr-xr-x. 2 root root      4096 Sep 23  2011 etc
drwxr-xr-x. 2 root root      4096 Sep 23  2011 games
drwxr-xr-x. 2 root root      4096 Sep 23  2011 include
drwxr-xr-x. 2 root root      4096 Jun 27 06:03 lib
drwxr-xr-x. 2 root root      4096 Sep 23  2011 lib64
drwxr-xr-x. 2 root root      4096 Sep 23  2011 libexec
-rw-r--r--  1 root root 311771412 Jun 29 15:12 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x. 2 root root      4096 Jun 24 23:04 sbin
drwxr-xr-x. 5 root root      4096 Jul  8  2016 share
drwxr-xr-x. 2 root root      4096 Sep 23  2011 src

2.Check isnot install 查看别人是否部署

[root@hadoop001 local]# ps -ef|grep mysald   是否有残留进程
root     32382 30576  0 16:15 pts/0    00:00:00 grep mysald
[root@hadoop001 local]# rpm -qa |grep -i mysql     
perl-DBD-MySQL-4.013-3.el6.x86_64
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-server-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64
[root@hadoop001 local]#

3tar and mv and 软连接

tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz   解压
[root@hadoop001 local]# mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql        软连接不需要重命名
[root@hadoop001 local]# ll
total 304516
drwxr-xr-x.  2 root root      4096 Jun 27 09:22 bin
drwxr-xr-x.  2 root root      4096 Sep 23  2011 etc
drwxr-xr-x.  2 root root      4096 Sep 23  2011 games
drwxr-xr-x.  2 root root      4096 Sep 23  2011 include
drwxr-xr-x.  2 root root      4096 Jun 27 06:03 lib
drwxr-xr-x.  2 root root      4096 Sep 23  2011 lib64
drwxr-xr-x.  2 root root      4096 Sep 23  2011 libexec
drwxr-xr-x  13 root root      4096 Jun 29 16:23 mysql
-rw-r--r--   1 root root 311771412 Jun 29 15:12 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x.  2 root root      4096 Jun 24 23:04 sbin
drwxr-xr-x.  5 root root      4096 Jul  8  2016 share
drwxr-xr-x.  2 root root      4096 Sep 23  2011 src
[root@hadoop001 local]# ln -s mysql-5.6.23-linux-glibc2.5-x86_64 mysql      软连接
[root@hadoop001 local]# ll
total 304516
drwxr-xr-x.  2 root root      4096 Jun 27 09:22 bin
drwxr-xr-x.  2 root root      4096 Sep 23  2011 etc
drwxr-xr-x.  2 root root      4096 Sep 23  2011 games
drwxr-xr-x.  2 root root      4096 Sep 23  2011 include
drwxr-xr-x.  2 root root      4096 Jun 27 06:03 lib
drwxr-xr-x.  2 root root      4096 Sep 23  2011 lib64
drwxr-xr-x.  2 root root      4096 Sep 23  2011 libexec
lrwxrwxrwx   1 root root        34 Jun 29 16:31 mysql -> mysql-5.6.23-linux-glibc2.5-x86_64
drwxr-xr-x  13 root root      4096 Jun 29 16:23 mysql-5.6.23-linux-glibc2.5-x86_64
-rw-r--r--   1 root root 311771412 Jun 29 15:12 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x.  2 root root      4096 Jun 24 23:04 sbin
drwxr-xr-x.  5 root root      4096 Jul  8  2016 share
drwxr-xr-x.  2 root root      4096 Sep 23  2011 src

4.Create group and user

[root@hadoop001 local]# groupadd -g 101 dba
 [root@hadoop001 local]# useradd -u 521 -g dba -G root -d /usr/local/mysql mysqladmin
 [root@hadoop001 local]# id mysqladmin
uid=521(mysqladmin) gid=101(dba) groups=101(dba),0(root)

生产上是可切到 su - mysqladmin 的账户

[root@hadoop001 local]# passwd mysqladmin  设置密码
Changing password for user mysqladmin.
New password: 
BAD PASSWORD: it is too simplistic/systematic
BAD PASSWORD: is too simple
Retype new password: 
BAD PASSWORD: it is too simplistic/systematic
BAD PASSWORD: is too simple
Retype new password: 
passwd: all authentication tokens updated successfully.

##未做，但需知道此种方法

## if user mysqladmin is existing,please execute the following command of usermod.
##[root@sht-sgmhadoopnn-01 local]# usermod -u 514 -g dba -G root -d /usr/local/mysql mysqladmin #

[root@hadoop001 local]# su - mysqladmin
-bash-4.1$ 
-bash-4.1$    样式丢失
co 环境变量配置文件至mysqladmin用户的home目录中,以下步骤配置个人环境变量
-bash-4.1$ cp /etc/skel/.* ./
cp: omitting directory `/etc/skel/.'
cp: omitting directory `/etc/skel/..'
cp: cannot create regular file `./.bash_logout': Permission denied
cp: cannot create regular file `./.bash_profile': Permission denied
cp: cannot create regular file `./.bashrc': Permission denied   报错权限受限   切到有权限的用户做
-bash-4.1$ 

[root@hadoop001 local]# cp /etc/skel/.* /usr/local/mysql/  进行配置
cp: omitting directory `/etc/skel/.'
cp: omitting directory `/etc/skel/..'
[root@hadoop001 local]# su - mysqladmin
[mysqladmin@hadoop001 ~]$

5.Create /etc/my.cnf(640) rw-r-----
##defualt start: /etc/my.cnf->/etc/mysql/my.cnf->SYSCONFDIR/my.cnf->$MYSQL_HOME/my.cnf-> --defaults-extra-file->~/my.cnf

[root@hadoop001 local]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@hadoop001 local]# cp /etc/my.cnf /etc/my.cnf20190629   养成好习惯复制一份

vi my.cnf 先小写d大写G清空 然后配置以下内容

[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   #生产上这里是需要调整的，正常调成8个G到12个G够用了
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

6.chown and chmod privileges and try first install

[root@hadoop001 local]# chown mysqladmin:dba /etc/my.cnf
[root@hadoop001 local]# chmod 640 /etc/my.cnf
[root@hadoop001 etc]# ll my.cnf
-rw-r----- 1 mysqladmin dba 2218 Jun 29 17:20 my.cnf

##只修改软连接
[root@hadoop001 local]# chown -R mysqladmin:dba /usr/local/mysql
[root@hadoop001 local]# chmod -R 755 /usr/local/mysql/*
[root@hadoop001 local]# chmod -R 755 /usr/local/mysql-5.6.23-linux-glibc2.5-x86_64
[root@hadoop001 local]# ll
total 304516
drwxr-xr-x.  2 root       root      4096 Jun 27 09:22 bin
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 etc
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 games
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 include
drwxr-xr-x.  2 root       root      4096 Jun 27 06:03 lib
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 lib64
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 libexec
lrwxrwxrwx   1 mysqladmin dba         34 Jun 29 16:31 mysql -> mysql-5.6.23-linux-glibc2.5-x86_64
drwxr-xr-x  13 root       root      4096 Jun 29 17:02 mysql-5.6.23-linux-glibc2.5-x86_64
-rw-r--r--   1 root       root 311771412 Jun 29 15:12 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x.  2 root       root      4096 Jun 24 23:04 sbin
drwxr-xr-x.  5 root       root      4096 Jul  8  2016 share
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 src
[root@hadoop001 local]# cd mysql
[root@hadoop001 mysql]# ll
total 168
drwxr-xr-x  2 root root    4096 Jun 29 16:23 bin
-rwxr-xr-x  1 7161 wheel  17987 Jan 19  2015 COPYING
drwxr-xr-x  3 root root    4096 Jun 29 16:22 data
drwxr-xr-x  2 root root    4096 Jun 29 16:23 docs
drwxr-xr-x  3 root root    4096 Jun 29 16:23 include
-rwxr-xr-x  1 7161 wheel 102315 Jan 19  2015 INSTALL-BINARY
drwxr-xr-x  3 root root    4096 Jun 29 16:22 lib
drwxr-xr-x  4 root root    4096 Jun 29 16:23 man
drwxr-xr-x 10 root root    4096 Jun 29 16:23 mysql-test
-rwxr-xr-x  1 7161 wheel   2496 Jan 19  2015 README
drwxr-xr-x  2 root root    4096 Jun 29 16:22 scripts
drwxr-xr-x 28 root root    4096 Jun 29 16:22 share
drwxr-xr-x  4 root root    4096 Jun 29 16:23 sql-bench
drwxr-xr-x  2 root root    4096 Jun 29 16:22 support-files
[root@hadoop001 mysql]# 
关于文件夹的修改 修改完成后 一定要cd进去 ll再看一下里面的是否修改，未修改则进行修改

##加*代表所有的
[root@hadoop001 local]# chown -R mysqladmin:dba /usr/local/mysql/*
[root@hadoop001 local]# ll
total 304516
drwxr-xr-x.  2 root       root      4096 Jun 27 09:22 bin
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 etc
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 games
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 include
drwxr-xr-x.  2 root       root      4096 Jun 27 06:03 lib
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 lib64
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 libexec
lrwxrwxrwx   1 mysqladmin dba         34 Jun 29 16:31 mysql -> mysql-5.6.23-linux-glibc2.5-x86_64
drwxr-xr-x  13 root       root      4096 Jun 29 17:02 mysql-5.6.23-linux-glibc2.5-x86_64
-rw-r--r--   1 root       root 311771412 Jun 29 15:12 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x.  2 root       root      4096 Jun 24 23:04 sbin
drwxr-xr-x.  5 root       root      4096 Jul  8  2016 share
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 src
[root@hadoop001 local]# cd mysql
[root@hadoop001 mysql]# ll
total 168
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:23 bin
-rwxr-xr-x  1 mysqladmin dba  17987 Jan 19  2015 COPYING
drwxr-xr-x  3 mysqladmin dba   4096 Jun 29 16:22 data
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:23 docs
drwxr-xr-x  3 mysqladmin dba   4096 Jun 29 16:23 include
-rwxr-xr-x  1 mysqladmin dba 102315 Jan 19  2015 INSTALL-BINARY
drwxr-xr-x  3 mysqladmin dba   4096 Jun 29 16:22 lib
drwxr-xr-x  4 mysqladmin dba   4096 Jun 29 16:23 man
drwxr-xr-x 10 mysqladmin dba   4096 Jun 29 16:23 mysql-test
-rwxr-xr-x  1 mysqladmin dba   2496 Jan 19  2015 README
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:22 scripts
drwxr-xr-x 28 mysqladmin dba   4096 Jun 29 16:22 share
drwxr-xr-x  4 mysqladmin dba   4096 Jun 29 16:23 sql-bench
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:22 support-files
[root@hadoop001 mysql]# 

##将真实的文件也进行修改
[root@hadoop001 local]# chown mysqladmin:dba mysql-5.6.23-linux-glibc2.5-x86_64
[root@hadoop001 local]# ll
total 304516
drwxr-xr-x.  2 root       root      4096 Jun 27 09:22 bin
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 etc
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 games
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 include
drwxr-xr-x.  2 root       root      4096 Jun 27 06:03 lib
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 lib64
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 libexec
lrwxrwxrwx   1 mysqladmin dba         34 Jun 29 16:31 mysql -> mysql-5.6.23-linux-glibc2.5-x86_64
drwxr-xr-x  13 mysqladmin dba       4096 Jun 29 17:02 mysql-5.6.23-linux-glibc2.5-x86_64
-rw-r--r--   1 root       root 311771412 Jun 29 15:12 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x.  2 root       root      4096 Jun 24 23:04 sbin
drwxr-xr-x.  5 root       root      4096 Jul  8  2016 share
drwxr-xr-x.  2 root       root      4096 Sep 23  2011 src
[root@hadoop001 local]# 

[root@hadoop001 mysql]# su - mysqladmin
[mysqladmin@hadoop001 ~]$ pwd
/usr/local/mysql
##创建binlog日志存储的文件夹
[mysqladmin@sht-sgmhadoopnn-01 ~]$ mkdir arch

##报错缺少 libaio，用root权限重新安装libaio
[mysqladmin@hadoop001 ~]$ scripts/mysql_install_db  \
--user=mysqladmin \
--basedir=/usr/local/mysql \
--datadir=/usr/local/mysql/data
Installing MySQL system tables.../usr/local/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory       报错

[root@hadoop001 mysql]# yum install libaio   用root权限重新安装libaio
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package libaio.x86_64 0:0.3.107-10.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

======================================================================
 Package       Arch          Version                Repository   Size
======================================================================
Installing:
 libaio        x86_64        0.3.107-10.el6         base         21 k

Transaction Summary
======================================================================
Install       1 Package(s)

Total download size: 21 k
Installed size: 34 k
Is this ok [y/N]: y
Downloading Packages:
libaio-0.3.107-10.el6.x86_64.rpm               |  21 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libaio-0.3.107-10.el6.x86_64                       1/1 
/sbin/ldconfig: File /usr/lib/libiacpkmn.so.3 is empty, not checked.
  Verifying  : libaio-0.3.107-10.el6.x86_64                       1/1 

Installed:
  libaio.x86_64 0:0.3.107-10.el6                                      

Complete!

7.Again install
真正命令

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


To do so, start the server, then issue the following commands
要我们去启动，嗯成功了

8.Configure mysql service and boot auto start

[root@hadoop001 ~]# cd /usr/local/mysql
[root@hadoop001 mysql]# cp support-files/mysql.server /etc/rc.d/init.d/mysql     #将服务文件拷贝到init.d下，并重命名为mysql
[root@hadoop001 mysql]# chmod +x /etc/rc.d/init.d/mysql   #赋予可执行权限
[root@hadoop001 mysql]# chkconfig --del mysql   #删除服务
[root@hadoop001 mysql]# chkconfig --add mysql   #添加服务
[root@hadoop001 mysql]# chkconfig --level 345 mysql on   # 代表开启自启动

[root@hadoop001 mysql]# vi /etc/rc.local

#!/bin/sh
 BOOTSTRAP_CONF=/ucloud_boot/bsi-ihue3o.conf BOOTSTRAP_DIR=/ucloud_boot DISTRO=centos MAJOR=6 MINOR=6 /bin/bash /ucloud_boot/bootstrap.sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local

su - mysqladmin -c "etc/init.d/mysql start "   编辑此内容
bash /usr/local/bin/set_irq_affinity.sh

9.Start mysql and to view process and listening

[root@hadoop001 mysql]# su - mysqladmin
[mysqladmin@hadoop001 ~]$ pwd
/usr/local/mysql
[mysqladmin@hadoop001 ~]$ ll
total 180
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 18:09 arch
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:23 bin
-rwxr-xr-x  1 mysqladmin dba  17987 Jan 19  2015 COPYING
drwxr-xr-x  5 mysqladmin dba   4096 Jun 29 18:09 data
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:23 docs
drwxr-xr-x  3 mysqladmin dba   4096 Jun 29 16:23 include
-rwxr-xr-x  1 mysqladmin dba 102315 Jan 19  2015 INSTALL-BINARY
drwxr-xr-x  3 mysqladmin dba   4096 Jun 29 16:22 lib
drwxr-xr-x  4 mysqladmin dba   4096 Jun 29 16:23 man
-rw-r--r--  1 mysqladmin dba    943 Jun 29 18:01 my.cnf
-rw-r--r--  1 mysqladmin dba    943 Jun 29 18:09 my-new.cnf
drwxr-xr-x 10 mysqladmin dba   4096 Jun 29 16:23 mysql-test
-rwxr-xr-x  1 mysqladmin dba   2496 Jan 19  2015 README
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:22 scripts
drwxr-xr-x 28 mysqladmin dba   4096 Jun 29 16:22 share
drwxr-xr-x  4 mysqladmin dba   4096 Jun 29 16:23 sql-bench
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:22 support-files
[mysqladmin@hadoop001 ~]$ rm -f my.cnf
[mysqladmin@hadoop001 ~]$ ll
total 176
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 18:09 arch
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:23 bin
-rwxr-xr-x  1 mysqladmin dba  17987 Jan 19  2015 COPYING
drwxr-xr-x  5 mysqladmin dba   4096 Jun 29 18:09 data
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:23 docs
drwxr-xr-x  3 mysqladmin dba   4096 Jun 29 16:23 include
-rwxr-xr-x  1 mysqladmin dba 102315 Jan 19  2015 INSTALL-BINARY
drwxr-xr-x  3 mysqladmin dba   4096 Jun 29 16:22 lib
drwxr-xr-x  4 mysqladmin dba   4096 Jun 29 16:23 man
-rw-r--r--  1 mysqladmin dba    943 Jun 29 18:09 my-new.cnf
drwxr-xr-x 10 mysqladmin dba   4096 Jun 29 16:23 mysql-test
-rwxr-xr-x  1 mysqladmin dba   2496 Jan 19  2015 README
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:22 scripts
drwxr-xr-x 28 mysqladmin dba   4096 Jun 29 16:22 share
drwxr-xr-x  4 mysqladmin dba   4096 Jun 29 16:23 sql-bench
drwxr-xr-x  2 mysqladmin dba   4096 Jun 29 16:22 support-files
[mysqladmin@hadoop001 ~]$bin/mysqld_safe &
[1] 11219
[mysqladmin@hadoop001 ~]$ 190630 00:53:43 mysqld_safe Logging to '/usr/local/mysql/data/hostname.err'.
190630 00:53:43 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

[mysqladmin@hadoop001 ~]$ 

[mysqladmin@hadoop001 ~]$ ps -ef|grep mysqld  查看进程
521      11219 11195  0 00:53 pts/5    00:00:00 /bin/sh bin/mysqld_safe
521      11864 11219  0 00:53 pts/5    00:00:00 /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
521      11893 11195  0 00:54 pts/5    00:00:00 grep mysqld

[root@hadoop001 ~]# netstat -nlp|grep 30939  查看端口号
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)#没有权限，用root账号查看
 [root@hadoop001 ~]# netstat -nlp|grep 11864
tcp        0      0 :::3306                     :::*                        LISTEN      11864/mysqld        
unix  2      [ ACC ]     STREAM     LISTENING     10146392 11864/mysqld        /usr/local/mysql/data/mysql.sock


#netstat -tulnp | grep mysql方法2#需用root权限查看#
[root@hadoop001 ~]# netstat -tulnp | grep mysql
tcp        0      0 :::3306                     :::*                        LISTEN      11864/mysqld        
[root@hadoop001 ~]# ps -ef|grep mysql
root     11194 10886  0 00:52 pts/5    00:00:00 su - mysqladmin
521      11219 11195  0 00:53 pts/5    00:00:00 /bin/sh bin/mysqld_safe
521      11864 11219  0 00:53 pts/5    00:00:00 /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
root     11935 10871  0 00:58 pts/4    00:00:00 grep mysql

[mysqladmin@hadoop001 data]$ service mysqld start
Starting mysqld:                                           [  OK  ]
service mysql status

10.Login mysql

vi /etc/profile 配置全局环境变量

export JAVA_HOME=/usr/java/jdk1.8.0_45
export MYSQL_HOME=/usr/local/mysql   编辑
    
    PATH=${MYSQL__HOME}/bin:${JAVA_HOME}/bin:$PATH
    export PATH

[root@hadoop001 ~]# source /etc/profile     生效
[root@hadoop001 ~]# su - mysqladmin
[mysqladmin@hadoop001 ~]$ mysql
mysql>show databases;   #命令
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '123456
show databases' at line 3
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

mysql>

11.Update password and Purge user

mysql> use mysql;   ##命令
Database changed

mysql> show tables;命令
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| innodb_index_stats        |
| innodb_table_stats        |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| servers                   |
| slave_master_info         |
| slave_relay_log_info      |
| slave_worker_info         |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+

mysql> select user,host,password from user;
+------+-----------+----------+
| user | host      | password |
+------+-----------+----------+
| root | localhost |          |
| root | hadoop001 |          |
| root | 127.0.0.1 |          |
| root | ::1       |          |
|      | localhost |          |
|      | hadoop001 |          |
+------+-----------+----------+
6 rows in set (0.00 sec)

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 user,host,password from user;  ##
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | hadoop001 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | 127.0.0.1 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | ::1       | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
|      | localhost |                                           |
|      | hadoop001 |                                           |
+------+-----------+-------------------------------------------+
6 rows in set (0.00 sec)

mysql> 

mysql> delete from user where user='';   ##删除两行
Query OK, 2 rows affected (0.01 sec)

mysql> select user,host,password from user;##
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | hadoop001 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | 127.0.0.1 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| root | ::1       | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)

mysql> 

只要MySQL关于用户操作 这是最后一步 不要忘记：
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>

12.Configure .bash_profile （已全局变量环境配置）

vi .bash_profile   编辑配置

#stty erase ^H
set umask to 022
umask 022
PS1=`uname -n`":"'$USER'":"'$PWD'":>"; export PS1

[mysqladmin@hadoop001 ~]$ exit
logout
[root@hadoop001 ~]# chown -R mysqladmin:dba /usr/local/mysql/*
[root@hadoop001 ~]# su - mysqladmin
hadoop001:mysqladmin:/usr/local/mysql:>
hadoop001:mysqladmin:/usr/local/mysql:>
hadoop001:mysqladmin:/usr/local/mysql:>
hadoop001:mysqladmin:/usr/local/mysql:>
hadoop001:mysqladmin:/usr/local/mysql:>
hadoop001:mysqladmin:/usr/local/mysql:>
hadoop001:mysqladmin:/usr/local/mysql:>
hadoop001:mysqladmin:/usr/local/mysql:>

===============================

重新部署

service mysql stop

rm -rf /usr/local/mysql/arch/*
rm -rf /usr/local/mysql/data/*

scripts/mysql_install_db  \
--user=mysqladmin \
--basedir=/usr/local/mysql \
--datadir=/usr/local/mysql/data

======================================

部署注意：
1 注意一些命令分别是在那些用户下执行
2 MySQL端口号是：3306
3遇到问题找log日志找error关键词
4MySQL文件夹下所有的用户用户组及其本目录的权限变更

吾..二..二
关注
专栏目录
error while loading shared libraries: libgmp.so.10 GMP 找不到共享库文件问题
ai297313的专栏
03-28 2万+
编写了一个使用GMP库的程序，编译可以通过，但是运行总是提示错误： error while loading shared libraries: libgmp.so.10: cannot open shared object file: No such file or directory. 在命令行查找libgmp.so.10 发现库文件存在，于是把该路径加到LD_LIBRARY_PATH
MySQL1-mysql的部署
最新发布
06-27
MySQL1-mysql的部署
error while loading shared libraries的解决方案
热门推荐
weixin_42310458的博客
06-08 6万+
error while loading shared libraries: libXXXXXXX.so.1: cannot open shared object file: No such file or directory的解决方案
error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such
一个骚年的博客
11-06 1万+
error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such 一般这个错误就是依赖包没装完，执行以下安装即可 yum install libnsl.x86_64
Docker---问题1:bash: vi: command not found/bash: vim: command not found
添砖加瓦
11-05 1035
在使用docker时，有时候我们需要编辑配置文件，需要使用vim或者vi命令，发现： root@64801a03b121:/etc/nginx/conf.d# vi default.conf bash: vi: command not found root@64801a03b121:/etc/nginx/conf.d# vim default.conf bash: vim: command...
error while loading shared libraries的解決方法
1BX
01-30 291
我是在启动nginx的时候报这个错误，搜索这个错误时发现这篇文章，非本人（小渡博客）原创。 原文地址：http://blog.csdn.net/dumeifang/article/details/2963223 正文： 在linux下运行程序时，发现了error while loading shared libraries这种错误，一时间不知道解决办法，在网上搜索，终于解决了： ./tes...
centos7--mysql安装部署.docx
09-09
mysql> set global validate_password_length=1; ``` 然后，修改root用户的密码（注意Linux环境下密码区分大小写）： ```sql ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; ``` 配置远程访问权限，允许任何...
手把手的 django-docker-mysql-nginx-gunicorn 部署教程
11-21
这是教你手把手部署 Docker + Django + Mysql + Ngnix + Gunicorn 的傻瓜式教程，目的是让 Docker 菜鸟也能快速部署容器化的 Django 应用。 特色： 零基础、免费、中文、完整项目代码 基于最新的 Docker 19.03.1、...
django-docker 手把手的 django-docker-mysql-nginx-gunicorn 部署教程
01-12
django-docker 手把手的 django-docker-mysql-nginx-gunicorn 部署教程
测试局域网两台机器的之间的最大带宽
08-24 1126
工具下载：https://iperf.fr/iperf-download.php 测试环境： 服务端（CentOS7）： 1、快速安装 wget -O /usr/lib/libiperf.so.0 https://iperf.fr/download/ubuntu/libiperf.so.0_3.1.3 wget -O /usr/bin/iperf3 https://iperf.fr...
iperf3 安装遇到 error while loading shared libraries: libiperf.so.0
向死往生
07-29 6125
iperf3: error while loading shared libraries: libiperf.so.0: cannot open shared object file: No such file or directory 这个问题容易发生在centos6 和Ubuntu较老版本上: 编译错误. 解决方法: 在正常编译后运行. ldconfig https://github.c...
bin/mysqld: error while loading shared libraries: libnuma.so.1: 安装mysql
liukai6的博客
10-23 4万+
如果安装mysql出现了以上的报错信息.这是却少numactl这个时候如果是Centos就yum -y install numactl就可以解决这个问题了. ubuntu的就sudo apt-get install numactl就可以解决这个问题了
linux ldconfig命令,环境变量文件配置详解
winycg的博客
06-04 5万+
ldconfig 参考：http://man.linuxde.net/ldconfig https://blog.csdn.net/chenzixun0/article/details/56278632 主要是在默认搜寻目录/lib和/usr/lib以及动态库配置文件/etc/ld.so.conf内所列的目录下，搜索出可共享的动态链接库（格式如lib*.so*）,进而创建出动态装入程序(ld...
Linux中error while loading shared libraries错误解决办法
zhang_yang_43的专栏
10-02 1万+
转载自http://www.cnblogs.com/codingmengmeng/p/7456539.html 默认情况下，编译器只会使用/lib和/usr/lib这两个目录下的库文件，通常通过源码包进行安装时，如果不指定--prefix，会将库安装在/usr/local/lib目录下；当运行程序需要链接动态库时，提示找不到相关的.so库，会报错。也就是说，/usr/local/lib目录不在系
./nginx: error while loading shared libraries: libpcre.so.1
屌丝小柏的博客
12-15 2160
启动nginx提示：error while loading shared libraries: libpcre.so.1: cannot open shared object file: No such file or directory，意思是找不到libpcre.so.1这个模块，而导致启动失败。 [root@bai sbin]# ./nginx -t ./nginx: error w
解决openssl: error while loading shared libraries: libssl.so.1.1: cannot open shared object file.....
XtremeDV
12-04 8005
由于没有superuser权限，在安装gmssl的时候，我选择安装在本地指定文件夹下，编译完，当我调用build/bin/gmssl的时候报标题中的错误，显示找不到shared libraries: libssl.so.1.1. 其实如题的错误也就是找不到动态链接库。其实Linux提供了一个设置动态链接库的方法： LD_LIBRARY_PATH是Linux环境变量名，该环境变量主要用于指定查找
XX主站HeartBeat-NFS-MYSQL部署与配置教程
4. **MYSQL数据库部署** - 安装Mysql 5.5.24版本，这可能是主从复制的基础。 - 必须有明确的安装假设，例如数据库已经备份，或者在安装过程中会进行必要的初始化操作。 5. **主从复制与自动切换** - 通过...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值