个人工具
登录
查看“UbuntuHelp:MYSQL5FromSource”的源代码 - Ubuntu中文
UbuntuHelp
讨论
查看源代码
历史
搜索
导航
首页
最近更改
随机页面
页面分类
帮助
编辑
编辑指南
沙盒
新闻动态
字词处理
工具
链入页面
相关更改
特殊页面
页面信息
查看“UbuntuHelp:MYSQL5FromSource”的源代码
来自Ubuntu中文
←
UbuntuHelp:MYSQL5FromSource
跳转至:
导航
,
搜索
因为以下原因,你没有权限编辑本页:
您所请求的操作仅限于该用户组的用户使用:
用户
您可以查看与复制此页面的源代码。
{{From|https://help.ubuntu.com/community/MYSQL5FromSource}} {{Languages|UbuntuHelp:MYSQL5FromSource}} Please discuss in [http://www.ubuntuforums.org/showthread.php?t=93725&page=1&pp=10 this thread on Ubuntu forums]. Tested in Breezy. Mysql5.0 is already in Dapper. It is in main. It is installed when you install the default LAMP stack in Dapper. === Prerequisites === ==== You must download MYSQL5 (of course ;) ==== <pre><nowiki> wget http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.16.tar.gz/from/http://mysql.localhost.net.ar/ tar xzvf mysql-5.0.16.tar.gz cd mysql-5.0.16/ </nowiki></pre> ==== You must install packages : ==== <pre><nowiki> sudo apt-get install build-essential </nowiki></pre> ==== You need development libraries ==== ... but I'm not sure about which ones. <pre><nowiki> sudo apt-get install libncurses5 libncurses5-dev </nowiki></pre> ...or you won't be able to compile on a server install ==== You need to create the user and group ==== <pre><nowiki> sudo groupadd mysql sudo useradd -g mysql mysql </nowiki></pre> === Compilation optimisation === You can speed up Mysql with processor optimisation If you have a different processor, change the CHOST, CFLAGS, CXXFLAGS. If you don't know what it is, Take the Generic one! https://help.ubuntu.com/community/IconsPage?action=AttachFile&do=get&target=IconWarning3.png The configuration for specific processors were not tested. If it compiles you're fine. If it doesn't try the generic one. Use only one of the following three * Athlon-tbird XP (AMD) <pre><nowiki> export CHOST="i686-pc-linux-gnu" export CFLAGS="-march=athlon-xp -O3 -pipe -fomit-frame-pointer -msse -mmmx -mfpmath=sse" export CXXFLAGS="-march=athlon-xp -O3 -pipe -fomit-frame-pointer -msse -mmmx -mfpmath=sse -felide-constructors -fno-exceptions -fno-rtti" export CXX=gcc </nowiki></pre> * Pentium 4 (Intel) <pre><nowiki> export CHOST="i686-pc-linux-gnu" export CFLAGS="-march=pentium4 -mcpu=pentium4 -O3 -pipe -fomit-frame-pointer -msse -mmmx -mfpmath=sse" export CXXFLAGS="-march=pentium4 -mcpu=pentium4 -O3 -pipe -fomit-frame-pointer -msse -mmmx -mfpmath=sse -felide-constructors -fno-exceptions -fno-rtti" export CXX=gcc </nowiki></pre> * Generic <pre><nowiki> export CHOST="i686-pc-linux-gnu" export CFLAGS="-mcpu=i686 -march=i686 -O3 -pipe -fomit-frame-pointer" export CXX=gcc </nowiki></pre> <code><nowiki>-fomit-frame-pointer</nowiki></code> should be omitted if you intend to debug. Otherwise leave it as it make mysql faster. === Configuration === This is a full configuration. Do it in the MYSQL5 folder. You can add/delete some of the options if you don't need it. This is intended to be a default mysql5 installation, again I'm not sure about this. <pre><nowiki> ./configure \ --prefix=/usr/local/mysql \ --with-mysqld-user=mysql \ --without-debug \ --with-client-ldflags=-all-static \ --with-mysqld-ldflags=-all-static \ --disable-shared \ --localstatedir=/usr/local/mysql/data \ --with-extra-charsets=none \ --enable-assembler \ --with-unix-socket-path=/tmp/mysql.socket make sudo make install </nowiki></pre> This will install mysql in <code><nowiki>/usr/local/mysql</nowiki></code> and data in <code><nowiki>/usr/local/mysql/data</nowiki></code>. ==== my.conf ==== Now create the conf based in any of the pre-build confs. For small servers I recommend my-medium.cnf <pre><nowiki> sudo cp support-files/my-medium.cnf /etc/my.cnf </nowiki></pre> You should edit this file for your needs. ==== Create GRANT tables ==== You must create the GRANT tables, and there is a very easy way to do so. <pre><nowiki> sudo /usr/local/mysql/bin/mysql_install_db --user=mysql </nowiki></pre> ==== Changing Owners ==== <pre><nowiki> sudo chown -R root /usr/local/mysql sudo chown -R mysql /usr/local/mysql/var sudo chgrp -R mysql /usr/local/mysql </nowiki></pre> === Testing === Start the server <pre><nowiki> /usr/local/mysql/bin/mysqld_safe -user=mysql& </nowiki></pre> Set a root password for MySQL (does not affect system root's password) <pre><nowiki> /usr/local/mysql/bin/mysqladmin -u root password new_password </nowiki></pre> Try to log in! <pre><nowiki> /usr/local/mysql/bin/mysql </nowiki></pre> You should add <code><nowiki>/usr/local/mysql/bin</nowiki></code> to your path so you can always use mysql, mysqldump, mysqladmin and some others right from the shell. === Starting Mysql at boot time === <pre><nowiki> sudo cp support-files/mysql.server /etc/init.d/mysql sudo chmod +x /etc/init.d/mysql sudo update-rc.d mysql defaults </nowiki></pre> When you restart mysql should be up if everything went ok. === MySQL Tools === * MySQL Administrator. MySQL Administrator is a powerful visual administration tool that makes it easy to administer and monitor your MySQL environment and gain significantly better visibility into how your databases are operating. More information at http://www.mysql.com/products/tools/administrator/ # To use install: <pre><nowiki> mysql-admin </nowiki></pre> * phpmyadmin. A tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 50 languages. More information at http://www.phpmyadmin.net # To use install: <pre><nowiki> phpmyadmin </nowiki></pre> [[category:CategoryDocumentation]] [[category:CategoryCleanup]] [[category:UbuntuHelp]]
该页面使用的模板:
模板:From
(
查看源代码
)
模板:Languages
(
查看源代码
)(受保护)
模板:Languages/Lang
(
查看源代码
)(受保护)
返回至
UbuntuHelp:MYSQL5FromSource
。