find how to change or modify your WordPress Login name details
I imagine that there are many reasons for the introduction session wants to change his name for WordPress, but I have before me, and I know that it is the first time in pain as you may not know where to start. It is not uncommon for a problem can not be resolved using the administration panels of WordPress, and instead of this raises some basic knowledge about the way in which the need for displaying a table MySQL.
In this example to use cPanel control panel as the core of the solution. We have access to phpMyAdmin through our Panel of accommodation and to modify the beginning of the meeting. Conversely, for the holding of a direct view of a file PHP - MySQL can be more difficult for the principal before.
< ?php
After selection of the main uses of the installation of WordPress, then wp_Users Table
Once you have found with all the names of users and the start of the session of the user. Select your own administrator must (in this case), and click the button 'SR' is located right in front of you. Then a panel appears like this:
At this time, you want to find out what is your new user name benefit and modifies while the values. Change the line that you need to change your user name friendly home private session. Play with it and wait. After the upgrade of the line, you can close the panel and introduction meeting with your new user name.
If you need help, please don't let me and knowledge will give you.
In this example to use cPanel control panel as the core of the solution. We have access to phpMyAdmin through our Panel of accommodation and to modify the beginning of the meeting. Conversely, for the holding of a direct view of a file PHP - MySQL can be more difficult for the principal before.
Modification of PHP script with WordPress
But here's the PHP code can have how to change-login.php.< ?php
// localhost = database hostname
// alex = mysql login name
// 1337 = mysql password
// DATABASE_NAME = the name of your WordPress database
// establishes connection
$estcon = mysqli_connect("localhost","alex","1337","DATABASE_NAME");
// checks if the connection is working
if (mysqli_connect_errno())
{
echo "Unable to connect to MySQL: " . mysqli_connect_error();
// prints the error if failed to connect
}
// updates the table wp_users and the row user_nicename which accounts for the login name
// the ID = admin id, which is usually going to be 1 for admin
mysqli_query($estcon,"UPDATE wp_users SET user_nicename = 'New-Login' WHERE ID = '1'");
// close the connection
mysqli_close($estcon);
?>
The latter is for you without going via phpMyAdmin, but I believe that some may use before the trains. This method is everything you need for the above script is the database and the new user name. Remember, '-' if you are using a name such as "user name last name", otherwise it will not work.WordPress Login changed with phpMyAdmin Connection
Must log in to your cPanel and navigate to the following worksheet and click the icon does not phpMyAdmin. |
| change the WordPress login with PhpMyAdmin. |
After selection of the main uses of the installation of WordPress, then wp_Users Table
 |
| Language PhpMyAdmin table |
Once you have found with all the names of users and the start of the session of the user. Select your own administrator must (in this case), and click the button 'SR' is located right in front of you. Then a panel appears like this:
 |
| WordPress PhpMyAdmin modify Connection |
At this time, you want to find out what is your new user name benefit and modifies while the values. Change the line that you need to change your user name friendly home private session. Play with it and wait. After the upgrade of the line, you can close the panel and introduction meeting with your new user name.
If you need help, please don't let me and knowledge will give you.
