phpmyadmin

phpmyadmin

by

cd /usr/local/src wget https://files.phpmyadmin.net/phpMyAdmin/4.8.2/phpMyAdmin-4.8.2-all-languages.zip unzip phpMyAdmin-4.8.2-all-languages.zip mkdir /usr/serverok rm -rf /usr/serverok/phpmyadmin mv phpMyAdmin-4.8.2-all-languages /usr/serverok/phpmyadmin mkdir /usr/serverok/phpmyadmin/tmp/ chmod 777 /usr/serverok/phpmyadmin/tmp/ cp /usr/serverok/phpmyadmin/config.sample.inc.php /usr/serverok/phpmyadmin/config.inc.php Edit vi /usr/serverok/phpmyadmin/config.inc.php Generate 32 chars length random key and add pwgen 32 Or sed -i ‘s/$cfg\[.blowfish_secret.\] = .*$/$cfg\[“blowfish_secret”\] = “ohhae8Fa6oJohrohng0ieV0to3aiThae”;/g’ /usr/serverok/phpmyadmin/config.inc.php Configure Apache On Ubuntu, create file vi /etc/apache2/conf-enabled/phpmyadmin.conf On CentOS vi … Read more

MySQL root can’t login to phpMyAdmin

by

On Debian/Ubuntu MySQL root user can only login using socket. This is done with Plugin. MariaDB [(none)]> select User, Plugin from mysql.user; +———–+————-+ | User | Plugin | +———–+————-+ | root | unix_socket | | sserverok | | +———–+————-+ 2 rows in set (0.00 sec) MariaDB [(none)]> To fix this, first set a password for … Read more

Debian Allow MySQL root user to login using phpMyAdmin

by

On Debian/Ubuntu by default MySQL root user can only login from local accounts. MariaDB [(none)]> select plugin from mysql.user where user=’root’; +————-+ | plugin | +————-+ | unix_socket | +————-+ 1 row in set (0.00 sec) MariaDB [(none)]> To enable login from phpMyAdmin, you need to set plugin to “mysql_native_password”. To do this, login to … Read more