啥，跟升级系统啥关系？ On Mar 30, 2012, at 9:50 PM, hooxin firefoxmmx wrote:
> 你考虑升级系统吗？ 或者找别的专门的MYSQL DEB源。 > > 在 2012年3月31日 上午2:47，OxFAN <odayf...@gmail.com>写道： > >> 官方有专门的源： >> http://forums.mysql.com/read.php?154,401279,401279 >> >> >> 2012/3/30 Cnfn <c...@cnfn.org> >> >>> 我用的是 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 >>> >> -------------- 下一部分 -------------- >> 一个HTML附件被移除... >> URL: < >> https://lists.ubuntu.com/archives/ubuntu-zh/attachments/20120330/2847f1ec/attachment.html >>> >> -- >> ubuntu-zh mailing list >> ubuntu-zh@lists.ubuntu.com >> https://lists.ubuntu.com/mailman/listinfo/ubuntu-zh >> > -------------- 下一部分 -------------- > 一个HTML附件被移除... > URL: > <https://lists.ubuntu.com/archives/ubuntu-zh/attachments/20120331/ce847400/attachment.html> > -- > ubuntu-zh mailing list > ubuntu-zh@lists.ubuntu.com > https://lists.ubuntu.com/mailman/listinfo/ubuntu-zh -------------- 下一部分 -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 235 bytes Desc: Message signed with OpenPGP using GPGMail URL: <https://lists.ubuntu.com/archives/ubuntu-zh/attachments/20120330/8045937d/attachment.pgp> -- ubuntu-zh mailing list ubuntu-zh@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-zh
