mysql部署

1.cd /usr/local
2.tar xzvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
[root@hadoop001 local]# ll
total 304468
drwxr-xr-x. 2 root root 6 Nov 5 2016 bin
drwxr-xr-x. 2 root root 6 Nov 5 2016 etc
drwxr-xr-x. 2 root root 6 Nov 5 2016 games
drwxr-xr-x. 2 root root 6 Nov 5 2016 include
drwxr-xr-x. 2 root root 6 Nov 5 2016 lib
drwxr-xr-x. 2 root root 6 Nov 5 2016 lib64
drwxr-xr-x. 2 root root 6 Nov 5 2016 libexec
drwxr-xr-x. 13 root root 213 Nov 26 09:15 mysql-5.6.23-linux-glibc2.5-x86_64
-rw-r–r--. 1 root root 311771412 Nov 25 17:50 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x. 2 root root 6 Nov 5 2016 sbin
drwxr-xr-x. 5 root root 49 Nov 9 14:43 share
drwxr-xr-x. 2 root root 6 Nov 5 2016 src

3.软连接-----------使用软连接方便 但是后面的权限需要格外注意
[root@hadoop001 local]# ln -s mysql-5.6.23-linux-glibc2.5-x86_64 mysql
[root@hadoop001 local]# ll
total 304468
drwxr-xr-x. 2 root root 6 Nov 5 2016 bin
drwxr-xr-x. 2 root root 6 Nov 5 2016 etc
drwxr-xr-x. 2 root root 6 Nov 5 2016 games
drwxr-xr-x. 2 root root 6 Nov 5 2016 include
drwxr-xr-x. 2 root root 6 Nov 5 2016 lib
drwxr-xr-x. 2 root root 6 Nov 5 2016 lib64
drwxr-xr-x. 2 root root 6 Nov 5 2016 libexec
lrwxrwxrwx. 1 root root 34 Nov 26 09:16 mysql -> mysql-5.6.23-linux-glibc2.5-x86_64
drwxr-xr-x. 13 root root 213 Nov 26 09:15 mysql-5.6.23-linux-glibc2.5-x86_64
-rw-r–r--. 1 root root 311771412 Nov 25 17:50 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz

4.添加用户和组
[root@hadoop001 local]# groupadd -g 101 dba
[root@hadoop001 local]# useradd -u 514 -g dba -G root -d /usr/local/mysql mysqladmin
useradd: warning: the home directory already exists.
Not copying any file from skel directory into it.
[root@hadoop001 local]# id mysqladmin
uid=514(mysqladmin) gid=101(dba) groups=101(dba),0(root)

[root@hadoop001 mysql]# su - mysqladmin
Last login: Tue Nov 26 10:13:08 CST 2019 on pts/0
-bash-4.2$
-bash-4.2$
-bash-4.2$
-bash-4.2$ exit
logout

5.[root@hadoop001 mysql]# cp /etc/skel/.* /usr/local/mysql
cp: omitting directory ‘/etc/skel/.’
cp: omitting directory ‘/etc/skel/…’
[root@hadoop001 mysql]# su - mysqladmin
Last login: Tue Nov 26 10:16:24 CST 2019 on pts/0
[mysqladmin@hadoop001 ~]$
[mysqladmin@hadoop001 ~]$

6.[root@hadoop001 etc]# cp my.cnf my.cnf2019
[root@hadoop001 etc]# vi my.cnf
dG清空文件
copy以下内容到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

调优参数，正常的是8G左右
innodb_buffer_pool_size = 1024M
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

[root@hadoop001 etc]# ll my.cnf
-rw-r–r--. 1 root root 2218 Nov 26 10:30 my.cnf

7.[root@hadoop001 etc]# chown mysqladmin:dba /etc/my.cnf
[root@hadoop001 etc]# chmod 640 /etc/my.cnf
[root@hadoop001 etc]# ll my.cnf
-rw-r-----. 1 mysqladmin dba 2218 Nov 26 10:30 my.cnf
[root@hadoop001 etc]#

