![mysql 已安装但无法运行](https://linux22.com/image/566104/mysql%20%E5%B7%B2%E5%AE%89%E8%A3%85%E4%BD%86%E6%97%A0%E6%B3%95%E8%BF%90%E8%A1%8C.png)
我通过删除旧版本安装了 mysql mysql-devel mysql-server。我使用的命令如下
# rpm -e mysql mysql-server mysql-devel --nodeps
# yum install mysql mysql-server mysql-devel
# /etc/init.d/mysqld start
它说
-bash: /etc/init.d/mysqld: No such file or directory
然后我尝试找到它,所以我做到了
# locate mysqld
/etc/rc.d/init.d/mysqld
/etc/rc.d/rc0.d/K36mysqld
/etc/rc.d/rc1.d/K36mysqld
/etc/rc.d/rc2.d/S64mysqld
/etc/rc.d/rc3.d/S64mysqld
/etc/rc.d/rc4.d/S64mysqld
/etc/rc.d/rc5.d/S64mysqld
/etc/rc.d/rc6.d/K36mysqld
/usr/bin/mysqld_multi
/usr/bin/mysqld_safe
/usr/bin/mysqldump
/usr/bin/mysqldumpslow
/usr/libexec/mysqld
/usr/share/man/man1/mysqld_multi.1.gz
/usr/share/man/man1/mysqld_safe.1.gz
/usr/share/man/man1/mysqldump.1.gz
/usr/share/man/man1/mysqldumpslow.1.gz
/usr/share/man/man1/safe_mysqld.1.gz
/usr/share/man/man8/mysqld.8.gz
/var/lock/subsys/mysqld
/var/log/mysqld.log
/var/run/mysqld
所以搜索后发现这页面所以我做了
rpm -V mysql
但它说
# rpm -V mysql
package mysql is not installed
也做了
# service mysqld start
但输出是
mysqld: unrecognized service
所以我尝试再次安装它,yum install mysql
但这次输出是
yum install mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.serveraxis.net
* epel: mirror.steadfast.net
* extras: mirror.wiredtree.com
* updates: mirror.ubiquityservers.com
Setting up Install Process
Package mysql is obsoleted by MySQL-server, trying to install MySQL-server-5.1.48-1.glibc23.x86_64 instead
Package MySQL-server-5.1.48-1.glibc23.x86_64 already installed and latest version
Package mysql is obsoleted by MySQL-server, trying to install MySQL-server-5.1.48-1.glibc23.x86_64 instead
Package MySQL-server-5.1.48-1.glibc23.x86_64 already installed and latest version
Nothing to do
请指导我哪里做错了。正确的方法是什么?
编辑 我在 centos5 上
init.d 有 mysql 文件,请参见
# cd /etc/init.d/
[root@domain init.d]# ls
crond dc_server haldaemon httpd iptables iscsid kudzu mcstrans multipathd netconsole netplugd rawdevices restorecond sshd
dc_client functions halt ip6tables iscsi killall lvm2-monitor messagebus mysql netfs network rdisc single syslog
我做到了
# service mysql start
Starting MySQL SUCCESS!
[root@domain init.d]# mysql
-bash: mysql: command not found
[root@domain init.d]# mysql -u root -h localhost
-bash: mysql: command not found
已编辑
# rpm -qa | grep -i mysql
MySQL-server-5.1.48-1.glibc23
perl-DBD-MySQL-3.0007-2.el5
php-mysql-5.1.6-27.el5_5.3
MySQL-devel-5.1.48-1.glibc23
每次我这样做时,yum install mysql mysql-server mysql-devel
它都只安装 mysql-server 和 mysql-devel,而不是 mysql。如果我单独这样做,yum install mysql
它会说:
yum install mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.serveraxis.net
* epel: mirror.steadfast.net
* extras: mirror.wiredtree.com
* updates: mirror.ubiquityservers.com
Setting up Install Process
Package mysql is obsoleted by MySQL-server, trying to install MySQL-server-5.1.48-1.glibc23.x86_64 instead
Package MySQL-server-5.1.48-1.glibc23.x86_64 already installed and latest version
Package mysql is obsoleted by MySQL-server, trying to install MySQL-server-5.1.48-1.glibc23.x86_64 instead
Package MySQL-server-5.1.48-1.glibc23.x86_64 already installed and latest version
Nothing to do
和
# yum whatprovides '/usr/bin/mysql'
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.serveraxis.net
* epel: mirror.steadfast.net
* extras: mirror.wiredtree.com
* updates: mirror.ubiquityservers.com
mysql-5.0.77-4.el5_6.6.x86_64 : MySQL client programs and shared libraries
Repo : base
Matched from:
Filename : /usr/bin/mysql
mysql-5.0.77-4.el5_6.6.i386 : MySQL client programs and shared libraries
Repo : base
Matched from:
Filename : /usr/bin/mysql
MySQL-client-5.1.48-1.glibc23.x86_64 : MySQL - Client
Repo : smartfile
Matched from:
Filename : /usr/bin/mysql
再次编辑
# yum remove MySQL-server
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: MySQL-server
Loading mirror speeds from cached hostfile
* base: mirrors.serveraxis.net
* epel: mirror.steadfast.net
* extras: mirror.wiredtree.com
* updates: mirror.ubiquityservers.com
Package(s) MySQL-server available, but not installed.
No Packages marked for removal
每当我这样做时yum install mysql mysql-server mysql-devel
它都会说
# yum install mysql mysql-server mysql-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.serveraxis.net
* epel: mirror.steadfast.net
* extras: mirror.wiredtree.com
* updates: mirror.ubiquityservers.com
Setting up Install Process
Package mysql is obsoleted by MySQL-server, trying to install MySQL-server-5.1.48-1.glibc23.x86_64 instead
Package mysql is obsoleted by MySQL-server, trying to install MySQL-server-5.1.48-1.glibc23.x86_64 instead
Package mysql-server is obsoleted by MySQL-server, trying to install MySQL-server-5.1.48-1.glibc23.x86_64 instead
Package mysql-devel is obsoleted by MySQL-devel, trying to install MySQL-devel-5.1.48-1.glibc23.x86_64 instead
Package mysql-devel is obsoleted by MySQL-devel, trying to install MySQL-devel-5.1.48-1.glibc23.x86_64 instead
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction first to finish them.
The program yum-complete-transaction is found in the yum-utils package.
--> Running transaction check
---> Package MySQL-devel.x86_64 0:5.1.48-1.glibc23 set to be updated
---> Package MySQL-server.x86_64 0:5.1.48-1.glibc23 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
MySQL-devel x86_64 5.1.48-1.glibc23 smartfile 9.4 M
MySQL-server x86_64 5.1.48-1.glibc23 smartfile 19 M
Transaction Summary
========================================================================================================================================================================
Install 2 Package(s)
Upgrade 0 Package(s)
Total download size: 28 M
Is this ok [y/N]:
意味着只有 mysql-server 和 mysql-devel,而不是第三个 mysql。
更新
yum --disablerepo=smartfile install mysql mysql-server mysql-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.serveraxis.net
* epel: mirror.steadfast.net
* extras: mirror.wiredtree.com
* updates: mirror.ubiquityservers.com
Setting up Install Process
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction first to finish them.
The program yum-complete-transaction is found in the yum-utils package.
--> Running transaction check
---> Package mysql.i386 0:5.0.77-4.el5_6.6 set to be updated
--> Processing Dependency: libssl.so.6 for package: mysql
--> Processing Dependency: libcrypto.so.6 for package: mysql
---> Package mysql.x86_64 0:5.0.77-4.el5_6.6 set to be updated
---> Package mysql-devel.i386 0:5.0.77-4.el5_6.6 set to be updated
--> Processing Dependency: openssl-devel for package: mysql-devel
---> Package mysql-devel.x86_64 0:5.0.77-4.el5_6.6 set to be updated
---> Package mysql-server.x86_64 0:5.0.77-4.el5_6.6 set to be updated
--> Running transaction check
---> Package openssl.i686 0:0.9.8e-20.el5 set to be updated
--> Processing Dependency: libgssapi_krb5.so.2 for package: openssl
--> Processing Dependency: libkrb5.so.3(krb5_3_MIT) for package: openssl
--> Processing Dependency: libk5crypto.so.3 for package: openssl
--> Processing Dependency: libk5crypto.so.3(k5crypto_3_MIT) for package: openssl
--> Processing Dependency: libkrb5.so.3 for package: openssl
---> Package openssl-devel.x86_64 0:0.9.8e-20.el5 set to be updated
--> Processing Dependency: krb5-devel for package: openssl-devel
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.6.1-62.el5 set to be updated
--> Processing Dependency: libselinux-devel for package: krb5-devel
--> Processing Dependency: e2fsprogs-devel for package: krb5-devel
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel
---> Package krb5-libs.i386 0:1.6.1-62.el5 set to be updated
--> Processing Dependency: libkeyutils.so.1 for package: krb5-libs
--> Processing Dependency: libkeyutils.so.1(KEYUTILS_0.3) for package: krb5-libs
--> Running transaction check
---> Package e2fsprogs-devel.x86_64 0:1.39-33.el5 set to be updated
---> Package keyutils-libs.i386 0:1.2-1.el5 set to be updated
---> Package keyutils-libs-devel.x86_64 0:1.2-1.el5 set to be updated
---> Package libselinux-devel.x86_64 0:1.33.4-5.7.el5 set to be updated
--> Processing Dependency: libsepol-devel >= 1.15.2-1 for package: libselinux-devel
--> Running transaction check
---> Package libsepol-devel.x86_64 0:1.15.2-3.el5 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
mysql i386 5.0.77-4.el5_6.6 base 4.8 M
mysql x86_64 5.0.77-4.el5_6.6 base 4.8 M
mysql-devel i386 5.0.77-4.el5_6.6 base 2.4 M
mysql-devel x86_64 5.0.77-4.el5_6.6 base 2.5 M
mysql-server x86_64 5.0.77-4.el5_6.6 base 9.8 M
Installing for dependencies:
e2fsprogs-devel x86_64 1.39-33.el5 base 637 k
keyutils-libs i386 1.2-1.el5 base 18 k
keyutils-libs-devel x86_64 1.2-1.el5 base 27 k
krb5-devel x86_64 1.6.1-62.el5 base 1.9 M
krb5-libs i386 1.6.1-62.el5 base 668 k
libselinux-devel x86_64 1.33.4-5.7.el5 base 149 k
libsepol-devel x86_64 1.15.2-3.el5 base 192 k
openssl i686 0.9.8e-20.el5 base 1.4 M
openssl-devel x86_64 0.9.8e-20.el5 base 1.9 M
Transaction Summary
========================================================================================================================================================================
Install 14 Package(s)
Upgrade 0 Package(s)
Total size: 31 M
Total download size: 15 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): mysql-5.0.77-4.el5_6.6.x86_64.rpm | 4.8 MB 00:00
(2/2): mysql-server-5.0.77-4.el5_6.6.x86_64.rpm | 9.8 MB 00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 10 MB/s | 15 MB 00:01
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Check Error:
file /etc/pki/tls/certs/ca-bundle.crt from install of openssl-0.9.8e-20.el5.i686 conflicts with file from package openssl-0.9.8e-12.el5_5.7.x86_64
file /usr/share/man/man1/ca.1ssl.gz from install of openssl-0.9.8e-20.el5.i686 conflicts with file from package openssl-0.9.8e-12.el5_5.7.x86_64
file /usr/share/man/man1/req.1ssl.gz from install of openssl-0.9.8e-20.el5.i686 conflicts with file from package openssl-0.9.8e-12.el5_5.7.x86_64
file /usr/share/man/man1/x509.1ssl.gz from install of openssl-0.9.8e-20.el5.i686 conflicts with file from package openssl-0.9.8e-12.el5_5.7.x86_64
Error Summary
-------------
最后更新
# yum remove openssl-0.9.8e-20.el5.i686
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: openssl-0.9.8e-20.el5.i686
Loading mirror speeds from cached hostfile
* base: mirrors.serveraxis.net
* epel: mirror.steadfast.net
* extras: mirror.wiredtree.com
* updates: mirror.ubiquityservers.com
Package(s) openssl-0.9.8e-20.el5.i686 available, but not installed.
No Packages marked for removal
答案1
Package mysql is obsoleted by MySQL-server, trying to install MySQL-server-5.1.48-1.glibc23.x86_64 instead
Package MySQL-server-5.1.48-1.glibc23.x86_64 already installed and latest version
看起来您是MySQL-server
从主页下载了软件包并使用 进行安装的rpm -ivh
。使用以下命令进行验证:
$ rpm -qa | grep MySQL
如果您想要mysql-server
从存储库(base、epel 等)安装,则必须MySQL-server
通过执行以下操作来卸载第一个:
# yum remove MySQL-*
进而:
# yum install mysql mysql-server mysql-devel
MySQL-server
包中的初始化脚本是mysql
而不是mysqld
from mysql-server
。提示是输入一些字符 ( /etc/init.d/mys
) 然后按Tab或TabTab。
答案2
您可能已经从 rpm 手动安装了 MySQL-devel 和 MySQL-server,并且阻止您安装 mysql。
最好删除这些包
#yum remove MySQL-devel MySQL-server
然后再次安装
#yum install mysql mysql-server mysql-devel
另请发布上述两个命令的输出,这将有助于我们帮助您。
编辑
智能文件存储库..尝试禁用它?
#yum --disablerepo=smartfile
答案3
您可以通过运行以下命令启动 MySQL 服务器:
# /etc/init.d/mysql start
通常,MySQL-client 位于mysql
os-repository 中命名的包中:
# yum install mysql
但由于您的情况并非如此,我怀疑您可能安装了不同的软件包。
你能试一下吗:
# yum whatprovides '/usr/bin/mysql'
它应该给你提供提供 MySQL 客户端的软件包列表。
答案4
首先删除已有的内容:
yum remove mysql-server
yum remove mysql
然后安装:
yum install mysql-server
yum install mysql
yum install mysql-devel
service mysqld start