search

gitava / Big-Data-Study

For studying big data
2 stars 0 forks source link

centos mysql8 -bash: mysql: command not found #8

Closed gitava closed 4 years ago

gitava commented 4 years ago

After installation, couldn't find mysql command anywhere.

gitava commented 4 years ago 
[vagrant@hdp-node-02 ~]$ rpm -ql mysql-community-client-8.0.20-1.el7.x86_64
/usr/bin/mysql
/usr/bin/mysql_config_editor
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
/usr/bin/mysqlcheck
/usr/bin/mysqldump
/usr/bin/mysqlimport
/usr/bin/mysqlpump
/usr/bin/mysqlshow
/usr/bin/mysqlslap
/usr/share/doc/mysql-community-client-8.0.20
/usr/share/doc/mysql-community-client-8.0.20/LICENSE
/usr/share/doc/mysql-community-client-8.0.20/README
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysql_config_editor.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqlbinlog.1.gz
/usr/share/man/man1/mysqlcheck.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqlimport.1.gz
/usr/share/man/man1/mysqlpump.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/man/man1/mysqlslap.1.gz
gitava commented 4 years ago 
[vagrant@hdp-node-02 ~]$ echo $PATH
/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin/:/home/vagrant/hadoop/bin/:/home/vagrant/hadoop/bin/:/home/vagrant/.local/bin:/home/vagrant/bin:/bin:/usr/bin
[vagrant@hdp-node-02 ~]$ mysql
-bash: mysql: command not found
[vagrant@hdp-node-02 ~]$ /usr/bin/mysql
-bash: /usr/bin/mysql: No such file or directory

[vagrant@hdp-node-02 bin]$ ls -l my*
-rwxr-xr-x. 1 root root  6016096 Mar 26 14:16 my_print_defaults
-rwxr-xr-x. 1 root root 17222648 Mar 26 14:17 myisam_ftdump
-rwxr-xr-x. 1 root root 18394424 Mar 26 14:17 myisamchk
-rwxr-xr-x. 1 root root 16411240 Mar 26 14:17 myisamlog
-rwxr-xr-x. 1 root root 17463520 Mar 26 14:17 myisampack
-rwxr-xr-x. 1 root root  6278240 Mar 26 14:18 mysql_config_editor
-rwxr-xr-x. 1 root root 21935256 Mar 26 14:18 mysql_secure_installation
-rwxr-xr-x. 1 root root  6855592 Mar 26 14:16 mysql_ssl_rsa_setup
-rwxr-xr-x. 1 root root  5107112 Mar 26 14:17 mysql_tzinfo_to_sql
-rwxr-xr-x. 1 root root 26440936 Mar 26 14:18 mysql_upgrade
-rwxr-xr-x. 1 root root 22011112 Mar 26 14:18 mysqladmin
-rwxr-xr-x. 1 root root 30348296 Mar 26 14:18 mysqlbinlog
-rwxr-xr-x. 1 root root 22374144 Mar 26 14:18 mysqlcheck
-rwxr-xr-x. 1 root root     4389 Mar 26 14:16 mysqld_pre_systemd
-rwxr-xr-x. 1 root root 22607768 Mar 26 14:18 mysqldump
-rwxr-xr-x. 1 root root     7690 Mar 26 14:16 mysqldumpslow
-rwxr-xr-x. 1 root root 22031920 Mar 26 14:18 mysqlimport
-rwxr-xr-x. 1 root root 42240328 Mar 26 14:18 mysqlpump
-rwxr-xr-x. 1 root root 21962680 Mar 26 14:18 mysqlshow
-rwxr-xr-x. 1 root root 22151056 Mar 26 14:18 mysqlslap
gitava commented 4 years ago

reinstall mysql-client

vagrant@hdp-node-02 bin]$ sudo yum reinstall mysql
Failed to set locale, defaulting to C
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * extras: mirrors.aliyun.com
 * updates: mirrors.aliyun.com
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.20-1.el7 will be reinstalled
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================
 Package                      Arch         Version             Repository               Size
=============================================================================================
Reinstalling:
 mysql-community-client       x86_64       8.0.20-1.el7        mysql80-community        47 M

Transaction Summary
=============================================================================================
Reinstall  1 Package

Total download size: 47 M
Installed size: 225 M
Is this ok [y/d/N]: y
Downloading packages:
mysql-community-client-8.0.20-1.el7.x86_64.rpm                        |  47 MB  00:00:29
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-client-8.0.20-1.el7.x86_64                                1/1
  Verifying  : mysql-community-client-8.0.20-1.el7.x86_64                                1/1