8.[root@hadoop001 local]# chown -R mysqladmin:dba /usr/local/mysql
[root@hadoop001 local]# ll
total 304468
drwxr-xr-x. 2 root root 6 Nov 5 2016 bin
drwxr-xr-x. 2 root root 6 Nov 5 2016 etc
drwxr-xr-x. 2 root root 6 Nov 5 2016 games
drwxr-xr-x. 2 root root 6 Nov 5 2016 include
drwxr-xr-x. 2 root root 6 Nov 5 2016 lib
drwxr-xr-x. 2 root root 6 Nov 5 2016 lib64
drwxr-xr-x. 2 root root 6 Nov 5 2016 libexec
lrwxrwxrwx. 1 mysqladmin dba 34 Nov 26 09:16 mysql -> mysql-5.6.23-linux-glibc2.5-x86_64
drwxr-xr-x. 13 root root 269 Nov 26 10:17 mysql-5.6.23-linux-glibc2.5-x86_64
-rw-r–r--. 1 root root 311771412 Nov 25 17:50 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x. 2 root root 6 Nov 5 2016 sbin
drwxr-xr-x. 5 root root 49 Nov 9 14:43 share
drwxr-xr-x. 2 root root 6 Nov 5 2016 src
[root@hadoop001 local]# cd mysql
[root@hadoop001 mysql]# ll
total 148
drwxr-xr-x. 2 root root 4096 Nov 26 09:15 bin
-rw-r–r--. 1 7161 wheel 17987 Jan 19 2015 COPYING
drwxr-xr-x. 3 root root 18 Nov 26 09:15 data
drwxr-xr-x. 2 root root 55 Nov 26 09:15 docs
drwxr-xr-x. 3 root root 4096 Nov 26 09:15 include
-rw-r–r--. 1 7161 wheel 102315 Jan 19 2015 INSTALL-BINARY
drwxr-xr-x. 3 root root 4096 Nov 26 09:15 lib
drwxr-xr-x. 4 root root 30 Nov 26 09:15 man
drwxr-xr-x. 10 root root 4096 Nov 26 09:15 mysql-test
-rw-r–r--. 1 7161 wheel 2496 Jan 19 2015 README
drwxr-xr-x. 2 root root 30 Nov 26 09:15 scripts
drwxr-xr-x. 28 root root 4096 Nov 26 09:15 share
drwxr-xr-x. 4 root root 4096 Nov 26 09:15 sql-bench
drwxr-xr-x. 2 root root 136 Nov 26 09:15 support-files
注意：内部文件权限并未改变

[root@hadoop001 mysql]# chown -R mysqladmin:dba /usr/local/mysql/*
[root@hadoop001 mysql]# ll
total 148
drwxr-xr-x. 2 mysqladmin dba 4096 Nov 26 09:15 bin
-rw-r–r--. 1 mysqladmin dba 17987 Jan 19 2015 COPYING
drwxr-xr-x. 3 mysqladmin dba 18 Nov 26 09:15 data
drwxr-xr-x. 2 mysqladmin dba 55 Nov 26 09:15 docs
drwxr-xr-x. 3 mysqladmin dba 4096 Nov 26 09:15 include
-rw-r–r--. 1 mysqladmin dba 102315 Jan 19 2015 INSTALL-BINARY
drwxr-xr-x. 3 mysqladmin dba 4096 Nov 26 09:15 lib
drwxr-xr-x. 4 mysqladmin dba 30 Nov 26 09:15 man
drwxr-xr-x. 10 mysqladmin dba 4096 Nov 26 09:15 mysql-test
-rw-r–r--. 1 mysqladmin dba 2496 Jan 19 2015 README
drwxr-xr-x. 2 mysqladmin dba 30 Nov 26 09:15 scripts
drwxr-xr-x. 28 mysqladmin dba 4096 Nov 26 09:15 share
drwxr-xr-x. 4 mysqladmin dba 4096 Nov 26 09:15 sql-bench
drwxr-xr-x. 2 mysqladmin dba 136 Nov 26 09:15 support-files

