Installation phpmyadmin

https://www.youtube.com/watch?v=ZpazIwFMqY8

sudo pacman -S mariadb apache php php-apache

sudo systemctl enable httpd –now

sudo nano /etc/httpd/conf/httpd.conf

#les deux ligne suivante doit etre commenté et décommenté pour donné ceci :

“

#LoadModule mpm_event_module modules/mod_mpm_event.so

LoadModule mpm_prefork_module modules/mod_mpm_prefork.so

“

# a la fin du fichier rajouter

“

LoadModule php_module modules/libphp.so

AddHandler php-script .php

# Configuration de phpMyAdmin

Include conf/extra/phpmyadmin.conf

“

sudo systemctl restart httpd

sudo systemctl enable mariadb –now

sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

sudo mysql -u root

>use mysql

>flush privileges;

>ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘new_password’;

sudo mysql -u root -p

>CREATE USER 'flo'@'localhost' IDENTIFIED BY 'flo';

>GRANT ALL PRIVILEGES ON mydb.* TO 'flo'@'localhost';

>FLUSH PRIVILEGES;

>quit

mysql_secure_installation

sudo pacman -S phpmyadmin

#configuré apache

sudo nano /etc/httpd/conf/extra/phpmyadmin.conf

#entrer dedans

Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"

DirectoryIndex index.php

AllowOverride All

Options FollowSymlinks

Require all granted

</Directory>

sudo nano /etc/php/php.init

#enlever le “;” de la ligne extension=mysql

sudo systemctl restart httpd