场景:
Ubuntu18.04下重新安装MySQL+数据管理后台phpMyAdmin
先卸载原有的MySQL
$sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-* $sudo rm -rf /etc/mysql /var/lib/mysql $sudo apt-get autoremove $sudo apt-get autoclean
MySQL install
// Installing MySQL $sudo apt install mysql-server // Configuring MySQL $sudo mysql_secure_installation // (Optional) Adjusting User Authentication and Privileges $sudo mysql mysql> SELECT user,authentication_string,plugin,host FROM mysql.user; mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; mysql> FLUSH PRIVILEGES; mysql> SELECT user,authentication_string,plugin,host FROM mysql.user; mysql> exit $sudo mysql $mysql -u root -p mysql> CREATE USER 'kumata'@'localhost' IDENTIFIED BY 'password'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'kumata'@'localhost' WITH GRANT OPTION; mysql> exit // Testing MySQL $systemctl status mysql.service $sudo mysqladmin -p -u root version
phpMyAdmin
// Install $sudo apt install phpmyadmin php-mbstring php-gettext
During this installation you’ll be asked for the web server selection, we will select Apache2 and select ENTER.
Enable PHP extension.
configure your /etc/apache2/apache2.conf to enable PhpMyAdmin to work.
$vim /etc/apache2/apache2.conf
add infos:
Include /etc/phpmyadmin/apache.conf
Restart apache
$sudo systemctl restart apache2
Config_1: User loginfile
$sudo vim /etc/phpmyadmin/config-db.php $dbuser='[login_name]'; $dbpass='[login_passwd]'; $basepath=''; $dbname='phpmyadmin'; $dbserver='localhost'; $dbport='3306'; $dbtype='mysql';
Config_2: 'The configuration file now needs a secret passphrase'
// rand a number $openssl rand -base64 32 xVuFFnjUU0EN49vrdvw23Ip61VZsNxw3QdFafmzzJHU= // edit $sudo vim /usr/share/phpmyadmin/libraries/config.default.php // find and add $cfg['blowfish_secret'] = ''; -> $cfg['blowfish_secret'] = 'xVuFFnjUU0EN49vrdvw23Ip61VZsNxw3QdFafmzzJHU=';
Start phpMyAdmin
http://[ip]/phpmyadmin/index.php
参考文章:
https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04