9.[root@hadoop001 local]# chown -R mysqladmin:dba /usr/local/mysql-5.6.23-linux-glibc2.5-x86_64
[root@hadoop001 local]# ll
total 304468
drwxr-xr-x. 2 root root 6 Nov 5 2016 bin
drwxr-xr-x. 2 root root 6 Nov 5 2016 etc
drwxr-xr-x. 2 root root 6 Nov 5 2016 games
drwxr-xr-x. 2 root root 6 Nov 5 2016 include
drwxr-xr-x. 2 root root 6 Nov 5 2016 lib
drwxr-xr-x. 2 root root 6 Nov 5 2016 lib64
drwxr-xr-x. 2 root root 6 Nov 5 2016 libexec
lrwxrwxrwx. 1 mysqladmin dba 34 Nov 26 09:16 mysql -> mysql-5.6.23-linux-glibc2.5-x86_64
drwxr-xr-x. 13 mysqladmin dba 269 Nov 26 10:17 mysql-5.6.23-linux-glibc2.5-x86_64
-rw-r–r--. 1 root root 311771412 Nov 25 17:50 mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
drwxr-xr-x. 2 root root 6 Nov 5 2016 sbin
drwxr-xr-x. 5 root root 49 Nov 9 14:43 share
drwxr-xr-x. 2 root root 6 Nov 5 2016 src

