湖濱散記部落格的樹心幽徑[<a href=login.php>login</a>][<a href= . >主頁</a>]<hr>
297:20140916在fedora19裝妥mysql5.0.27資料庫伺服程式<br><table width=800 border=8><tr><td bgcolor=cyan><p>(1)<br />[root@blackbear lnx]# tar xvzf mysql-5.0.27.tar.gz<br />[root@blackbear mysql-5.0.27]# ls<br />aclocal.m4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dbug&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ltmain.sh&nbsp;&nbsp;&nbsp; regex<br />bdb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; depcomp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Makefile.am&nbsp; scripts<br />BUILD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Docs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Makefile.in&nbsp; server-tools<br />ChangeLog&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXCEPTIONS-CLIENT&nbsp;&nbsp; man&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sql<br />client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; extra&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; missing&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sql-bench<br />CMakeLists.txt&nbsp; heap&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; myisam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sql-common<br />cmd-line-utils&nbsp; include&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; myisammrg&nbsp;&nbsp;&nbsp; SSL<br />config&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; innobase&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mysql-test&nbsp;&nbsp; strings<br />config.guess&nbsp;&nbsp;&nbsp; install-sh&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mysys&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; support-files<br />config.h.in&nbsp;&nbsp;&nbsp;&nbsp; INSTALL-SOURCE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ndb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tests<br />config.sub&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INSTALL-WIN-SOURCE&nbsp; netware&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tools<br />configure&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; libmysql&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; os2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vio<br />configure.in&nbsp;&nbsp;&nbsp; libmysqld&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pstack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; win<br />COPYING&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; libmysql_r&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; README&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; zlib<br /><br />(2)<br />[root@blackbear mysql-5.0.27]# cat INSTALL-SOURCE |more<br />:<br /><br />&nbsp; 1. Add a login user and group for `mysqld' to run as:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; groupadd mysql<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; useradd -g mysql mysql<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; These commands add the `mysql' group and the `mysql' user. The<br />&nbsp;&nbsp;&nbsp;&nbsp; syntax for `useradd' and `groupadd' may differ slightly on<br />&nbsp;&nbsp;&nbsp;&nbsp; different versions of Unix, or they may have different names such<br />&nbsp;&nbsp;&nbsp;&nbsp; as `adduser' and `addgroup'.<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; You might want to call the user and group something else instead<br />&nbsp;&nbsp;&nbsp;&nbsp; of `mysql'. If so, substitute the appropriate name in the<br />&nbsp;&nbsp;&nbsp;&nbsp; following steps.<br /><br />&nbsp; 2. Pick the directory under which you want to unpack the distribution<br />&nbsp;&nbsp;&nbsp;&nbsp; and change location into it.<br /><br />&nbsp; 3. Obtain a distribution file using the instructions in *Note<br />&nbsp;&nbsp;&nbsp;&nbsp; getting-mysql::.<br /><br />&nbsp; 4. Unpack the distribution into the current directory:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; gunzip &lt; /PATH/TO/MYSQL-VERSION.tar.gz | tar xvf -<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; This command creates a directory named `mysql-VERSION'.<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; With GNU `tar', no separate invocation of `gunzip' is necessary.<br />&nbsp;&nbsp;&nbsp;&nbsp; You can use the following alternative command to uncompress and<br />&nbsp;&nbsp;&nbsp;&nbsp; extract the distribution:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; tar zxvf /PATH/TO/MYSQL-VERSION-OS.tar.gz<br /><br />&nbsp; 5. Change location into the top-level directory of the unpacked<br />&nbsp;&nbsp;&nbsp;&nbsp; distribution:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; cd mysql-VERSION<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; Note that currently you must configure and build MySQL from this<br />&nbsp;&nbsp;&nbsp;&nbsp; top-level directory. You cannot build it in a different directory.<br /><br />&nbsp; 6. Configure the release and compile everything:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; ./configure --prefix=/usr/local/mysql<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; make<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; When you run `configure', you might want to specify other options.<br />&nbsp;&nbsp;&nbsp;&nbsp; Run `./configure --help' for a list of options.&nbsp; *Note<br />&nbsp;&nbsp;&nbsp;&nbsp; configure-options::, discusses some of the more useful options.<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; If `configure' fails and you are going to send mail to a MySQL<br />&nbsp;&nbsp;&nbsp;&nbsp; mailing list to ask for assistance, please include any lines from<br />&nbsp;&nbsp;&nbsp;&nbsp; `config.log' that you think can help solve the problem. Also<br />&nbsp;&nbsp;&nbsp;&nbsp; include the last couple of lines of output from `configure'. To<br />&nbsp;&nbsp;&nbsp;&nbsp; file a bug report, please use the instructions in *Note<br />&nbsp;&nbsp;&nbsp;&nbsp; bug-reports::.<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; If the compile fails, see *Note compilation-problems::, for help.<br /><br />&nbsp; 7. Install the distribution:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; make install<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; If you want to set up an option file, use one of those present in<br />&nbsp;&nbsp;&nbsp;&nbsp; the `support-files' directory as a template. For example:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; cp support-files/my-medium.cnf /etc/my.cnf<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; You might need to run these commands as `root'.<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; If you want to configure support for `InnoDB' tables, you should<br />&nbsp;&nbsp;&nbsp;&nbsp; edit the `/etc/my.cnf' file, remove the `#' character before the<br />&nbsp;&nbsp;&nbsp;&nbsp; option lines that start with `innodb_...', and modify the option<br />&nbsp;&nbsp;&nbsp;&nbsp; values to be what you want. See *Note option-files::, and *Note<br />&nbsp;&nbsp;&nbsp;&nbsp; innodb-configuration::.<br /><br />&nbsp; 8. Change location into the installation directory:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; cd /usr/local/mysql<br /><br />&nbsp; 9. If you haven't installed MySQL before, you must create the MySQL<br />&nbsp;&nbsp;&nbsp;&nbsp; grant tables:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; bin/mysql_install_db --user=mysql<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; If you run the command as `root', you should use the `--user'<br />&nbsp;&nbsp;&nbsp;&nbsp; option as shown. The value of the option should be the name of the<br />&nbsp;&nbsp;&nbsp;&nbsp; login account that you created in the first step to use for<br />&nbsp;&nbsp;&nbsp;&nbsp; running the server. If you run the command while logged in as that<br />&nbsp;&nbsp;&nbsp;&nbsp; user, you can omit the `--user' option.<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; After using `mysql_install_db' to create the grant tables for<br />&nbsp;&nbsp;&nbsp;&nbsp; MySQL, you must restart the server manually. The `mysqld_safe'<br />&nbsp;&nbsp;&nbsp;&nbsp; command to do this is shown in a later step.<br /><br />&nbsp;10. Change the ownership of program binaries to `root' and ownership<br />&nbsp;&nbsp;&nbsp;&nbsp; of the data directory to the user that you run `mysqld' as.<br />&nbsp;&nbsp;&nbsp;&nbsp; Assuming that you are located in the installation directory<br />&nbsp;&nbsp;&nbsp;&nbsp; (`/usr/local/mysql'), the commands look like this:<br /><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; chown -R root&nbsp; .<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; chown -R mysql var<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shell&gt; chgrp -R mysql .<br /><br />&nbsp;&nbsp;&nbsp;&nbsp; The first command changes the owner attribute of the files to the<br />&nbsp;&nbsp;&nbsp;&nbsp; `root' user. The second changes the owner attribute of the data<br />&nbsp;&nbsp;&nbsp;&nbsp; directory to the `mysql' user. The third changes the group<br />&nbsp;&nbsp;&nbsp;&nbsp; attribute to the `mysql' group.<br /><br />&nbsp;11. If you want MySQL to start automatically when you boot your<br />&nbsp;&nbsp;&nbsp;&nbsp; machine, you can copy `support-files/mysql.server' to the location<br />&nbsp;&nbsp;&nbsp;&nbsp; where your system has its startup files. More information can be<br />&nbsp;&nbsp;&nbsp;&nbsp; found in the `support-files/mysql.server' script itself; see also<br />&nbsp;&nbsp;&nbsp;&nbsp; *Note automatic-start::.<br /><br />&nbsp;12. You can set up new accounts using the `bin/mysql_setpermission'<br />&nbsp;&nbsp;&nbsp;&nbsp; script if you install the `DBI' and `DBD::mysql' Perl modules. For<br />&nbsp;&nbsp;&nbsp;&nbsp; instructions, see *Note perl-support::.<br />(3)<br />[root@blackbear mysql-5.0.27]# cat /etc/passwd|grep mysql<br />[root@blackbear mysql-5.0.27]# groupadd mysql<br />[root@blackbear mysql-5.0.27]# useradd -g mysql mysql<br />[root@blackbear mysql-5.0.27]#<br />(4)<br />[root@blackbear mysql-5.0.27]#&nbsp; ./configure --prefix=/usr/local/mysql<br />:<br />checking for termcap functions library... configure: error: No curses/termcap library found<br /><br />(5)<br />[root@blackbear mysql-5.0.27]# yum -y install ncurses-devel<br />Loaded plugins: langpacks, refresh-packagekit<br />updates/19/i386/metalink&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 6.3 kB&nbsp; 00:00:00<br />updates&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 4.9 kB&nbsp; 00:00:00<br />updates/19/i386/primary_db&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 9.9 MB&nbsp; 00:00:14<br />Resolving Dependencies<br />--&gt; Running transaction check<br />---&gt; Package ncurses-devel.i686 0:5.9-11.20130511.fc19 will be installed<br />--&gt; Finished Dependency Resolution<br /><br />Dependencies Resolved<br /><br />=============================================================================================================================<br />&nbsp;Package&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Arch&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Repository&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Size<br />=============================================================================================================================<br />Installing:<br />&nbsp;ncurses-devel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i686&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.9-11.20130511.fc19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fedora&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 713 k<br /><br />Transaction Summary<br />=============================================================================================================================<br />Install&nbsp; 1 Package<br /><br />Total download size: 713 k<br />Installed size: 2.1 M<br />Downloading packages:<br />ncurses-devel-5.9-11.20130511.fc19.i686.rpm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 713 kB&nbsp; 00:00:01<br />Running transaction check<br />Running transaction test<br />Transaction test succeeded<br />Running transaction<br />&nbsp; Installing : ncurses-devel-5.9-11.20130511.fc19.i686&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1<br />&nbsp; Verifying&nbsp; : ncurses-devel-5.9-11.20130511.fc19.i686&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1<br /><br />Installed:<br />&nbsp; ncurses-devel.i686 0:5.9-11.20130511.fc19<br /><br />Complete!<br />[root@blackbear mysql-5.0.27]#<br /><br />(6)<br /><br />[root@blackbear mysql-5.0.27]#&nbsp; ./configure --prefix=/usr/local/mysql<br /><br />:<br />Remember to check the platform specific part of the reference manual for<br />hints about installing MySQL on your platform. Also have a look at the<br />files in the Docs directory.<br /><br />Thank you for choosing MySQL!<br /><br />[root@blackbear mysql-5.0.27]#<br /><br />[root@blackbear mysql-5.0.27]# make<br />:<br />make[1]: Leaving directory `/root/lnx/mysql-5.0.27'<br />[root@blackbear mysql-5.0.27]#<br /><br />(7)<br />[root@blackbear mysql-5.0.27]# make install<br />:<br />make[1]: Leaving directory `/root/lnx/mysql-5.0.27'<br />[root@blackbear mysql-5.0.27]#<br /><br />(8)<br />[root@blackbear mysql-5.0.27]# cp support-files/my-medium.cnf /etc/my.cnf<br />[root@blackbear mysql-5.0.27]# stat /etc/my.cnf<br />&nbsp; File: &lsquo;/etc/my.cnf&rsquo;<br />&nbsp; Size: 4912&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Blocks: 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IO Block: 4096&nbsp;&nbsp; 普通檔案<br />Device: fd01h/64769d&nbsp;&nbsp;&nbsp; Inode: 2753106&nbsp;&nbsp;&nbsp;&nbsp; Links: 1<br />Access: (0644/-rw-r--r--)&nbsp; Uid: (&nbsp;&nbsp;&nbsp; 0/&nbsp;&nbsp;&nbsp; root)&nbsp;&nbsp; Gid: (&nbsp;&nbsp;&nbsp; 0/&nbsp;&nbsp;&nbsp; root)<br />Context: unconfined_u:object_r:etc_t:s0<br />Access: 2014-09-16 16:26:44.594312745 +0800<br />Modify: 2014-09-16 16:26:44.594312745 +0800<br />Change: 2014-09-16 16:26:44.594312745 +0800<br />&nbsp;Birth: -<br />[root@blackbear mysql-5.0.27]#<br /><br />(9)<br />[root@blackbear mysql-5.0.27]# cd /usr/local/mysql<br />[root@blackbear mysql]#&nbsp; bin/mysql_install_db --user=mysql<br />Installing all prepared tables<br />Fill help tables<br /><br />To start mysqld at boot time you have to copy support-files/mysql.server<br />to the right place for your system<br /><br />PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !<br />To do so, start the server, then issue the following commands:<br />/usr/local/mysql/bin/mysqladmin -u root password 'new-password'<br />/usr/local/mysql/bin/mysqladmin -u root -h blackbear.kmvs.km.edu.tw password 'new-password'<br />See the manual for more instructions.<br /><br />You can start the MySQL daemon with:<br />cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &amp;<br /><br />You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:<br />cd sql-bench ; perl run-all-tests<br /><br />Please report any problems with the /usr/local/mysql/bin/mysqlbug script!<br /><br />The latest information about MySQL is available on the web at<br />http://www.mysql.com<br />Support MySQL by buying support/licenses at http://shop.mysql.com<br />[root@blackbear mysql]#<br /><br />(10)<br />[root@blackbear mysql]# cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &amp;<br />[1] 31855<br />[root@blackbear mysql]# nohup: ignoring input and redirecting stderr to stdout<br />Starting mysqld daemon with databases from /usr/local/mysql/var<br /><br />[root@blackbear mysql]# ps ax|grep mysql<br />31855 pts/0&nbsp;&nbsp;&nbsp; S&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe<br />31876 pts/0&nbsp;&nbsp;&nbsp; Sl&nbsp;&nbsp;&nbsp;&nbsp; 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/blackbear.kmvs.km.edu.tw.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock<br />31886 pts/0&nbsp;&nbsp;&nbsp; S+&nbsp;&nbsp;&nbsp;&nbsp; 0:00 grep --color=auto mysql<br />[root@blackbear mysql]#<br /><br /><br />(11)<br />[root@blackbear mysql]# /usr/local/mysql/bin/mysqladmin -u root password 'yourpwd'<br />[root@blackbear mysql]# /usr/local/mysql/bin/mysqladmin -u root -h blackbear.kmvs.km.edu.tw password 'yourpwd'<br />[root@blackbear mysql]#<br /><br />(12)<br />[root@blackbear mysql]# chown -R root&nbsp; .<br />[root@blackbear mysql]# chown -R mysql var<br />[root@blackbear mysql]# chgrp -R mysql .<br />[root@blackbear mysql]#<br />[root@blackbear mysql]# cp bin/mysql /usr/local/bin<br />setup success <br /><br /></p></table><br> select id,article_id,topic,text from lt_articles_text where article_id =297; ok.
update lt_articles set num_reads=num_reads +1 where id=297; ok.