Installed:
  mysql-community-client.x86_64 0:8.0.20-1.el7

Complete!
[vagrant@hdp-node-02 bin]$ rpm -ql mysql-community-client-8.0.20-1.el7.x86_64
/usr/bin/mysql
/usr/bin/mysql_config_editor
/usr/bin/mysqladmin
/usr/bin/mysqlbinlog
/usr/bin/mysqlcheck
/usr/bin/mysqldump
/usr/bin/mysqlimport
/usr/bin/mysqlpump
/usr/bin/mysqlshow
/usr/bin/mysqlslap
/usr/share/doc/mysql-community-client-8.0.20
/usr/share/doc/mysql-community-client-8.0.20/LICENSE
/usr/share/doc/mysql-community-client-8.0.20/README
/usr/share/man/man1/mysql.1.gz
/usr/share/man/man1/mysql_config_editor.1.gz
/usr/share/man/man1/mysqladmin.1.gz
/usr/share/man/man1/mysqlbinlog.1.gz
/usr/share/man/man1/mysqlcheck.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqlimport.1.gz
/usr/share/man/man1/mysqlpump.1.gz
/usr/share/man/man1/mysqlshow.1.gz
/usr/share/man/man1/mysqlslap.1.gz
[vagrant@hdp-node-02 bin]$ ls -l /usr/bin/my
myisamchk                  mysqlbinlog                mysqlpump
myisam_ftdump              mysqlcheck                 mysql_secure_installation
myisamlog                  mysql_config_editor        mysqlshow
myisampack                 mysqld_pre_systemd         mysqlslap
my_print_defaults          mysqldump                  mysql_ssl_rsa_setup
mysql                      mysqldumpslow              mysql_tzinfo_to_sql
mysqladmin                 mysqlimport                mysql_upgrade
[vagrant@hdp-node-02 bin]$ ls -l /usr/bin/my*
-rwxr-xr-x. 1 root root  6016096 Mar 26 14:16 /usr/bin/my_print_defaults
-rwxr-xr-x. 1 root root 17222648 Mar 26 14:17 /usr/bin/myisam_ftdump
-rwxr-xr-x. 1 root root 18394424 Mar 26 14:17 /usr/bin/myisamchk
-rwxr-xr-x. 1 root root 16411240 Mar 26 14:17 /usr/bin/myisamlog
-rwxr-xr-x. 1 root root 17463520 Mar 26 14:17 /usr/bin/myisampack
-rwxr-xr-x. 1 root root 23809944 Mar 26 14:18 /usr/bin/mysql
-rwxr-xr-x. 1 root root  6278240 Mar 26 14:18 /usr/bin/mysql_config_editor
-rwxr-xr-x. 1 root root 21935256 Mar 26 14:18 /usr/bin/mysql_secure_installation
-rwxr-xr-x. 1 root root  6855592 Mar 26 14:16 /usr/bin/mysql_ssl_rsa_setup
-rwxr-xr-x. 1 root root  5107112 Mar 26 14:17 /usr/bin/mysql_tzinfo_to_sql
-rwxr-xr-x. 1 root root 26440936 Mar 26 14:18 /usr/bin/mysql_upgrade
-rwxr-xr-x. 1 root root 22011112 Mar 26 14:18 /usr/bin/mysqladmin
-rwxr-xr-x. 1 root root 30348296 Mar 26 14:18 /usr/bin/mysqlbinlog
-rwxr-xr-x. 1 root root 22374144 Mar 26 14:18 /usr/bin/mysqlcheck
-rwxr-xr-x. 1 root root     4389 Mar 26 14:16 /usr/bin/mysqld_pre_systemd
-rwxr-xr-x. 1 root root 22607768 Mar 26 14:18 /usr/bin/mysqldump
-rwxr-xr-x. 1 root root     7690 Mar 26 14:16 /usr/bin/mysqldumpslow
-rwxr-xr-x. 1 root root 22031920 Mar 26 14:18 /usr/bin/mysqlimport
-rwxr-xr-x. 1 root root 42240328 Mar 26 14:18 /usr/bin/mysqlpump
-rwxr-xr-x. 1 root root 21962680 Mar 26 14:18 /usr/bin/mysqlshow
-rwxr-xr-x. 1 root root 22151056 Mar 26 14:18 /usr/bin/mysqlslap
[vagrant@hdp-node-02 bin]$
gitava commented 4 years ago

Working now.

[vagrant@hdp-node-02 ~]$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 8.0.20 MySQL Community Server - GPL

Copyright (c) 2000, 2020, 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>