Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.

0
votes
1answer
26 views

Clients with empty username are not receiving request new password email

I am looking after a old site from a client and a lot of users dont have username. I had setup in woocommerce "When creating an account, automatically generate a username from the customer's email ...
1
vote
1answer
31 views

Delete all post meta except featured image Using SQL

Please I just migrated my site and I found out that wp_postmeta consumes most of my cpu resources, Is the any Sql code to Delete all post meta except the featured image. I dont want to Use wp ...
0
votes
0answers
18 views

Mapping DNS with the IP in my server

I got a domain and I administer it through Cloudflare, and I have my server (a virtual machine with ubuntu that I control through SSH) with wordpress installed, when I write the IP of my server in the ...
0
votes
0answers
11 views

Why can't I use Kanjis on permalink? [duplicate]

I've already read the 'What topics can I ask about here?' section but I'm still not sure if I can ask this type of question here, so here it goes. I'm starting a blog about the Japanese language. I ...
0
votes
1answer
23 views

submit form data to wordpress existing database table using my plugin

i have created a plugin for wordpress to sbmit form dtails to wordpress database. I created a table in cpanel phpmyadmin called 'wp_in_booking'. im trying to send the form data, but it can not get ...
0
votes
1answer
33 views

Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working

So interestingly, I moved my main plugin file into a folder within the plugin directory. Where before the register_activation_hook worked perfectly well, it now does not work; however, the ...
0
votes
0answers
9 views

Emojis getting converted to “?”

Emojis in posts and comments on a 500+ posts blog get converted automatically into single question marks in irregular and untraceable intervals. The respective tables wp_comments and wp_posts are ...
0
votes
0answers
27 views

duplicate wordpress site on same bdd

I have only one bdd with 2 wordpress sites : first with _wp suffix second with _wp2 suffix. For the url : mydomain/site1 mydomain/site2 Now i need to duplicate the site2 as site3 (mydomain/site3) ...
0
votes
1answer
29 views

WooCommerce categories do not show in Backend

I have created categories for Woocommerce via phpmyadmin. Including three tables: term_taxonomy, termmeta, terms. And then go to wp-admin/edit-tags.php?taxonomy=product_cat&post_type=product, it ...
1
vote
1answer
145 views

Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?

I'm looking to mass remove or clear the default attribute for variable products in Woocommerce. Is there an easy way to mass clear this value? If not, would you be able to direct me on where I can ...
0
votes
0answers
126 views

Set stock status thru SQL EVENT

I would like to update my stock status thru SQL. Every night my products stock is updating by cron. Unfortunately stock status is not updating and many products with 0 stock are "in stock". So I ...
0
votes
2answers
26 views

WP CLI can't delete plugin related table

I have installed a plugin following wp plugin install ... CLI command and then activate through CLI command its working properly. But problem is that when I deactivate then delete the plugin the table ...
1
vote
0answers
39 views

Wordpress Database Huge wp_usermeta Table

I have a wordpress site with over than 700,000 users. Each user adds more than 20 rows to the wp_usermeta table ! this is causing very slow queries and the website started to crash, login failure and ...
0
votes
1answer
34 views

Can't update WordFence Options, clear data manually

I ran across this problem today. Found enough bits on Stack Overflow to finally get me there, but figured I'd post a coherent answer to my question. Problem: I can't save changes in WordFence, and ...
1
vote
1answer
202 views

Update slug (URL) of pending posts via phpMyAdmin

I need to remove/delete slug of posts on pending via phpMyAdmin. Most of posts on pending have slug/URL which is different from their post title, deleting post slug/URL will force WP to generate new ...
0
votes
1answer
384 views

Export Yoast Keywords from MySQL/phpMyAdmin

I'd like to export all focus keywords from Yoast, as we're moving platforms to Craft CMS and using a similar tool, Ethercreative's SEO tool. I'd love a good query to pull these from the database, ...
0
votes
1answer
56 views

AWS Bitnami Wordpress - SELECT command denied to user

