Install MySQL Debain 12

https://docs.vultr.com/how-to-install-mysql-on-debian-12 https://stackoverflow.com/questions/21221220/cant-connect-to-mysql-server-on-ip-or-domain-name https://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html https://askubuntu.com/questions/699903/why-is-etc-mysql-my-cnf-empty https://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y https://stackoverflow.com/questions/52372165/mysql-error-1064-42000-you-have-an-error-in-your-sql-syntax https://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address

MARIADB Notes

Command Usage FLUSH PRIVILEGES GRANT ALL PRIVILEGES ON *.* to ‘user_name’@’host_name’ WITH GRANT OPTION; Grant Super user Access CREATE USER ‘username’@’hostname’ IDENTIFIED BY ‘password’; Create Super User GRANT ALL PRIVILEGES ON * . * TO ‘matthew’@’%’; Grant permission References Create Superuser in MariaDB https://tableplus.com/blog/2018/10/how-to-create-superuser-in-mariadb.html

Apache Server Commands : Debian

Command sudo apt install apache2 Install Apache Server sudo systemctl status apache2 Server Status sudo systemctl stop apache2 Stop Server sudo systemctl start apache2 sudo systemctl restart apache2 sudo systemctl reload apache2 sudo systemctl disable apache2 sudo systemctl enable apache2 sudo a2ensite your_domain.conf Enable Virtual Host sudo a2dissite 000-default.conf Disable Read more…

Debian 11 Installation issues and resolution

Install Visual Studio code https://wiki.debian.org/VisualStudioCode Note : After installation if you have logged in root the program might not execute. Login with another super user and check. How to create super user in Debian https://phoenixnap.com/kb/create-a-sudo-user-on-debian Enable mysqli script for PHP for installing wordpress https://stackoverflow.com/questions/54500881/how-do-i-enable-mysqli-for-my-php-script Apache shows PHP code instead of Read more…