How to Install Mysql @ Debian 5.0 i686

Requirement

GNU C Compiler and other small packages required

debian:~# apt-get install gcc build-essential automake autoconf autoreconf libncurses5-dev

Package :

debian:~# wget http://mirror.csclub.uwaterloo.ca/mysql/Downloads/MySQL-5.1/mysql-5.1.44.tar.gz

Installation

debian:~# tar -zxvf mysql-5.1.44.tar.gz
debian:~# cd mysql-5.1.44/
debian:~/mysql-5.1.44# ./configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/var \
--with-pthread --with-big-tables
debian:~/mysql-5.1.44# make && make install
debian:~/mysql-5.1.44# chown -R mysql.mysql /usr/local/mysql
debian:~/mysql-5.1.44# cd /usr/local/mysql/share/mysql
debian:~/mysql-5.1.44# cp my-small.cnf /etc/my.cnf
debian:~/mysql-5.1.44# /usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/
debian:~/mysql-5.1.44# mv /usr/local/mysql/share/mysql/english/ /usr/share/mysql/
debian:~/mysql-5.1.44# /usr/local/mysql/bin/mysqld_safe &
debian:~/mysql-5.1.44#/usr/local/mysql/bin/mysqladmin -u root password 'password'
Test 
debian:~/mysql-5.1.44# /usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.44 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Additional : Error when executing mysqld.Click Here

Category: Linux | Tags: , , , , , , , , , 8 comments »

8 Responses to “How to Install Mysql @ Debian 5.0 i686”

  1. ervan:~# tail -f /var/log/blog » Blog Archive » How to install PHP @ Debian 5.0 i686
    March 17th, 2010 at 3:18 am

    [...] *OpenSSL *Apache2 Web Server *Mysql [...]
  2. ervan:~# tail -f /var/log/blog » Blog Archive » How Install Cyrus SASL @ Debian 5.0 i686
    March 31st, 2010 at 8:06 am

    [...] * Mysql [...]
  3. ervan:~# tail -f /var/log/blog » Blog Archive » Setting Up Wordpress Latest Version
    March 31st, 2010 at 8:42 am

    [...] * Apache * Mysql [...]
  4. ervan:~# tail -f /var/log/blog » Blog Archive » Installing Snort with BASE support,Mysql and ADODB
    June 8th, 2010 at 9:37 pm

    [...] * Web Server and Database Server * Apache2 * MySQL [...]
  5. ervan:~# tail -f /var/log/blog » Blog Archive » Trouble Ticket System yang terintregasi dengan Sms Gateway
    June 18th, 2010 at 12:19 am

    [...] baca disini) – Smstools 3 (penginstallan dan konfigurasi baca disini) – Apache2 – Linux Crontab – MySQL Server – PHP – Lynx (Console Web Browser) – Root [...]
  6. ervan:~# tail -f /var/log/blog » Blog Archive » How to Backup and Restoring MySQL Database
    June 18th, 2010 at 10:29 pm

    [...] * MySQL [...]
  7. MySQL Master Slave Replication | ervan:~# tail -f /var/log/blog
    July 13th, 2010 at 3:29 pm

    [...] MySQL Master Slave Replication is one way to spread the load across multiple servers.Replication allows you to take one database, make an exact copy of it on another server, and set one of them (the slave) to take all its updates from the other (the master). Its just an one-way communication (Master to Slave), Slave just receiving any event or update from Master, so if Master updated Slave will automatic updated too but if Slave updated Master is won’t updated. If you want update Multiple Server simultaneously you must try MySQL Master Master Replication. [...]
  8. Setting Up PHPMyAdmin with mcrypt and mbstrings | ervan:~# tail -f /var/log/blog
    July 22nd, 2010 at 3:57 pm

    [...] MySQL * PHP * [...]

Leave a Reply



↑ Back to top