Instalare MySQL din surse
Obtineti codul sursa care va fi compilat si instalat, in acest tutorial folosim versiunea 5.5.18
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 (c) 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!
Script backup baze de date MySQL
Un mic script bash pentru backup la bazele de date MySQL:
#!/bin/sh
# Backup Baze de date MySQL
b_dir="/usr/BACKUP/"
log_dir="/var/log/backup/"
MySQL_db_dir="/usr/local/mysql/var/"
MySQK_bk_user="userul de backup"
MySQL_bk_pw="Parola pentru userul de backup"
mkdir $b_dir`date +"%d%b%y"`
mkdir $b_dir`date +"%d%b%y"`/mysql/
# MySQL
for i in `ls $MySQL_db_dir | sed -e 's/\///'` ; do
if [ -d $MySQL_db_dir$i ] ; then
cd $b_dir`date +"%d%b%y"`/mysql/
/usr/bin/mysqldump $i -u $MySQL_bk_user -p"$MySQL_bk_pw" > $i-`date +"%d%b%y"`.sql
tar cjf $i-`date +"%d%b%y"`.sql.tar.bz2 $i-`date +"%d%b%y"`.sql
rm -rf $i-`date +"%d%b%y"`.sql
fi
done
Job done. Enjoy!
Recuperare parola MySQL
In cazul in care ati uitat parola pentru userul root de la MySQL aceasta se poate recupera foarte usor. (Comenzile de mai jos pentru oprire si pornire server MySQL sunt executate pe un sistem FreeBSD dar procedeul este acelasi indiferent de sistemul pe care este instalat serverul MySQL)
1. Oprim serverul MySQL:
root@bsdpc[~] # /etc/rc.d/mysql stop
2. Pornim serverul MySQL fara "grant tables":
root@bsdpc[~] # /usr/local/mysql/bin/mysqld_safe --skip-grant-tables &
3. Accesam serverul MySQL din CLI (Command Line Interface):
root@bsdpc[~] # /usr/local/mysql/bin/mysql -u root
4. Selectam baza de date mysql si setam noua parola pentru userul root:
mysql> use mysql;
Database changed
mysql> update user set password=PASSWORD("ParolaDorita") where User='root';
Query OK, 0 rows affected (0.02 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.05 sec)
mysql>quit;
5. Oprim serverul MySQL:
root@bsdpc[~] # /etc/rc.d/mysql stop
6. Repornim serverul MySQL cu optiunile normale de startup:
root@bsdpc[~] # /etc/rc.d/mysql start
Job done. Enjoy!