For many years I used xampp (for Linux: Lampp), because of its simplicity, unlike the \u201cnative\u201d Linux apache\/php\/mysql apps, wich seemed to me very difficult to configure.<\/p>\n\n\n\n
The pro<\/strong> of xampp is its simplicity (with few mouse clicks you can do all to install and configure your local php\/mysql sever). But the con<\/strong> is that your xampp apps don’t are updated regularly, and there can raise conflicts with Linux \u201cnative\u201d mysql.<\/p>\n\n\n\n Therefore I decided to learn how to configure \u201cnative\u201d (system-rooted, so to say) apache\/php\/mysql apps. I chose to install mariadb and not mysql.<\/p>\n\n\n\n And in these last weeks I managed to configure the server, with the following steps:<\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" For many years I used xampp (for Linux: Lampp), because of its simplicity, unlike the \u201cnative\u201d Linux apache\/php\/mysql apps, wich seemed to me very difficult to configure. The pro of xampp is its simplicity (with few mouse clicks you can do all to install and configure your local php\/mysql sever). But the con is that … <\/p>\nsudo apt install -y apache2 <\/code><\/li>sudo apt install -y php<\/code><\/li>sudo apt install mariadb*<\/code><\/li>sudo mysql_secure_installation<\/code><\/li>sudo mysql -u root -p (and within >mysql shell<\/code>use mysql<\/code><\/li>GRANT ALL PRIVILEGES ON .<\/em> TO 'root'@'localhost' WITH GRANT OPTION;<\/code><\/li>SHOW GRANTS FOR 'root'@localhost; \/\/to check if it is all right<\/code><\/li>FLUSH PRIVILEGES;<\/code><\/li>exit;<\/code><\/li><\/ul><\/li>sudo systemctl enable mariadb.service<\/code><\/li><\/ul>\n\n\n\n