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.
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 after the installation it is … Read more
Import 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 necessary, as importing the database … Read more
What 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 of the Database, with user … Read more
Snapchat 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 much now? I hope that … Read more
Ubuntu 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 and had administrator privileges and … Read more
How 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 product is installed on a … Read more
How 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 | admin | [email protected] | … Read more
Fedora 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 a new change just like … Read more
Website 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, with my old posts now … Read more