Instalare MySQL din SURSE

[polarson # ROMANIA]

Obtineti codul sursa care va fi compilat si instalat, in acest tutorial folosim versiunea 5.5.18

• http://mysql.easynet.be/Downloads/MySQL-5.5/mysql-5.5.18.tar.gz

root@bsdpc[~/work] # wget http://mysql.easynet.be/Downloads/MySQL-5.5/mysql-5.5.18.tar.gz
root@bsdpc[~/work] # cd mysql-5.5.18/
root@bsdpc[~/work/mysql-5.5.18] # cmake .
root@bsdpc[~/work/mysql-5.5.18] # make
root@bsdpc[~/work/mysql-5.5.18] # make install
root@bsdpc[~/work/mysql-5.5.18] # cp support-files/mysql.server /etc/rc.d/mysql
root@bsdpc[~/work/mysql-5.5.18] # cp support-files/my-medium.cnf /etc/my.cnf
root@bsdpc[~/work/mysql-5.5.18] # chmod 711 /etc/rc.d/mysql
root@bsdpc[~/work/mysql-5.5.18] # pw user add mysql
root@bsdpc[~/work/mysql-5.5.18] # cd /usr/local/mysql/
root@bsdpc[/usr/local/mysql] # scripts/mysql_install_db --user=mysql
root@bsdpc[/usr/local/mysql] # chown -R mysql .
root@bsdpc[/usr/local/mysql] # chgrp -R mysql .
root@bsdpc[/usr/local/mysql] # chown -R root .
root@bsdpc[/usr/local/mysql] # chown -R mysql data/
root@bsdpc[/usr/local/mysql] # /etc/rc.d/mysql start
Starting MySQL..... SUCCESS!
root@bsdpc[/usr/local/mysql] #
root@bsdpc[/usr/local/mysql] # ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
root@bsdpc[/usr/local/mysql] # ln -s /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump
root@bsdpc[/usr/local/mysql] # mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.18-log Source distribution

Copyright © 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> use mysql;
Database changed
mysql> update user set password=PASSWORD("parola_dorita") where User='root';
Query OK, 4 rows affected (0.02 sec)
Rows matched: 4 Changed: 4 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye
root@bsdpc[/usr/local/mysql] #

Job Done. Enjoy!