Linux, MySQL / March 22, 2021 / ashishpsk / 0
Enter the mysql prompt by following the step below: It then prompts for password. Enter the MySQL root password. Command to Grand All privileges on DB for a user. how to add SELECT privileges to a user using GRANT. how to add a selection of privileges to a user using GRANT.
Linux, MySQL / March 22, 2021 / ashishpsk / 0
One thing you must understand is that mysql server only allow localhost connections by default. So what does that mean ? Before going deep let me put up an example mysql-server. (1) ” Consider abc.com (5.5.5.5) is our mysql-server and is hosted on a VPS machine. We have setup a lamp environment on 5.5.5.5 and
Linux, MySQL / March 22, 2021 / ashishpsk / 0
Stop mysql server Start mysql configuration, Execute the command as mysql safemode: Replace old password with the new one from mysql command prompt. Restart mysql server. Access mysql by using new password
Linux, MySQL / March 22, 2021 / ashishpsk / 0
To get a list of all MySQL user accounts, use the SELECT statement to retrieve all rows from the mysql.users table: Backup a Single MySQL Database: Backup all MySQL databases to separate files: Create a Compressed MySQL Database Backup: Create a Backup with Timestamp: Restoring a MySQL dump : Restoring using MySQL Prompt, using source: On the command-line, if you’re
Hosting, Linux / March 18, 2021 / ashishpsk / 0
Before starting the scan for the whole server, first adjust the CXS ignore list, since there are some standard cPanel files located in /home folder that will trigger false-positive results. To do this, run the following command: Now you can start the scan. In order to run it in the background, save the report to the /root//full_server_scan file and
Linux, Ubuntu / March 15, 2021 / ashishpsk / 0
Today out of curiosity I tried installed Unity on Ubuntu 20.04 and after uninstalling it, on rebooting blank screen appeared rather than Ubuntu 20.04 login screen: The black screen appears because the Ubuntu boot process defaults to tty7, the terminal where the graphical login (lightdm) would normally be running. To get to a login prompt,
Hosting, Linux / March 12, 2021 / ashishpsk / 0
If Apache is experiencing a DDoS attack, you may notice errors like these in the Apache error log: You can check whether Apache is experiencing a DDoS attack with this command, which shows the top 10 IP addresses from which Apache is receiving connections: If you notice a large number of connections from an unrecognized
Linux, Monitoring, Uncategorized / March 9, 2021 / ashishpsk / 0
To know uptime and other parameters: Disk Usage check: Curl Command to download file from FTP Server:
Uncategorized / March 8, 2021 / ashishpsk / 0
Fix: restorecon -r /var/www/html The issue is caused when you mv something from one place to another. It preserves the selinux context of the original when you move it, so if you untar something in /home or /tmp it gets given an selinux context that matches its location. Now you mv that to /var/www/html and