How to install and use MySQL in 2022 with the proper password set for the root user. How to fix the ‘SET PASSWORD has no significance for user ‘root’@’localhost” error and use this database properly.
Read MoreHow to create a simple database in MySQL. This is a good beginner tutorial. Very useful to get you started using MySQL.
Read MoreHow to use plain text queries in MySQL database to find certain strings in a database instance. This could be very useful.
Read Morehttp://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…
Read MoreMySQL 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:…
Read MoreImporting 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 MoreA 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 MoreThe much-hyped Windows 10 bash shell is quite underwhelming to say the least. This is good as an SSH client and to browse the web using Lynx, but ping and ifconfig do not work at all. I could not get the MySQL server running either. This is what I get…
Read MoreIn 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 | |…
Read MoreHow 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 | +———-+————+——————-+————–+——————–+———–+————-+———-+——–+——+————+———+—————+…
Read MoreHow 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…
Read MoreComparing 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 MoreWe 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…
Read MoreFollowing 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…
Read Morehttp://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…
Read More