I'm using Amazon Web Services (AWS) Wordpress which uses Bitnami. I've created a test template, wrote a SELECT statement to test pulling data from the database, uploaded the template, selected the ...
1
vote
2answers
127 views

How to replace values in Wordpress DB using phpMyAdmin

I am trying to save a value in a cg_option row/field using phpmyadmin, however data is not stored correctly and when loaded again after saving, only part of data appears. Do I need to use a conversion ...
0
votes
0answers
118 views

An SQL query to find orphaned image attachments and their meta

This is for people who are good with MySQL queries. I'm using phpMyAdmin locally to try to optimize an old WordPress & Woocommerce site which has gone through a couple of iterations over the years....
0
votes
1answer
43 views

Change Custom Post Type to Post + Category

I have a rather difficult problem, I have a news site and I used a custom template with custom post-types for each "category" and now I want to change the template, but I can not change the posts for ...
0
votes
0answers
94 views

Wordpress + Google Cloud Platform

I have deployed a Wordpress site on Google Cloud's compute engine environment. I tried to access PHPmyAdmin using my IP address (xxx.xxx.xxx.xx/phpmyadmin) but the page keeps returning: Not Found ...
0
votes
1answer
948 views

Connection refused on locahost after importing database?

I'm using Wordpress Instant for my development environment. It's a portable dev environment that allows me to run a local wp install off a usb, so it's portable and I can take it from one computer to ...
0
votes
0answers
59 views

Adding wordpress posts using phpmyadmin

I am trying to add wordpress posts exported from phpmyadmin into a site that already has wordpress posts. The process would work fine if the site I am trying to upload the sql file to was a brand ...
0
votes
0answers
56 views

Passing Username/password from Payment Gateway to Wordpress Database by PHP Script

Our payment gateway allows for sending data from approved payment form to any php script. So I would like to create simple php script which reads data from CCBill's approved payment form and create ...
1
vote
2answers
70 views

Delete Wordpress posts from URL list sql query

Is it possible to delete a huge number of wordpress posts through SQL query using phpmyadmin by using a permalink list of posts that I want to delete ?
0
votes
3answers
72 views

header background color changed after drop & import database in phpmyadmin

