我用的是 Ubuntu 10.04 64位, 源里面的版本有点老... 源里面是 MySQL 5.1, 看到 MySQL 5.5 后就把他卸载了. 第一次下载的是 mysql-5.5.22-debian6.0-x86_64.deb, 安装后不行, 删除所有文件, 下载源码编译安装, 也不行. 之后再安装源里面的 MySQL 5.1 也不行了. 主要错误是: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
今天又使用 mysql-5.5.22-debian6.0-x86_64.deb 安装了一下, 还是不行, 下面是主要错误: =========root@cnfn:/opt/mysql/server-5.5# ./scripts/mysql_install_db --user=mysql Installing MySQL system tables... 120330 21:30:51 [ERROR] /opt/mysql/server-5.5/bin/mysqld: unknown option '--skip-locking' 120330 21:30:51 [ERROR] Aborting 120330 21:30:51 [Note] /opt/mysql/server-5.5/bin/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /opt/mysql/server-5.5/data for more information. =========root@cnfn:/opt/mysql/server-5.5# ./support-files/mysql.server start Starting MySQL.. * The server quit without updating PID file (/opt/mysql/server-5.5/data/cnfn.pid) =========root@cnfn:/opt/mysql/server-5.5# cat data/cnfn.err 120330 21:35:53 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/server-5.5/data 120330 21:35:53 [Note] Plugin 'FEDERATED' is disabled. /opt/mysql/server-5.5/bin/mysqld: Table 'mysql.plugin' doesn't exist 120330 21:35:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120330 21:35:53 InnoDB: The InnoDB memory heap is disabled 120330 21:35:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120330 21:35:53 InnoDB: Compressed tables use zlib 1.2.3 120330 21:35:53 InnoDB: Using Linux native AIO 120330 21:35:53 InnoDB: Initializing buffer pool, size = 128.0M 120330 21:35:53 InnoDB: Completed initialization of buffer pool 120330 21:35:53 InnoDB: highest supported file format is Barracuda. 120330 21:35:53 InnoDB: Waiting for the background threads to start 120330 21:35:54 InnoDB: 1.1.8 started; log sequence number 1595675 120330 21:35:54 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 120330 21:35:54 mysqld_safe mysqld from pid file /opt/mysql/server-5.5/data/cnfn.pid ended =========root@cnfn:/opt/mysql/server-5.5# ./bin/mysql_upgrade Looking for 'mysql' as: ./bin/mysql Looking for 'mysqlcheck' as: ./bin/mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock' ./bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed =========root@cnfn:/opt/mysql/server-5.5# ./bin/mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) 彻底丧失希望了, 下一步的打算是利用这个假期把数据备份一下, 重新分区, 移除 win7, 使 Ubuntu 占主导地位. 之后先在虚拟机中安装 MySQL 5.5, 测试是否可以成功. 如果不成功, 那就只能用源里面的 MySQL 5.1 了. ------------------ Original ------------------ From: "hooxin firefoxmmx"<firefox...@gmail.com>; Date: Fri, Mar 30, 2012 09:31 PM To: "ubuntu-zh mailing lists"<ubuntu-zh@lists.ubuntu.com>; Subject: Re: [Ubuntu-zh]Ubuntu有没有mysql的5.5的版本呢?谁安装过,给点指导啊。 不能通过apt安装吗? 在 2012年3月30日 下午6:56,resky <ldfre...@yeah.net>写道: > 我们不讨论能不能用只是说如何安装mysql5.5 > > 于 2012/3/29 23:38, Ruxiao Ma 写道: > > 装源里面的用不了? >> >> 2012/3/29 resky<ldfre...@yeah.net> >> >> 是压根就不会啊。。。****有debian的deb包但是所有的包都是mysql5.5 >>> linux2.6。。。。。自己的都被升级成linux3.****0了。。(应该不会有所谓的兼容性 >>> 问题。毕竟开源的嘛) 找到源码包了 是cmake编译版本。。。正在研究。。 >>> >>> 于 2012/3/29 22:35, Ruxiao Ma 写道: >>> >>> 我们的服务器现在还是 10.04 LTS,所以没有 5.5 的包。不过,在有 mysql 5.5 的发行版中应该有一个包叫 >>>> mysql-server-5.5,那个就是安装 mysql 5.5 服务器组件的。 >>>> 先后顺序:mysql-server-5.5 里面包含 mysql-server-core-5.5,****所以应该不存在顺序问题。 >>>> >>>> mysql.com 里面怎可能没有 deb 包?平台是不是选错了?(****我感觉还是从发行版自己的源里面安装比较好)另,**** >>>> 一般情况下不需要软件包的 >>>> src >>>> 的。。。除非你要自己编译有特殊需求的版本。 >>>> >>>> 如果安装失败,想求助于列表的话,不妨把错误信息等都发上来,****让大家都看一看。 >>>> >>>> 2012/3/29 Cnfn<c...@cnfn.org> >>>> >>>> 折腾了好几个小时了, 均以失败告终, 网上的资料大多是复制别人的... >>>> >>>>> 按照官方给的安装说明操作也不行.... >>>>> 可能是我在删除 MySQL 5.1 的时候删除的东西过多了吧.... >>>>> >>>>> >>>>> ------------------ Original ------------------ >>>>> From: "resky"<ldfre...@yeah.net>; >>>>> Date: Thu, Mar 29, 2012 08:38 PM >>>>> To: "ubuntu-zh"<ubuntu-zh@lists.****ubuntu.com <http://ubuntu.com>< >>>>> ubuntu-zh@lists.**ubuntu.com <ubuntu-zh@lists.ubuntu.com>> >>>>> >>>>>> ; >>>>>> >>>>> Subject: [Ubuntu-zh] Ubuntu有没有mysql的5.5的版本呢?谁安装过,****给点指导啊。 >>>>> >>>>> 如题,求指导。 >>>>> >>>>> >>>>> -- >>>>> ubuntu-zh mailing list >>>>> ubuntu-zh@lists.ubuntu.com >>>>> https://lists.ubuntu.com/****mailman/listinfo/ubuntu-zh<https://lists.ubuntu.com/**mailman/listinfo/ubuntu-zh> >>>>> <htt**ps://lists.ubuntu.com/mailman/**listinfo/ubuntu-zh<https://lists.ubuntu.com/mailman/listinfo/ubuntu-zh> >>>>> > >>>>> -- >>>>> ubuntu-zh mailing list >>>>> ubuntu-zh@lists.ubuntu.com >>>>> https://lists.ubuntu.com/****mailman/listinfo/ubuntu-zh<https://lists.ubuntu.com/**mailman/listinfo/ubuntu-zh> >>>>> <htt**ps://lists.ubuntu.com/mailman/**listinfo/ubuntu-zh<https://lists.ubuntu.com/mailman/listinfo/ubuntu-zh> >>>>> > >>>>> >>>>> -------------- 下一部分 -------------- >>>>> >>>> 一个HTML附件被移除... >>>> URL:<https://lists.ubuntu.com/****archives/ubuntu-zh/**<https://lists.ubuntu.com/**archives/ubuntu-zh/**> >>>> attachments/20120329/7f1f9c47/****attachment.html<https://** >>>> lists.ubuntu.com/archives/**ubuntu-zh/attachments/** >>>> 20120329/7f1f9c47/attachment.**html<https://lists.ubuntu.com/archives/ubuntu-zh/attachments/20120329/7f1f9c47/attachment.html> >>>> > >>>> >>> >>> >>> -- >>> ubuntu-zh mailing list >>> ubuntu-zh@lists.ubuntu.com >>> https://lists.ubuntu.com/****mailman/listinfo/ubuntu-zh<https://lists.ubuntu.com/**mailman/listinfo/ubuntu-zh> >>> <htt**ps://lists.ubuntu.com/mailman/**listinfo/ubuntu-zh<https://lists.ubuntu.com/mailman/listinfo/ubuntu-zh> >>> > >>> >>> -------------- 下一部分 -------------- >> 一个HTML附件被移除... >> URL:<https://lists.ubuntu.com/**archives/ubuntu-zh/** >> attachments/20120329/056c36a8/**attachment.html<https://lists.ubuntu.com/archives/ubuntu-zh/attachments/20120329/056c36a8/attachment.html> >> > >> > > > > -- > ubuntu-zh mailing list > ubuntu-zh@lists.ubuntu.com > https://lists.ubuntu.com/**mailman/listinfo/ubuntu-zh<https://lists.ubuntu.com/mailman/listinfo/ubuntu-zh> > -------------- 下一部分 -------------- 一个HTML附件被移除... URL: <https://lists.ubuntu.com/archives/ubuntu-zh/attachments/20120330/2a7f9a78/attachment.html> -- ubuntu-zh mailing list ubuntu-zh@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-zh -- ubuntu-zh mailing list ubuntu-zh@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-zh