March 16th, 2010 — 1:12am
Error
debian:~# ./scripts/mysql_install_db
100315 17:24:41 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-bdb'
100315 17:24:41 [ERROR] Aborting
Effect
Mysqld won’t install system db
How to Fix
Go to /etc/mysql/my.cnf and comment --skip-bdb
1 comment » | Linux
March 16th, 2010 — 12:58am
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
8 comments » | Linux