How to Add an Admin User to the WordPress Database via MySQL
Check Out More At: WP Beginner
WordPress: Best WordPress Plugins | WordPress Tutorials
How to Add an Admin User to the WordPress Database via MySQL
| Product Image | Product Name / Primary Rating / Price | Primary Button / Description |
|---|---|---|
|
Best Wordpress Page Builder
|
|
|
|
Best WordPress Form Builder
|
|
|
|
Best WordPress Theme
|
|
|
|
Best Wordpress Cloud Hosting
|
|
|
|
Best Budget WordPress Host
|
|
|
Elementor is an amazing website builder plugin for WordPress. Elementor makes it easy to create beautiful and high converting websites yourself without having to learn code.
Gravity Forms is a WordPress plugin that creates powerful forms quickly and easily, with drag-and-drop fields, custom notifications and confirmations, and custom styling capability.
Kadence Theme is a powerful, intuitive and flexible WordPress theme that offers an expansive set of features and customization options.
It includes a robust page builder, beautiful design options, mobile-friendly responsiveness, powerful SEO tools and optimized performance for faster loading times.
It's perfect for creating stunning websites without needing to write any code.
Cloudways is a managed cloud hosting platform that simplifies cloud infrastructure deployment and management.
It provides an intuitive dashboard, automated backups and optimized stack for speedy performance. It also provides 24x7 support with multiple server locations, enabling businesses to host their applications quickly and securely.
Adding an administrator to a WordPress database can be done by adding a user with the correct privileges to the correct MySQL database.
privilege. The first step is to look at the user_login column in the wp_users table and find the user who you want to add as an administrator. After that, you need to find the user_pass column in the same table and update it with a new password. You can do this by using the UPDATE command in MySQL.
Next, you need to look at the wp_usermeta table and update the user_level column to 10. This will give the new administrator all the privileges they need.
Once you have completed these steps, you should now have a new administrator on your WordPress site.