当前位置:七道奇文章资讯数据防范MySQL防范
日期:2011-01-25 22:43:00  来源:本站整理

<b>linux 下 MySQL源码包的安装</b>[MySQL防范]

赞助商链接



  本文“<b>linux 下 MySQL源码包的安装</b>[MySQL防范]”是由七道奇为您精心收集,来源于网络转载,文章版权归文章作者所有,本站不对其观点以及内容做任何评价,请读者自行判断,以下是其具体内容:

    linux 下 MySQL源码包的安装
    实行环境 VMware 6.5.2 +redhatEnterprise 5 AS
    实行目的 初步触及源码包的安装,以简单实现其功效为目的,不对原理举行深层谈论
    内核版本:


    本日尝试安装MySQL的源码包 mysql-4.0.27.tar.gz
    下载源码包 copy 到linux
    [root@localhost ~]# cd /tmp
    [root@localhost tmp]# ls
    gconfd-laowu scim-helper-manager-socket-root
    gconfd-root scim-panel-socket:0-laowu
    keyring-8zb2FJ scim-panel-socket:0-root
    linuxqq_v1.0.2-beta1_i386 scim-socket-frontend-root
    linuxqq_v1.0.2-beta1_i386.tar.gz sealert.log
    mapping-laowu ssh-lgCAZY2854
    mapping-root virtual-root.Kez8K1
    mysql-4.0.27.tar.gz VMwareDnD
    orbit-root vmware-root
    scim-bridge-0.3.0.lockfile-0@localhost:0.0 VMwareTools-7.8.4-126130.tar.gz
    scim-bridge-0.3.0.socket-0@localhost:0.0 vmware-tools-distrib
    [root@localhost tmp]#
    [root@localhost tmp]# tar zxvf mysql-4.0.27.tar.gz
    把源码包mysql-4.0.27.tar.gz 解压到当前目录


    [root@localhost tmp]# cd mysql-4.0.27
    进入mysql-4.0.27目录
    [root@localhost mysql-4.0.27]# ls
    acconfig.h configure.in INSTALL-SOURCE missing regex
    acinclude.m4 COPYING isam mkinstalldirs scripts
    aclocal.m4 dbug libmysql myisam sql
    bdb depcomp libmysqld myisammrg sql-bench
    BUILD Docs libmysql_r mysql-test strings
    ChangeLog EXCEPTIONS-CLIENT ltconfig mysys support-files
    client extra ltmain.sh netware tests
    config.guess heap Makefile.am os2 tools
    config.h.in include Makefile.in pstack vio
    config.sub innobase man readline
    configure install-sh merge README
    [root@localhost mysql-4.0.27]#
    INSTALL-SOURCE这里面有你需求的安装号令
    增添mysql用户组
    [root@localhost mysql-4.0.27]# groupadd mysql
    You have mail in /var/spool/mail/root
    增添mysql用户 并指定到mysql组中
    [root@localhost mysql-4.0.27]# useradd -g mysql mysql
    [root@localhost mysql-4.0.27]#
    [root@localhost mysql-4.0.27]# echo "/* Linuxthreads */" >> /usr/include/pthread.h
    你也可以直接运行下面这条号令直接履行编译预备,假若有错误,试试上面得阴影部份号令
    [root@localhost mysql-4.0.27]# ./configure --prefix=/usr/local/mysql
    编译前的预备,指定安装目录到/usr/local/mysql
    试计算机性能差别,时间略有差别


    [root@localhost mysql-4.0.27]# make
    编译历程


    [root@localhost mysql-4.0.27]# make install
    编译安装 稍等
   


    [root@localhost mysql-4.0.27]# cp support-files/my-medium.cnf /etc/my.cnf
    复制mysql配置文件
    [root@localhost mysql-4.0.27]# cd /usr/local/mysql
    进入安装目录
    [root@localhost mysql]# bin/mysql_install_db --user=mysql
    利用mysql用户 初始化数据库
    Preparing db table
    Preparing host table
    Preparing user table
    Preparing func table
    Preparing tables_priv table
    Preparing columns_priv table
    Installing all prepared tables
    090501 15:30:45 /usr/local/mysql/libexec/mysqld: Shutdown Complete
    To start mysqld at boot time you have to copy support-files/mysql.server
    to the right place for your system
    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
    To do so, start the server, then issue the following commands:
    /usr/local/mysql/bin/mysqladmin -u root password 'new-password'
    /usr/local/mysql/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
    See the manual for more instructions.
    You can start the MySQL daemon with:
    cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &
    You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
    cd sql-bench ; perl run-all-tests
    Please report any problems with the /usr/local/mysql/bin/mysqlbug script!
    The latest information about MySQL is available on the web at
    http://www.mysql.com
    Support MySQL by buying support/licenses at http://shop.mysql.com
    [root@localhost mysql]#
    [root@localhost mysql]# chown -R root .
    改变当前目录的全部属主为root
    -R 为递归(即其下全部的子文件的属主也随之改成root)
    [root@localhost mysql]# chown -R mysql var
    改变var的属主为mysql
    [root@localhost mysql]# chgrp -R mysql .
    改变当前目录的属组为mysql
    [root@localhost mysql]#
    [root@localhost mysql]# bin/mysqld_safe --user=mysql &
    后台启动mysql服务 &为后台启动
    [1] 17776
    [root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
    [root@localhost mysql]#
    [root@localhost mysql]# /usr/local/mysql/bin/mysql
    登陆到mysql数据库
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 1 to server version: 4.0.27-log
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    mysql>
    mysql> show databases ;
    基本的查看数据库号令
    +----------+
    | Database |
    +----------+
    | mysql |
    | test |
    +----------+
    2 rows in set (0.00 sec)
    mysql>
    mysql> ?
    查询号令
    For the complete MySQL Manual online visit:
    http://www.mysql.com/documentation
    For info on technical support from MySQL developers visit:
    http://www.mysql.com/support
    For info on MySQL books, utilities, consultants, etc. visit:
    http://www.mysql.com/portal
    List of all MySQL commands:
    (Commands must appear first on line and end with ';')
    help (\h) Display this help.
    ? (\?) Synonym for `help'.
    clear (\c) Clear command.
    connect (\r) Reconnect to the server. Optional arguments are db and host.
    edit (\e) Edit command with $EDITOR.
    ego (\G) Send command to mysql server, display result vertically.
    exit (\q) Exit mysql. Same as quit.
    go (\g) Send command to mysql server.
    nopager (\n) Disable pager, print to stdout.
    notee (\t) Don't write into outfile.
    pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
    print (\p) Print current command.
    prompt (\R) Change your mysql prompt.
    quit (\q) Quit mysql.
    rehash (\#) Rebuild completion hash.
    source (\.) Execute a SQL script file. Takes a file name as an argument.
    status (\s) Get status information from the server.
    system (\!) Execute a system shell command.
    tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
    use (\u) Use another database. Takes database name as argument.
    Connection id: 2 (Can be used with mysqladmin kill)
    mysql> quit
    Bye
    [root@localhost mysql]#
    退出数据库

    以上是“<b>linux 下 MySQL源码包的安装</b>[MySQL防范]”的内容,如果你对以上该文章内容感兴趣,你可以看看七道奇为您推荐以下文章:

  • <b>hosts是什么 hosts文件在什么位置 若何改正hosts</b>
  • <b>在 Windows 8 中手动安装语言包</b>
  • <b>五个常见 PHP数据库问题</b>
  • Windows中Alt键的12个高效快速的利用本领介绍
  • <b>MySQL ORDER BY 的实现解析</b>
  • <b>详解MySQL存储历程参数有三种范例(in、out、inout)</b>
  • <b>Win8系统恢复出来经典的开始菜单的办法</b>
  • <b>Win8系统花屏怎么办 Win8系统花屏的办理办法</b>
  • <b>Windows 7系统下无线网卡安装</b>
  • <b>为什么 Linux不需求碎片整理</b>
  • <b>Windows 8中删除账户的几种办法(图)</b>
  • <b>教你如安在win7下配置路由器</b>
  • 本文地址: 与您的QQ/BBS好友分享!
    • 好的评价 如果您觉得此文章好,就请您
        0%(0)
    • 差的评价 如果您觉得此文章差,就请您
        0%(0)

    文章评论评论内容只代表网友观点,与本站立场无关!

       评论摘要(共 0 条,得分 0 分,平均 0 分) 查看完整评论
    Copyright © 2020-2022 www.xiamiku.com. All Rights Reserved .