Wednesday, June 24, 2009

MySql 6.11 Compile on Ubuntu 9.04

MySql install notes on Ubuntu 9.04
If you use this, you may have to read in between the lines here and there. I wasn't able to get the icc already compiled version to work b/c of a syntax error with my_print_defaults. But I compiled it from source and its working perfect. The sub-query system is so much faster, its unbelievable. I recommend using the mysql6-falcon alpha linux source install.

Compile Mysql6-falcon for ubuntu 9.04.


# get mysql source

# copy source - compile from this - do this incase you mess up
cp -R mysql-6.0.10-alpha mysql6

cd ./mysql6

sudo apt-get install build-essential
sudo apt-get install lib64ncurses5 libncurses5 libncurses5-dbg libncurses-dev
sudo apt-get install autoconf libtool

# auto configure
autoreconf -vif

# configure options
#./configure --help

#it was weird it stuck some stuff in the data directory that probably shouldn't be there but is fixable afterwords. I moved it to basedir/share/mysql
./configure --prefix=/srv/mysql6 --datadir=/mnt/ssd/mysql
#./configure --prefix=/srv/mysql6_11 #upgrading to .11


sudo make install

# copied my.cnf to /etc/mysql/my.cnf and linked /etc/my.cnf
# set [mysqld] datadir=/srv/mysql6 basedir=/srv/ssd/mysql

# add user and group
# set perimissions where needed

# setup the default system
./bin/mysql_install_db --user=mysql --basedir=/srv/mysql6 --builddir=/home/branflake2267/downloads/mysql6b --datadir=/mnt/ssd/mysql
#./bin/mysql_install_db --user=mysql --basedir=/srv/mysql6_11 --builddir=/home/branflake2267/downloads/mysql-6.0.11-alpha

# add hash next to skip-federated - notate it

#add ./share/mysql/mysql.server to /etc/init.d/mysql.server

# change basedir and datadir in mysql.server

# link ./bin/mysql to /usr/bin/mysql

# start server
sudo /etc/init.d/mysql.server start

# mysql - no password exists for root localhost user yet
./bin/mysql -uroot -p

# add user
CREATE USER 'Branflake2267'@'localhost' IDENTIFIED BY 'password*7';
GRANT ALL PRIVILEGES ON *.* TO 'Branflake2267'@'localhost' WITH GRANT OPTION;
flush privileges;

#mysqls help./b
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip <> cd mysql-VERSION
shell> ./configure --prefix=/usr/local/mysql
shell> make
shell> make install
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> bin/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql var
shell> bin/mysqld_safe --user=mysql &

My data project wiki notes -

No comments:

Trying out the Dart Analysis Server

I wanted to see how the Dart Analysis Server was put together and worked. I started looking to see how I could wire it up and try out the co...