Another way to reset the password for a WordPress user account.

http://codex.wordpress.org/User:MichaelH/Orphaned_Plugins_needing_Adoption/Emergency. This PHP script when run on a web server will allow a webmaster to reset the Administrator password for a WordPress installation. This is another good way to reset the password if you forget it. If you have access to the MySQL command line you may also use that to reset the password. The … Read more

Export a database from MySQL when it is using the secure file privilege setting.

MySQL can be a pain to use when it is is running with the –secure-file-priv option and it cannot export a database to your home folder. But there is a way around this. Execute this query in MySQl. 4.4 Mon Aug 19 jason@Yog-Sothoth 0: $ mysql -uroot -p Enter password: Welcome to the MySQL monitor. … 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

More MySQL tips for viewing data in a database and listing the columns in a table.

In this example; we are using the old and crusty Northwind database in the latest MySQL database engine. Here I am showing the tables in the database. mysql> show tables in nw_old; +——————+ | Tables_in_nw_old | +——————+ | categories | | customers | | employees | | order_details | | orders | | products | … Read more

How to list the indexes in a MySQL database table.

How to list the indexes in a MySQL database table. Easily done using the show command. mysql> show index from customer; +———-+————+——————-+————–+——————–+———–+————-+———-+——–+——+————+———+—————+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +———-+————+——————-+————–+——————–+———–+————-+———-+——–+——+————+———+—————+ | customer | 0 | … Read more

More MySQL tips. Listing databases and viewing the MySQL version.

How to list tables in a MySQL database. mysql> show tables in acme; +—————-+ | Tables_in_acme | +—————-+ | address | | customer | | discount | | order_header | | order_line | | order_shipment | | payment_terms | | phone | | product | | reseller | | salesman | | shipment | | … Read more

Database engines, how does MySQL compare to other 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

using the MySQL SELECT statement to only select certain records.

We are taking another look at our database table and we are wanting to only view records that match certain criteria. This is easy with the SELECT statement. mysql> select * from operatingsystems where vendor in ("Microsoft","Mint"); +——+————————+———+———–+ | OsID | Name | Type | vendor | +——+————————+———+———–+ | 1 | Windows 3.0 | Windows … Read more

Using the MySQL SELECT statement to only show records that are a certain type.

Following on from my previous posting that covered setting up a MySQL database, here is a simple query that returns records that match a certain type. mysql> select * from operatingsystems where Type = "Windows"; +——+————-+———+———–+ | OsID | Name | Type | vendor | +——+————-+———+———–+ | 1 | Windows 3.0 | Windows | Microsoft … Read more

Securing your WordPress installation with Website Defender.

http://www.websitedefender.com/announcements/websitedefender-wordpress-security-plugin-news/scan-blog-wordpress-security-scan/. Securing your WordPress installation is vital, the PHP installation as well as the MySQL database need to be protected. The Website Defender website offers a free service that will scan your website and offer suggestions on how to secure your WordPress installation and any other software that you have installed such as PHPBB. I … Read more