MySQL

From AliceWiki
Jump to: navigation, search

MySQL

$ mysql_secure_installation

set password for booth hots (localhost and strela.jinr.ru)

$ mysqladmin -u root password 'new-password'
$ mysqladmin -u root -h strela.jinr.ru password 'new-password'

phpMyAdmin (Fedora)

$ dnf install phpMyAdmin
$ mv /etc/phpMyAdmin/config.inc.php /etc/phpMyAdmin/config.orig.inc.php
$ wget https://raw.githubusercontent.com/musinsky/config/master/phpMyAdmin/config.inc.php -O /etc/phpMyAdmin/config.inc.php   # rewrite default config file
$ chmod 644 /etc/phpMyAdmin/config.inc.php
$ chown root:root /etc/phpMyAdmin/config.inc.php
$ systemctl restart httpd.service

phpMyAdmin

Download latest phpMyAdmin-*-english.tar.bz2 tarball and unpack to /opt/ directory

$ wget https://raw.github.com/gist/1100340/phpMyAdmin.conf -O /etc/httpd/conf.d/phpMyAdmin.conf
$ chmod 644 /etc/httpd/conf.d/phpMyAdmin.conf
$ chown root:root /etc/httpd/conf.d/phpMyAdmin.conf

$ wget https://raw.github.com/gist/1100340/config.inc.php -O /opt/phpMyAdmin/config.inc.php
$ chmod 644 /opt/phpMyAdmin/config.inc.php
$ chown root:root /opt/phpMyAdmin/config.inc.php

$ systemctl restart httpd.service

/etc/httpd/conf.d/phpMyAdmin.conf (chmod - 644, chown - root:root) /opt/phpMyAdmin/config.inc.php (chmod - 644, chown - root:root)

PHP

/etc/php.ini

upload_max_filesize = 8M