Cannot start mysqld after switching to MariaDB

After upgrade to MariaDB start mysqld have below error message: mysqld[9358]: 130326 0:27:18 Percona XtraDB ( 5.5.30-MariaDB-30.1 started; log sequence number 46580545 mysqld[9358]: 130326 0:27:18 [ERROR] mysqld: Got error 'Size of control file is smaller than expected' when trying to use aria control file '/var/lib/mysql/aria_log_control' mysqld[9358]: 130326 0:27:18 [ERROR] Plugin 'Aria' init function returned error. …

Continue reading ‘Cannot start mysqld after switching to MariaDB’ »

Gallery2 move server

Backup gallery2 directory: #cd /srv/http/ #tar -czvf gallery2.tgz gallery2 Backup g2data #tar -czvf g2data.tgz g2data Backup database: #mysqldump -u root -p gallery2 > gallery2.sql Copy backup file to new server and restore: #tar -xzvf gallery2.tgz #tar -xzvf g2data.tgz Create database: #mysqladmin -uroot -p create gallery2 Create user account: #mysql gallery2 -uroot -p -e”GRANT ALL ON …

Continue reading ‘Gallery2 move server’ »

MySQL Change root Password

Set root password #mysqladmin -u root password ‘NEWPASSWORD’ Change root password #mysqladmin -u root -p’oldpassword’ password ‘NEWPASSWORD’ Reset root password # /etc/rc.d/mysql stop # mysqld_safe –user=mysql –skip-grant-tables –skip-networking & # mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD(‘NEWPASSWORD’) where USER=’root’; mysql> FLUSH PRIVILEGES; mysql> quit # /etc/init.d/mysql restart

LAMP with SSL on Archlinux box

Install Apache, PHP, and MySQL #pacman -S apache php php-apache mysql Comment one module in Apache configuration /etc/httpd/conf/httpd.conf #LoadModule unique_id_module modules/ Add httpd daemons in /etc/rc.conf DAEMONS=(… some daemons … @httpd) Create CA key in /etc/httpd/conf #openssl req -new -x509 -newkey rsa:1024 -days 3650 -keyout server.key -out server.crt #openssl rsa -in server.key -out server.key Uncomment …

Continue reading ‘LAMP with SSL on Archlinux box’ »