Uncategorized

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

Crypto mining is one of the way of making a passive income based on the crypto coins received as a reward for mining. Generally the rewards for mining are paid as BitCoin , the most stable coin in the Crypto realm. Due to halving of rewards every four year the Read more…

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

Access MariaDB Server Enter the following command in your command-line terminal to access the MariaDB client shell:sudo mysql -u root If your root user has a predefined password, modify the command to reflect that fact:sudo mysql -u root -p Enter your password and access the MariaDB client. If you do Read more…

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…

Solution sudo apt-get install python3-dev default-libmysqlclient-dev build-essential pip install mysqlclient https://stackoverflow.com/questions/76585758/mysqlclient-cannot-install-via-pip-cannot-find-pkg-config-name-in-ubuntu

https://unix.stackexchange.com/questions/159094/how-to-install-a-deb-file-by-dpkg-i-or-by-apt

Step 5 – Enable HTTPS for WordPress It is always recommended to enable the HTTPS on WordPress website to encrypt the HTTP traffic. You will need to install and configure Let’s Encrypt free SSL to enable the HTTPS. First, install the Let’s Encrypt client package using the following command: Now, Read more…

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…