Change admin area wordpress hosting

/ Tutorials / Howtos? / How to Create a New Admin Account in WordPress via MySQL

The following guidelines undertake that your WordPress database table prefix is set to “wp_ “. If you work with something different table prefix, then change your code accordingly.

For example, if you are using “wpsqltable_ ” in spite of “wp_ “, after this the code “INSERT INTO ‘wp_users’ ” would change to “INSERT INTO ‘wpsqltable_users’ “.

Step 1: Log in to your cPanel account.

Step 2: From the main cPanel interface, find the Databases section and click on the icon entitled phpMyAdmin .

Step 3: When the first screen appears, see at the left hand sidebar and click on the database for your particular WordPress installation.

Step 4: After the database information is loaded, you can find the tab named SQL and click on it.

Step 5: Following is the code to add a new admin account named newadmin with the password password. You can change any of the content in red to fit your requirements, but leave all other data as it is.

Step 6: After replacing any data fields as per your requirement, click the Go button to execute the code.

Step 7: After the above step the screen is refreshed and you can see the message “1 row affected“ after each of the three SQL statements. This means the query has ran successfully. From here, visit your WordPress admin login panel as usual and utilize the new admin login information. You will be directed to admin interface without any trouble.

About Web Hosting UK

Founded in the year 2001 - Web Hosting UK (WHUK) has transformed itself onto a renowned name amongst the UK's elite managed hosting providers. Since inception, the determination has been to provide customers with cost effective and easy to use managed web hosting services backed by an unmatched 24/7 technical support and guaranteed server uptime. To help achieve this vision, WHUK utilise the very best in terms of technology, hardware, software as well as personnel. The belief of being a part of the client’s journey; as client’s businesses grows, so do their demands, which helps WHUK to constantly evolve and improvise. Continually improving and striving for the best for its customers is an ethic. A lot of transformation has happened since Web Hosting UK was founded, but what has remained unchanged is the ethos. The primary focus continues to be customer satisfaction through managed services, quality customer support and sustainable pricing. Find out more .

Web Hosting

Related articles

If you want to change your WordPress® site's domain name, you can use your WordPress control panel. However, you must also move your WordPress site's files to the proper location and make sure...

Changing The Site URL On the Settings->General screen in a single site installation of WordPress, there are two fields named "WordPress Address (URL)" and "Site Address (URL)". They are...

This article is to answer questions about making the move from PHP 4.x to PHP 5.x on your web hosting platform. Switching to PHP 5 To identify the version of PHP your web server is using,...

There are multiple ways to get your WordPress up and running. I will list them in order of difficulty. Managed WordPress hosting If you are not code savvy then you can choose to purchase...

I am learning this stuff myself. I am not a geek. I’m not doing this for profit and the services I’ll be tell you about are ones I have used or heard good things about by good people. I am...