phpmyadmin安装mysql

sudo apt update
sudo apt install mysql-server

sudo apt install phpmyadmin

sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin
sudo systemctl restart apache2

sudo nano /etc/apache2/sites-available/000-default.conf

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
    Options Indexes FollowSymLinks
    DirectoryIndex index.php

    <IfModule mod_authz_core.c>
        # Apache 2.4
        <RequireAll>
            Require all granted
        </RequireAll>
    </IfModule>

    <IfModule !mod_authz_core.c>
        # Apache 2.2
        Order Deny,Allow
        Allow from all
        Deny from none
    </IfModule>
</Directory>

sudo systemctl restart apache2

sudo nano /etc/nginx/sites-available/default

location /phpmyadmin {
    root /usr/share/;
    index index.php;

    location ~ ^/phpmyadmin/(.*\.php)$ {
        try_files $uri =404;
        root /usr/share/;
        fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;  # 根据你的 PHP 版本调整
        fastcgi_index index.php;
        include fastcgi_params;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }
}

sudo systemctl restart nginx

mysql -u root -p

CREATE USER 'phpmyadminuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadminuser'@'localhost';
FLUSH PRIVILEGES;
EXIT;

sudo nano /etc/phpmyadmin/config.inc.php

$cfg['Servers'][$i]['user'] = 'phpmyadminuser';
$cfg['Servers'][$i]['password'] = 'password';