:: What is MySQL
MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. – wikipedia
:: How to install MySQL 5.5 on Linux OpenSUSE
+ install dependency
|
1 |
zypper in cmake gcc gcc-c++ gcc33-c++ bison libaio-devel ncurses-devel wget |
+ create user and group
|
1 2 |
groupadd mysql
useradd -r -g mysql mysql |
+ download MySQL
|
1 |
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.17.tar.gz/from/http://mysql.mirrors.pair.com/ |
+ extract and compile MySQL
|
1 2 3 4 |
tar -xzf mysql-5.5.17.tar.gz
cd mysql-5.5.17
cmake .
make |
+ installing MySQL
|
1 2 |
make install DESTDIR="/usr/local/mysql"
make install && make install scripts |
+ setup mysql
|
1 2 3 |
chown -R mysql.mysql /usr/local/mysql/
cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
/usr/local/mysql/scripts/mysql_install_db --user=mysql --ldata=/usr/local/mysql/data --basedir=/usr/local/mysql |
+ starting mysql
|
1 |
/usr/local/mysql/bin/mysqld_safe --user=mysql & |
+ testing
|
1 |
/usr/local/mysql/bin/mysql |
:: links
+ Google
+ ServerFlux