Web Hosting Talk : Web Hosting Main Forums : VPS Hosting : VPS Tutorials : HowTo: Install MySQL

[Frion]

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,

[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

[cooled]

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.

[Frion]

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.

[VisionaryHost]

Would this work with new version of mysql?

[Frion]

I do not know if it works with the new version.

[layer0]

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.

[bubazoo]

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

[Mark S]

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/

[uniVPS]

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...

[gangcai]

Just type:
yum install mysql-server mysql

[Dr-Horrible]

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

[flam316]

What about compiling Percona server? Does anyone know how to do this?

[eric6630]

[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

[eric6630]

[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