Results 1 to 16 of 16
  1. #1
    Join Date
    Mar 2006
    Location
    Argentine
    Posts
    19

    HowTo: Install MySQL

    Hello,

    In order to install MySQL in your dedicated server or VPS Linux, you must follow the following instructions.

    It unloads completes stable version of MySQL with wget.

    - Type: tar zxvf mysql-3.23.56.tar.gz
    - Type: cd mysql-3.23.56
    - Type: mkdir /usr/local/mysql
    - Type: make clean
    - Type: ./configure --prefix=/usr/local/mysql
    - Type: make
    - Type: make install
    - Type: useradd -g root mysql
    - Type: /usr/local/mysql/bin/mysql_install_db
    - Type: chown -R mysql /usr/local/mysql/var
    - Type: /usr/local/mysql/bin/safe_mysqld &
    - Type: /usr/local/mysql/bin/mysqladmin -u root password 'new-password'
    - Type: /usr/local/mysql/bin/mysqladmin -u root -p -h localhost password 'new-password'

    Thanks,

  2. #2
    Just in case MySQL isn't preinstalled on my VPS (when I get it) I want to thank you for posting this guide, as a newbie to this level of web administration this could well save what hair I have let, THANK YOU

  3. #3
    yes but what about mysql 4 or 4.1 or even 5 you only detail mysql 3.23. it should be the same with the newer mysqls. correct me if im wrong.

  4. #4
    Join Date
    Mar 2006
    Location
    Argentine
    Posts
    19
    Quote Originally Posted by Rebel007
    Just in case MySQL isn't preinstalled on my VPS (when I get it) I want to thank you for posting this guide, as a newbie to this level of web administration this could well save what hair I have let, THANK YOU

    I am glad that it has served the guide to you. Thanks to you.
    Nicolas Crespo

    InforHosting.Net
    Shared Hosting Linux . Dedicated Servers Fully Managed . CPanel . Fantastico

  5. #5
    Would this work with new version of mysql?

  6. #6
    Join Date
    Mar 2006
    Location
    Argentine
    Posts
    19
    I do not know if it works with the new version.
    Nicolas Crespo

    InforHosting.Net
    Shared Hosting Linux . Dedicated Servers Fully Managed . CPanel . Fantastico

  7. #7
    Join Date
    Dec 2004
    Location
    New York, NY
    Posts
    10,710
    Hello,

    That is a pretty standard install procecedure (./configure make make install) so I don't think there should be a problem on a newer version.
    MediaLayer, LLC - www.medialayer.com Learn how we can make your website load faster, translating to better conversion rates for your business!
    The pioneers of optimized web hosting, featuring LiteSpeed Web Server & SSD Storage - Celebrating 10 Years in Business

  8. #8
    Join Date
    Nov 2002
    Location
    Warsaw, IN
    Posts
    184
    It unloads completes stable version of MySQL with wget.

    - Type: tar zxvf mysql-3.23.56.tar.gz
    no, thats the tar command, whats the URL to wget mysql 4? One of my scripts requires mysql 4 in order to function, thanks

  9. #9
    Join Date
    Dec 2004
    Location
    Washington, DC
    Posts
    789
    Quote Originally Posted by bubazoo
    no, thats the tar command, whats the URL to wget mysql 4? One of my scripts requires mysql 4 in order to function, thanks
    MySQL downloads can be browsed and retrieved at http://dev.mysql.com/downloads/

  10. #10
    Quote Originally Posted by VisionaryHost
    Would this work with new version of mysql?

    Do not use this with a newer version. It may crash. Or backup everything and then try it or you may want to try 2 mySQL version on 1 server...
    Last edited by uniVPS; 06-30-2006 at 09:41 AM.

  11. #11
    Join Date
    Aug 2010
    Posts
    25
    Just type:
    yum install mysql-server mysql

  12. #12
    You should do this via the package manager, not from source!

  13. #13
    What about compiling Percona server? Does anyone know how to do this?
    My personal blog -- rubiverse.net

  14. #14
    Join Date
    Mar 2011
    Posts
    98
    [root@vps ~]# tar zxvf mysql-3.23.56.tar.gz
    tar: mysql-3.23.56.tar.gz: Cannot open: No such file or directory
    tar: Error is not recoverable: exiting now
    tar: Child returned status 2
    tar: Error exit delayed from previous errors
    [root@vps ~]#


    sir i got error please help us

  15. #15
    Join Date
    Mar 2011
    Posts
    98
    [root@vps ~]# yum install mysql-server mysql
    Loaded plugins: fastestmirror
    Loading mirror speeds from cached hostfile
    * addons: mirrors.netdna.com
    * base: linux.mirrors.es.net
    * extras: mirrors.ecvps.com
    * rpmforge: apt.sw.be
    * updates: mirror.san.fastserv.com
    addons | 951 B 00:00
    base | 1.1 kB 00:00
    extras | 2.1 kB 00:00
    rpmforge | 1.1 kB 00:00
    updates | 1.9 kB 00:00
    Setting up Install Process
    Resolving Dependencies
    --> Running transaction check
    ---> Package mysql.i386 0:5.0.77-4.el5_5.5 set to be updated
    --> Processing Dependency: perl(DBI) for package: mysql
    ---> Package mysql-server.i386 0:5.0.77-4.el5_5.5 set to be updated
    --> Processing Dependency: perl-DBD-MySQL for package: mysql-server
    --> Running transaction check
    ---> Package perl-DBD-MySQL.i386 0:3.0007-2.el5 set to be updated
    ---> Package perl-DBI.i386 0:1.52-2.el5 set to be updated
    --> Finished Dependency Resolution

    Dependencies Resolved

    ================================================================================
    Package Arch Version Repository Size
    ================================================================================
    Installing:
    mysql i386 5.0.77-4.el5_5.5 updates 4.8 M
    mysql-server i386 5.0.77-4.el5_5.5 updates 9.8 M
    Installing for dependencies:
    perl-DBD-MySQL i386 3.0007-2.el5 base 148 k
    perl-DBI i386 1.52-2.el5 base 600 k

    Transaction Summary
    ================================================================================
    Install 4 Package(s)
    Upgrade 0 Package(s)

    Total download size: 15 M
    Is this ok [y/N]: y
    Downloading Packages:
    (1/4): perl-DBD-MySQL-3.0007-2.el5.i386.rpm | 148 kB 00:00
    (2/4): perl-DBI-1.52-2.el5.i386.rpm | 600 kB 00:00
    (3/4): mysql-5.0.77-4.el5_5.5.i386.rpm | 4.8 MB 00:01
    (4/4): mysql-server-5.0.77-4.el5_5.5.i386.rpm | 9.8 MB 00:02
    --------------------------------------------------------------------------------
    Total 2.6 MB/s | 15 MB 00:05
    Running rpm_check_debug
    Running Transaction Test
    Finished Transaction Test
    Transaction Test Succeeded
    Running Transaction
    Installing : perl-DBI 1/4
    Installing : mysql 2/4
    Installing : perl-DBD-MySQL 3/4
    Installing : mysql-server 4/4

    Installed:
    mysql.i386 0:5.0.77-4.el5_5.5 mysql-server.i386 0:5.0.77-4.el5_5.5

    Dependency Installed:
    perl-DBD-MySQL.i386 0:3.0007-2.el5 perl-DBI.i386 0:1.52-2.el5

    Complete!
    but when i install mysql it was completed

  16. #16
    Join Date
    Nov 2010
    Location
    London, England
    Posts
    171
    Thanks for this tutorial, although couldn't you of just done:

    yum install mysqld mysql-devel
    Robbie Plenderleith
    Operations Lead - Trivu Digital
    http://www.trivudigital.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •