报错及其解决方法：-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，如需转载请自行联系原作者
