Creating a simple database with MySQL on either Linux or Windows. This will get you started.
How to create a simple database in MySQL. This is a good beginner tutorial. Very useful to get you started using MySQL.
Read MoreTag: database
Comparing database engines.
Comparing database engines is quite complex when you are deciding on which engine to use for managing a database on a desktop machine or a database for a website, although the MySQL engine is the most refined and stable database engine that is available today. Installation is very simple and…
Read MoreImport a WordPress database dump into MySQL easily.
Importing a WordPress database dump into MySQL is very easy, I downloaded a very old backup of my old website, and I wanted to see what was in it. So I installed MySQL and then I had to create the database. mysql> CREATE DATABASE bejiitas_wrath;mysql> CREATE DATABASE bejiitas_wrath; This was…
Read MoreWhat is a database management system?
A Database Management System is a system that allows multiple users to access, create and modify data entries in a database. The program is a multiuser application that will allow multiple users to access and change records easily, whilst maintaining the integrity of the data and also ensuring the security…
Read MoreSnapchat database compromised. Censored database dump leaked onto the Internet.
The picture sharing website Snapchat has been compromised. This hack has leaked data on all of the users online. This shows that the staff of this website do not care about security at all. And he turned down 4 billion dollars from Facebook, but will the website be worth that…
Read MoreUbuntu forums cracked by a malicious individual. Users demand answers.
http://www.reddit.com/r/Ubuntu/comments/1iy1sv/official_ubuntu_forums_hacked_we_demand_answers/. The Ubuntu forums have been cracked by a malicious user. This person has taken the database and now has all of the password and e-mail information in his/her grasp. This is a more regular occurrence these days. The problem seems to have been a VBulletin mod that was compromised…
Read MoreHow to install an anti-virus product for your Linux computer to protect any Windows machines from viruses.
Installation of Anti Virus software for Linux. This is to protect Windows users who are connecting to the Linux server to get files. This posting describes the installation and configuration of an Anti Virus product for Linux. I have chosen the Clamav Anti Virus product for x86 Linux. This Anti-Virus…
Read MoreHow to view the Admin account in the WordPress database using MySQL and a database dump.
How to view the Admin account in the WordPress database using MySQL. mysql> select * from wp_users where user_login = "Admin"; +—-+————+————————————+—————+————————+——————————+———————+———————+————-+————–+ | ID | user_login | user_pass | user_nicename | user_email | user_url | user_registered | user_activation_key | user_status | display_name | +—-+————+————————————+—————+————————+——————————+———————+———————+————-+————–+ | 1 | Admin | $P$Bt0QTjses0mAaASZtqYbcnz8zalQK71…
Read MoreFedora 19 to replace the MySQL database management system with MariaDB.
The Fedora 19 Linux distribution is planning to move away from the current MySQL database management system and adopting the MariaDB DBMS instead. Hopefully the Fedora desktop will not be as much of a mess as the Fedora 18 distribution was with Gnome Shell. But adopting a new DBMS is…
Read MoreWebsite database fixed.
I have done a search and replace on my database and I have fixed a long-standing issue with the website where the image urls were linked to securitronlinux.com, my old url and not the securitronlinux.com. I used a plug in for WordPress to perform the task and it worked fine,…
Read More