Installazione di MariaDB in Debian Buster: Difference between revisions
Jump to navigation
Jump to search
Created page with "{{Stub}} =Riferimenti= *[https://computingforgeeks.com/how-to-install-mariadb-on-debian-10-buster/ How To Install MariaDB on Debian 10 Buster | ComputingForGeeks]" |
mNo edit summary |
||
| Line 1: | Line 1: | ||
{{Stub}} | {{Stub}} | ||
Il passo importante per abilitare l'autenticazione via password per root (e quindi per phpmyadmin) è: | |||
sudo mysql -u root | |||
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE User = 'root'; | |||
FLUSH PRIVILEGES; | |||
QUIT; | |||
*Test: | |||
mysql -u root -p | |||
Enter password: | |||
Welcome to the MariaDB monitor. Commands end with ; or \g. | |||
Your MariaDB connection id is 67 | |||
Server version: 10.3.13-MariaDB-1 Debian buildd-unstable | |||
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. | |||
=Riferimenti= | =Riferimenti= | ||
*[https://computingforgeeks.com/how-to-install-mariadb-on-debian-10-buster/ How To Install MariaDB on Debian 10 Buster | ComputingForGeeks] | *[https://computingforgeeks.com/how-to-install-mariadb-on-debian-10-buster/ How To Install MariaDB on Debian 10 Buster | ComputingForGeeks] | ||
Latest revision as of 10:43, 7 July 2021
| Attenzione questo articolo è ancora incompleto. Sentiti libero di contribuire cliccando sul tasto edit. |
Il passo importante per abilitare l'autenticazione via password per root (e quindi per phpmyadmin) è:
sudo mysql -u root
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE User = 'root'; FLUSH PRIVILEGES; QUIT;
- Test:
mysql -u root -p
Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 67 Server version: 10.3.13-MariaDB-1 Debian buildd-unstable Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.