Tag: mysql


How to fix ” unknown option ‘–skip-bdb’ ” when executing mysqld

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

How to Install Mysql @ Debian 5.0 i686

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

Back to top