Why Add an Admin User to the WordPress Database via MySQL?
We once ran into an issue where a user’s site was hacked, and their admin account was deleted from the database. This locked them out of their WordPress website.
We were able to help them get access to their website by creating a new admin user directly to the WordPress website. We did that using phpMyAdmin, a web-based tool that allows you to manage MySQL databases using your web browser.
If you find yourself locked out of your WordPress admin area due to hackers or simply because you forgot your password, then you can do the same.
However, you should always make a backup of your database before performing any MySQL edits. Then, once you can log back into your website, you may need to follow our beginner’s guide to fixing your hacked WordPress site.
With that being said, let’s take a look at how to add an admin user to the WordPress database via MySQL.
Adding an Admin User to the WordPress Database With phpMyAdmin
phpMyAdmin comes pre-installed with most top WordPress hosting companies. You can find it in the Databases section of your hosting account’s cPanel dashboard.
如果你已经设置了SMTP服务器 可以通过忘记密码来接收邮件恢复和重置登录密码
如果你接收不到邮件 可以在后台数据库添加新用户和密码进行登录
参考的文档：
How To Install and Secure phpMyAdmin on Ubuntu 18.04
How to Add an Admin User to the WordPress Database via MySQL
Author Rank: 10
Author's Name: 张 芷晴
User ID: 1
Number of posts published by user: 92
Key tasks include how to: Free Tier: Install WordPress on an Ubuntu Instance https://docs.oracle.com/en-us/iaas/developer-tutorials/tutorials/wp-on-ubuntu/01-summary.htm
参考 外观–》 自定义–》主页设置–》主页名 主页名 -> Setting -> CONTENT LAYOUT -> 100% Full Width The Menus Screen enables the user to create a custom menu (also known as a
» » » »
在使用云服务器的时候 一开始会有主机地区选择 有些同学可能会选择主机地区在国内 觉得自己的网站对象是国内用户 或者有些同学不是使用云服务器 是选择使用我们大家经常用的主机托管公司 主机提供商很多了 像Blue Host, Hostgator, GoDaddy等等 界面友好 不像谷歌云和阿里云这样子我们需要自己打入LINUX的指令 在选择主机地区的时候 如果你是打算搭建WordPress网站 最好主机地区不要选择在国内大陆 虽然WordPress是开源的 在国内使用访问登录没有问题 但是因为你所选择的WordPress主题或者插件可能会用到Google的产品 像Google Font, Google Map等等 或者会用到其他被禁的产品 我不知道JQuery是不是也在国内禁用 JQuery是大多数WordPress主题都会用到的JavaScript代码库 如果你的主机放在国内 你所选择的WordPress主题需要的这些的文件和程序可能拿取不到
» » » »
Introduced in 2013 and used by over 60 million websites, All-in-One WP Migration is verifiably one of WordPress’ most trusted and utilized plugins for moving websites with absolute
» » » »
When building websites, we tend to create a site locally or on a development server and then migrate the site on the client’s server when done. The All
» » » »
Create a WebsiteDesign Your FuturePower your vision with Elementor to build, manage and host stunning websites!We’ve got you covered from A-to-Z with the #1 website platform for WordPress.
» » » »
Screen Options is a fly down menu button located on the top right corner of some pages in your WordPress admin area. When clicked, Screen Options menu shows
» » » »
Alibaba Cloud is more of an International Entity subsidiary of Alibaba Group which is still in the progress of porting of all the services from Aliyun with enhancements.
» » » »
Google Cloud Platform (GCP), offered by Google, is a suite of cloud computing services that provides a series of modular cloud services including computing, data storage, data analytics,
» » » »
| 1 | Generic singular.php will be used for single post which does not have specified format for that category or post type. |
|---|---|
| 2 | If you are logged in, the post comment will only ask for post rating, comment title and message. If you are not logged in and is a visitor, the post comment will ask for more questions of your name, email, phone, country. |
| 3 | Notes:
|
| 5 | Total number of the comment will include the counting of sub-comment (second-level comment replying to top-level comment). |
| 6 | Each page will break every 3 top-level comments into pages, click Older Comments or Newer Comments to view more comments. |
| 7 | Click the close icon on the right-top corner of this section to close this instruction. |
Comment
Comment Message Box Error
Please do not use newline break key!
be the first one to write a comment.