10.chmod -R 755 /usr/local/mysql
chmod -R 755 /usr/local/mysql/*
chmod -R 755 /usr/local/mysql-5.6.23-linux-glibc2.5-x86_64

11.[root@hadoop001 local]# su - mysqladmin
Last login: Tue Nov 26 10:17:46 CST 2019 on pts/0
[mysqladmin@hadoop001 ~]$ pwd
/usr/local/mysql
[mysqladmin@hadoop001 ~]$ mkdir arch
[mysqladmin@hadoop001 ~]$ ll
total 148
drwxr-xr-x. 2 mysqladmin dba 6 Nov 26 10:53 arch
drwxr-xr-x. 2 mysqladmin dba 4096 Nov 26 09:15 bin
-rwxr-xr-x. 1 mysqladmin dba 17987 Jan 19 2015 COPYING
drwxr-xr-x. 3 mysqladmin dba 18 Nov 26 09:15 data
drwxr-xr-x. 2 mysqladmin dba 55 Nov 26 09:15 docs
drwxr-xr-x. 3 mysqladmin dba 4096 Nov 26 09:15 include
-rwxr-xr-x. 1 mysqladmin dba 102315 Jan 19 2015 INSTALL-BINARY
drwxr-xr-x. 3 mysqladmin dba 4096 Nov 26 09:15 lib
drwxr-xr-x. 4 mysqladmin dba 30 Nov 26 09:15 man
drwxr-xr-x. 10 mysqladmin dba 4096 Nov 26 09:15 mysql-test
-rwxr-xr-x. 1 mysqladmin dba 2496 Jan 19 2015 README
drwxr-xr-x. 2 mysqladmin dba 30 Nov 26 09:15 scripts
drwxr-xr-x. 28 mysqladmin dba 4096 Nov 26 09:15 share
drwxr-xr-x. 4 mysqladmin dba 4096 Nov 26 09:15 sql-bench
drwxr-xr-x. 2 mysqladmin dba 136 Nov 26 09:15 support-files

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

12.[mysqladmin@hadoop001 ~]$ scripts/mysql_install_db
–user=mysqladmin
–basedir=/usr/local/mysql
–datadir=/usr/local/mysql/data
-bash: scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory
[root@hadoop001 ~]# yum install -y perl
[mysqladmin@hadoop001 ~]$ scripts/mysql_install_db --user=mysqladmin --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
FATAL ERROR: please install the following Perl modules before executing scripts/mysql_install_db:
Data::Dumper
[root@hadoop001 ~]# yum install -y autoconf
[root@hadoop001 ~]# yum install -y libaio

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

Installing MySQL system tables…2019-11-26 11:02:02 0 [Warning] ‘THREAD_CONCURRENCY’ is deprecated and will be removed in a future release.
2019-11-26 11:02:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
OK
Filling help tables…2019-11-26 11:02:07 0 [Warning] ‘THREAD_CONCURRENCY’ is deprecated and will be removed in a future release.
2019-11-26 11:02:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/local/mysql/bin/mysqladmin -u root password ‘new-password’
/usr/local/mysql/bin/mysqladmin -u root -h hadoop001 password ‘new-password’

Alternatively you can run:

/usr/local/mysql/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd . ; /usr/local/mysql/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as /usr/local/mysql/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings

WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
–defaults-file argument to mysqld_safe when starting the server

13.[root@hadoop001 ~]# cd /usr/local/mysql
#将服务文件拷贝到init.d下，并重命名为mysql
[root@hadoop001 mysql]# cp support-files/mysql.server /etc/rc.d/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/bash
#THIS FILE IS ADDED FOR COMPATIBILITY PURPOSES
#It is highly advisable to create own systemd services or udev rules
#to run scripts during boot instead of using this file.
#In contrast to previous versions due to parallel execution during boot
#this script will NOT be run after all other services.
#Please note that you must run ‘chmod +x /etc/rc.d/rc.local’ to ensure
#that this script will be executed during boot.
touch /var/lock/subsys/local
su - mysqladmin -c “/etc/init.d/mysql start --federated”
~

14.启动程序
[mysqladmin@hadoop001 ~]$ pwd
/usr/local/mysql
[mysqladmin@hadoop001 ~]$ ll
total 152
drwxr-xr-x. 2 mysqladmin dba 115 Nov 26 11:02 arch
drwxr-xr-x. 2 mysqladmin dba 4096 Nov 26 09:15 bin
-rwxr-xr-x. 1 mysqladmin dba 17987 Jan 19 2015 COPYING
drwxr-xr-x. 5 mysqladmin dba 92 Nov 26 11:02 data
drwxr-xr-x. 2 mysqladmin dba 55 Nov 26 09:15 docs
drwxr-xr-x. 3 mysqladmin dba 4096 Nov 26 09:15 include
-rwxr-xr-x. 1 mysqladmin dba 102315 Jan 19 2015 INSTALL-BINARY
drwxr-xr-x. 3 mysqladmin dba 4096 Nov 26 09:15 lib
drwxr-xr-x. 4 mysqladmin dba 30 Nov 26 09:15 man
-rw-r–r--. 1 mysqladmin dba 943 Nov 26 11:02 my.cnf
drwxr-xr-x. 10 mysqladmin dba 4096 Nov 26 09:15 mysql-test
-rwxr-xr-x. 1 mysqladmin dba 2496 Jan 19 2015 README
drwxr-xr-x. 2 mysqladmin dba 30 Nov 26 09:15 scripts
drwxr-xr-x. 28 mysqladmin dba 4096 Nov 26 09:15 share
drwxr-xr-x. 4 mysqladmin dba 4096 Nov 26 09:15 sql-bench
drwxr-xr-x. 2 mysqladmin dba 136 Nov 26 09:15 support-files
[mysqladmin@hadoop001 ~]$ rm -f my.cnf
[mysqladmin@hadoop001 ~]$ which mysqld_safe
~/bin/mysqld_safe
[mysqladmin@hadoop001 ~]$ service mysql start
Starting MySQL. SUCCESS!
[mysqladmin@hadoop001 ~]$ service mysql status
SUCCESS! MySQL running (2569)
[mysqladmin@hadoop001 ~]$ ps -ef|grep mysqld
mysqlad+ 1900 1 0 11:29 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/hostname.pid
mysqlad+ 2569 1900 0 11:29 pts/0 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
mysqlad+ 2613 1605 0 11:31 pts/0 00:00:00 grep --color=auto mysqld
[root@hadoop001 mysql]# netstat -nlp|grep 2569
tcp6 0 0 :::3306 ::😗 LISTEN 2569/mysqld
unix 2 [ ACC ] STREAM LISTENING 32367 2569/mysqld /usr/local/mysql/data/mysql.sock

============
[mysqladmin@hadoop001 ~]$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.23-log MySQL Community Server (GPL)
Copyright © 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
±-------------------+
4 rows in set (0.00 sec)
mysql> use mysql;
Database changed
mysql> select user,password,host from user;
±-----±---------±----------+
| user | password | host |
±-----±---------±----------+
| root | | localhost |
| root | | hadoop001 |
| root | | 127.0.0.1 |
| root | | ::1 |
| | | localhost |
| | | hadoop001 |
±-----±---------±----------+
6 rows in set (0.00 sec)

空密码很危险 需要干掉 root也记得重设密码哦

[mysqladmin@hadoop001 ~]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.23-log MySQL Community Server (GPL)
Copyright © 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql>
mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
±-------------------+
4 rows in set (0.00 sec)

15.修改密码
mysql> use mysql;
Database changed
mysql> update user set password=password(‘123456’) where user=‘root’;
Query OK, 4 rows affected (0.01 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> select user,password,host from user;
±-----±------------------------------------------±----------+
| user | password | host |
±-----±------------------------------------------±----------+
| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | localhost |
| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | hadoop001 |
| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | 127.0.0.1 |
| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | ::1 |
| | | localhost |
| | | hadoop001 |
±-----±------------------------------------------±----------+
6 rows in set (0.00 sec)

16.删除空帐号
mysql> delete from user where user=’’;
Query OK, 2 rows affected (0.00 sec)
mysql> select user,password,host from user;
±-----±------------------------------------------±----------+
| user | password | host |
±-----±------------------------------------------±----------+
| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | localhost |
| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | hadoop001 |
| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | 127.0.0.1 |
| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | ::1 |
±-----±------------------------------------------±----------+
4 rows in set (0.00 sec)

17.一定记得刷权限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

18.大功告成
[mysqladmin@hadoop001 ~]$ vi .bashrc
[mysqladmin@hadoop001 ~]$ source .bashrc
[mysqladmin@hadoop001 ~]$ echo $ MYSQL_HOME
/usr/local/mysql
[mysqladmin@hadoop001 ~]$ which mysql
~/bin/mysql
[mysqladmin@hadoop001 ~]$ cat .bashrc
#.bashrc
#Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
#Uncomment the following line if you don’t like systemctl’s auto-paging feature:
#export SYSTEMD_PAGER=
#User specific aliases and functions

export MYSQL_HOME=/usr/local/mysql
export PATH=$MYSQL_HOME/bin:$PATH

[mysqladmin@hadoop001 ~]$

附加：

PS1=`uname -n`":"'$USER'":"'$PWD'":>"; export PS1

[mysqladmin@hadoop001 ~]$ vi .bashrc
[mysqladmin@hadoop001 ~]$ source .bashrc
hadoop001:mysqladmin:/usr/local/mysql:>
hadoop001:mysqladmin:/usr/local/mysql:>
hadoop001:mysqladmin:/usr/local/mysql:>

链接
1.检查ip端口是否通着
2.检查防火墙
[root@hadoop001 /]# firewall-cmd --state
running
[root@hadoop001 /]# systemctl stop firewalld.service
[root@hadoop001 /]# firewall-cmd --state
not running

[root@hadoop001 /]# service httpd restart
Redirecting to /bin/systemctl restart httpd.service
[root@hadoop001 /]# netstat -nlp|grep httpd
tcp6 0 0 :::80 ::😗 LISTEN 2874/httpd

外网访问尽量不要使用ip

C:\Windows\System32\drivers\etc
ip hadoop001

grant all privileges on *.* to root@'%'  identified by 'password';
flush privileges;

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

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

去连接吧！！！！