报错及其解决方法：-bash:mysql: command not found

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
[root@yun mysql]# ./scripts/mysql_install_db   --user=mysql --datadir=/mydata/data
Installing MySQL system tables...
./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
 
Installation of system tables failed!  Examine the logs in
/mydata/data for more information.
 
You can try to start the mysqld daemon with:
 
    shell> ./bin/mysqld --skip-grant &
 
and use the command line tool ./bin/mysql
to connect to the mysql database and look at the grant tables:
 
    shell> ./bin/mysql -u root mysql
    mysql> show tables
 
Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /mydata/data that may be helpful.
 
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.
 
Please check all of the above before submitting a bug report
at http://bugs.mysql.com/
 
[root@yun mysql]# yum  -y install libaio.so.1  #缺少libaio.so.1库文件报错
Loaded plugins: fastestmirror, security
Setting up Install Process
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package libaio.i686 0:0.3.107-10.el6 will be installed
--> Finished Dependency Resolution
 
Dependencies Resolved
 
====================================================================================================================
 Package                   Arch                    Version                              Repository             Size
====================================================================================================================
Installing:
 libaio                    i686                    0.3.107-10.el6                       os                     21 k
 
Transaction Summary
====================================================================================================================
Install       1 Package(s)
 
Total download size: 21 k
Installed size: 31 k
Downloading Packages:
libaio-0.3.107-10.el6.i686.rpm                                                               |  21 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libaio-0.3.107-10.el6.i686                                                                       1/1
  Verifying  : libaio-0.3.107-10.el6.i686                                                                       1/1
 
Installed:
  libaio.i686 0:0.3.107-10.el6
 
Complete!
[root@yun mysql]# ./scripts/mysql_install_db   --user=mysql --datadir=/mydata/data
Installing MySQL system tables...
160919 14:15:59 [Note] ./bin/mysqld (mysqld 5.5.52) starting as process 6123 ...
OK
Filling help tables...
160919 14:15:59 [Note] ./bin/mysqld (mysqld 5.5.52) starting as process 6131 ...
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:
 
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h yun password 'new-password'
 
Alternatively you can run:
./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 . ; ./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/
 
[root@yun mysql]# cp support-files/my-large.cnf  /etc/my.cnf
[root@yun mysql]# cp support-files/mysql.server   /etc/init.d/mysqld
[root@yun mysql]# chkconfig --add mysqld
[root@yun mysql]# chkconfig mysqld on
[root@yun mysql]# /etc/init.d/mysqld  start
Starting MySQL.. SUCCESS!
[root@yun mysql]# mysql
-bash: mysql: command not found
[root@yun mysql]# which mysql
/usr/bin/which: no mysql in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
[root@yun mysql]#
[root@yun mysql]# cp /usr/local/mysql/bin/* /usr/local/sbin/
[root@yun mysql]# which mysql
/usr/local/sbin/mysql
[root@yun mysql]# mysql #此时为缺少libncurses.so.5库文件
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
[root@yun mysql]# yum -y install libncurses.so.5
Loaded plugins: fastestmirror, security
Setting up Install Process
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package ncurses-libs.i686 0:5.7-4.20090207.el6 will be installed
--> Processing Dependency: ncurses-base = 5.7-4.20090207.el6 for package: ncurses-libs-5.7-4.20090207.el6.i686
--> Running transaction check
---> Package ncurses-base.x86_64 0:5.7-3.20090208.el6 will be updated
--> Processing Dependency: ncurses-base = 5.7-3.20090208.el6 for package: ncurses-libs-5.7-3.20090208.el6.x86_64
---> Package ncurses-base.x86_64 0:5.7-4.20090207.el6 will be an update
--> Running transaction check
---> Package ncurses-libs.x86_64 0:5.7-3.20090208.el6 will be updated
---> Package ncurses-libs.x86_64 0:5.7-4.20090207.el6 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================================
 Package                      Arch                   Version                               Repository          Size
====================================================================================================================
Installing:
 ncurses-libs                 i686                   5.7-4.20090207.el6                    os                 249 k
Updating for dependencies:
 ncurses-base                 x86_64                 5.7-4.20090207.el6                    os                  61 k
 ncurses-libs                 x86_64                 5.7-4.20090207.el6                    os                 245 k
Transaction Summary
====================================================================================================================
Install       1 Package(s)
Upgrade       2 Package(s)
Total download size: 555 k
Downloading Packages:
(1/3): ncurses-base-5.7-4.20090207.el6.x86_64.rpm                                            |  61 kB     00:00
(2/3): ncurses-libs-5.7-4.20090207.el6.i686.rpm                                              | 249 kB     00:00
(3/3): ncurses-libs-5.7-4.20090207.el6.x86_64.rpm                                            | 245 kB     00:00
--------------------------------------------------------------------------------------------------------------------
Total                                                                               836 kB/s | 555 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating   : ncurses-base-5.7-4.20090207.el6.x86_64                                                           1/5
  Updating   : ncurses-libs-5.7-4.20090207.el6.x86_64                                                           2/5
  Installing : ncurses-libs-5.7-4.20090207.el6.i686                                                             3/5
  Cleanup    : ncurses-libs-5.7-3.20090208.el6.x86_64                                                           4/5
  Cleanup    : ncurses-base-5.7-3.20090208.el6.x86_64                                                           5/5
  Verifying  : ncurses-libs-5.7-4.20090207.el6.x86_64                                                           1/5
  Verifying  : ncurses-base-5.7-4.20090207.el6.x86_64                                                           2/5
  Verifying  : ncurses-libs-5.7-4.20090207.el6.i686                                                             3/5
  Verifying  : ncurses-base-5.7-3.20090208.el6.x86_64                                                           4/5
  Verifying  : ncurses-libs-5.7-3.20090208.el6.x86_64                                                           5/5
Installed:
  ncurses-libs.i686 0:5.7-4.20090207.el6
Dependency Updated:
  ncurses-base.x86_64 0:5.7-4.20090207.el6                 ncurses-libs.x86_64 0:5.7-4.20090207.el6
Complete!
[root@yun mysql]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.52-log MySQL Community Server (GPL)
Copyright (c) 2000, 2016, 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>

本文转自chengong1013 51CTO博客，原文链接：http://blog.51cto.com/purify/1854049，如需转载请自行联系原作者