This is what I did in phpmyadmin. Export DB in .sql format Drop all tables Import the exported DB The database should be same, but the website looks weird as below... how come...? Before (black ...
0
votes
1answer
394 views

Unable to install and upload theme due to php.ini file [closed]

Issues with uploading my theme to localhost using WAMP Server on Windows 7 Home version. I've changed the limit to 635mb in the php.ini. However, there seems to be TWO php.ini files. These are ...
0
votes
1answer
31 views

How to periodically roll back WordPress to a fixed point in time?

I have a demo WordPress site that showcases a plugin I created. The plugin lets users interact with content from the front-end and could potentially result in a nightmare of content bloat over time. I'...
0
votes
1answer
27 views

Users table association with users_metadata table appears broken

I noticed an issue after deploying a custom theme build to a Go Daddy Managed WordPress installation (client's request, RIP) wherein users created by the admin account in the WP back-end weren't ...
0
votes
3answers
91 views

lost all the links in WordPress after changing hosting

I am moving my wordpress website from one hosting to another. i moved my file(from filesmanager) correctly i export database from phpmyadmin to new host phpmyadmin Home page working fine (http://...
1
vote
1answer
276 views

Adding user data to an existing user_id

I'm using phpMyAdmin to add some new user records to the existing users within a WordPress database. The database is for a WordPress Multisite network. I had to migrate my old WP site to the new site,...
0
votes
1answer
105 views

403 Forbidden Localhost Wamp Apache Php

I’m completely new to wordpress/website design and I’m following a tutorial on youtube about creating custom themes. I’ve set up a website in localhost and I’m using permalinks to navigate to pages in ...
0
votes
1answer
122 views

How to retrieve user data based on role using SQL?

I need to retrieve user data from SQL database and I have managed to do it with the SQL code given below: SELECT wpu6_users.display_name AS n_user_display_name, t1.meta_value AS ...
0
votes
1answer
58 views

I want to create a 300 multi-site wordpress network using subdomains

This is the network on this site and i have two multi-sites apart from the main one, what i want to know that, can i create this many multi-sites, without the network crashing or having too much ...
0
votes
1answer
778 views

“#1067 - Invalid default value for 'post_date'” when trying to reset AI after backup

I've restored my Wordpress database from an sql backup. However, in doing so, all of the tables have lost auto increment. When I try to add it back in with this sql ALTER TABLE `mercury_posts` ...
0
votes
1answer
81 views

I can not access my local PhpMyAdmin control panel

I have created a local WordPress (WP) website on my computer using the limited edition of DesktopServer. I then used FileZilla to download the WP files along with the associated database. Now I cannot ...
2
votes
1answer
37 views

Why am I unable to login to Dashboard after adding myself to admin via phpMyAdmin?

So I have added myself as an admin via following the instructions on this site: http://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/ I have done this ...
0
votes
1answer
193 views

Changing Wordpress author name in database

I originally begun my wordpress site using a psudonym. Over the past few years I have been attributing my own name to all articles and have had the author name options switched off. Now I'm changing ...
1
vote
0answers
15 views

Lamp stack not supporting phpmyadmin? [closed]

I have install lamp stack + word-press in my Ubuntu 16.04, in that apache2 , word-press is running but when i try to run phpmyadmin is not running i need to create new database so how to run ...
0
votes
2answers
2k views

Wordpress redirects to old login after migration

I've followed all the steps for migrating my existing wordpress site to another server. However, when I try to login to the migrated site, it keeps redirecting me to the old one, despite whether I use ...
1
vote
1answer
290 views

Set meta_key and meta_value for all registered user in wordpress using sql query [closed]

I am trying to add meta_key and meta_value for the all already registered user in my database via phpmyadmin. I want: meta_key = is_activated and meta_value = 1 Thanks,
1
vote
0answers
12 views

import posts with dutch/special letters

I am importing posts from a csv file using the plugin Really Simple CSV Importer. I am uploading some posts in dutch language. The plugin uploads all the posts nicely but fails for the post which has ...
0
votes
1answer
193 views

Changing a Child theme's name on MAMP localhost

I would like to change the child-theme name on my localhost (MAMP) set up for a project I'm working on. Obviously changing the folder name is easy enough, as is changing the child-theme's name in the ...
0
votes
2answers
693 views

How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?

My WordPress site got hacked and the WP Admin user account password was changed by the hacker. This essentially locked the user out of his admin dashboard. It is best (for situations like this) to ...
0
votes
1answer
224 views

Editing mysql tables/database with wordpress or other app/cms

I have a particular use case which i am not sure is common or suitable to wordpress. I have built a website without using wordpress using html css javascript and have it connected to a custom mysql ...
0
votes
1answer
730 views

Changing the entire permalink

I have a plugin that creates a custom post. I want to change the permalink from: https://[site name]/lesson/lesson-1/ To: https://[site name]/learn/lesson1.php Through the wp admin interface, I can ...
1
vote
1answer
28 views

Will changing the folder name two directories above a fresh wordpress installation break the site?

I have a client who would like two Wordpress installs on his LAMP stack. The thing is he forgot to give me the directory names that he wants them on. So as per standard LAMP stack each site will be /...
2
votes
3answers
306 views

How to Move Local Singlesite Database to Remote Multsite Database?

I'm fairly new to Wordpress and I'm a little confuse on how to take the database from my local server and replace it with the one on the server on a Wordpress multisite. I've replace database before ...
-1
votes
1answer
1k views

cannot log in to the mysql server (wamp and wordpress)

When I run wamp (an offline webserver) and then run phpmyadmin, user and password are asked. I haven't used wamp in a while so basically I forgot user and password. I've followed some guides like this ...
0
votes
0answers
524 views

Restore widget text from database

I am about giving up here and resorting to individually recreating each of 50+ sidebars. The text in all widgets has been lost from the database. I have a backup of slightly over a week ago, but in ...