{"id":581,"date":"2023-07-12T08:04:35","date_gmt":"2023-07-12T08:04:35","guid":{"rendered":"https:\/\/cachitoswp.com\/?p=581"},"modified":"2025-06-01T18:17:50","modified_gmt":"2025-06-01T18:17:50","slug":"modify-wp-database-without-fear","status":"publish","type":"post","link":"https:\/\/cachitoswp.com\/en\/modify-wp-database-without-fear\/","title":{"rendered":"Easily modify and tinker with your WordPress database without fear"},"content":{"rendered":"

I start with the intro for beginners or foolish users of Elementor and similar: The database of your WordPress is where the posts and pages and all the options of the theme, the plugins and each little box that you fill out and then click on are stored. "keep".<\/p>\n\n\n\n

The BD (Hey, did you know that in France, these acronyms mean something like "comic"?) It is not intended to be "fiddled" directly;<\/strong> It can be done and nothing happens, but we are supposed to have the WP admin interface and the front of the website to interact with it.<\/p>\n\n\n\n

\"User
I take this away because I don't know what it's for hale<\/figcaption><\/figure>\n\n\n\n

After all, we could almost manage a WP directly from the database<\/strong> (which is still a set of tables, like those in Excel) without using the "admin". What happens is that it is neither so comfortable nor so visual.<\/p>\n\n\n\n

\n

The WordPress database is as it is with its standard protections, and adding a plugin that accesses all of it, well what do you want me to say, it is an extra door that you have there. <\/p>\n<\/blockquote>\n\n\n\n

To access it, our hosting provides us with access data, which we can use to connect to it remotely from a program (a program is a app <\/strong>also, yes) customer MYSQL<\/strong>, for example heidi<\/strong>, Workbench <\/strong>etc And with this "program" you navigate through its pages as if it were an excel.<\/strong><\/p>\n\n\n\n

Then there is language SQL<\/strong>, which is to search and do specific things with the data, we can use it either with the previous program, or by Command line<\/strong> (hackerrrr mode), or the easy way that hosting providers always give us is, in their options panel, an online software called PHPMyAdmin<\/strong>.<\/p>\n\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n\n\n\n

He PHPMyAdmin <\/strong>It's okay, you can do things without having any idea of SQL code, such as searching and modifying values and texts, and also exporting the entire database or certain tables, to have your backups, do migrations, etc.<\/p>\n\n\n\n

What I am going to tell you - but don't tell too many people - is that there are cases in which I have come across a website in which I had to do "things", and I have needed access to the database. "bareback", and I did not have complete credentials or access to PHPMyAdmin.<\/strong><\/p>\n\n\n\n

\n
\n
\n
\"Modify
I'm going to press this postgoal and see what happens...<\/figcaption><\/figure>\n<\/div>\n\n\n\n
\n
\"Success
Come on, fix it!<\/figcaption><\/figure>\n<\/div>\n<\/div>\n<\/div>\n\n\n

Plugins to bareback the database, and the recommendation: Without fear, but with "care";<\/h2>\n\n\n

As always, there are plugins for this. Let's see, while it is true that you should not be afraid of touching the database, You have to be careful<\/strong>, as with everything, but a little more. So, before recommending plugins, I tell you that it is important that if you add one, you do what you have to do with it, and then uninstall it, or restrict it to administrator users. And of course, before doing anything, backup the entire database.<\/p>\n\n\n\n

The WordPress database "is as it is" with its standard protections, and adding a plugin that accesses all of it, well what do you want me to tell you, it is a extra door you have there<\/strong>. So it's better to simply remove the door when you leave.<\/p>\n\n\n\n

\n
WP Data Access<\/a><\/blockquote>