This is a common issue for Ubuntu users when they just finish installing MySQL on their environments. When they try to login using:
|
1 |
$ mysql -u root |
…
In this tutorial I will show you how to boot Hackintosh with no need to use an USB stick. Assuming you used Clover Configuraton…
This is a simple tutorial to show you how to clear a database without dropping it completely.
|
1 2 3 4 5 6 7 8 9 10 11 12 |
# Create a sql file with all the DROP TABLE queries for each table $ mysql -uUSER -pPASSWORD -e "SELECT concat('DROP TABLE IF EXISTS ', table_name, ';') FROM information_schema.tables WHERE table_schema = 'YOURDATABASE';" > drop.tables.sql # Remove the first line of the file $ tail -n +2 drop.tables.sql > drop.tables.sql.tmp && mv drop.tables.sql.tmp drop.tables.sql # Disable Foreign Key Checks $ echo 'SET FOREIGN_KEY_CHECKS = 0;' | cat - drop.tables.sql > tmp && mv tmp drop.tables.sql $ echo 'SET FOREIGN_KEY_CHECKS = 1;' | cat - drop.tables.sql >> tmp && mv tmp drop.tables.sql # Execute your SQL file $ mysql -uUSER -pPASSWORD YOURDATABASE < drop.tables.sql |
This is a simple command to fetch the DNS information for a single domain.
|
1 |
$ dig codealist.net NS |
The “NS” argument gives the ability to list the…
Search string in MySQL database In this tutorial I will show you how to search a specific string in a whole MySQL Database. Let’s…
Cross-site Scripting (XSS) XSS is a code-injection type which is performed on the client-side. By using this type of attach, the attacker does not…
How to detect JavaScript Vulnerabilities In this tutorial I will show you how to detect javascript vulnerabilities on websites using a very simple tool…
Install Jpegoptim If you haven’t jpegoptim installed on your environment execute the following in your terminal:
|
1 |
$ apt-get install jpegoptim |
And if you are running on Mac,…
Make sure you’ve got bash installed. Learn the location of bash:
|
1 |
which bash |
or
|
1 |
whereis bash |
Below, I’ll assume the location is /bin/bash. a) If you…
In this tutorial we will show you how to install a Lamp server with PHP 7.0 and 5.6. You will use PHP 7.0 for…
This is one of the most common issues received when you are trying to optimize the performance of your website. Leverage your browser caching means…
If you have a Magento project, you need to enable Gzip compression to speed it up. First of all make sure you have the…