{"id":6817,"date":"2016-12-26T11:46:36","date_gmt":"2016-12-26T03:46:36","guid":{"rendered":"https:\/\/webhostinggeeks.com\/howto\/?p=6817"},"modified":"2023-06-23T13:12:54","modified_gmt":"2023-06-23T13:12:54","slug":"how-to-change-your-wordpress-username","status":"publish","type":"post","link":"https:\/\/webhostinggeeks.com\/howto\/how-to-change-your-wordpress-username\/","title":{"rendered":"How to Change your WordPress Username, Nickname and Display Name in MySQL"},"content":{"rendered":"

\"ChangeAfter you create an account log in WordPress, you may want to change your WordPress username, as appropriate or due to security reason<\/a>. However, you can not do this from the WordPress administration console.<\/p>\n

\"Change<\/p>\n

Instead, there is an easier way but rather advance for non-technical people. You can actually use phpMyAdmin to change the username manually in WordPress MySQL database or using the command line or SQL statement as below for your reference.<\/p>\n

Change your WordPress Username, Nickname and Display Name in MySQL Table<\/h3>\n

To do this, follow these steps:<\/p>\n

1. Login to your Linux VPS using root or for (share hosting), login to ssh console with your cpanel username.<\/p>\n

2. In below example, the wordporess database is wordpressdb and table is wp_users.<\/p>\n

# mysql -u root -p\r\nEnter password:\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 62547\r\nServer version: 5.5.52-MariaDB MariaDB Server\r\n\r\nCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]> use wordpressdb;\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\n<\/pre>\n
3. Print existing “user_login, user_nicename, display_name” in wp_users table.<\/p>\n
MariaDB [wordpressdb]> select user_login, user_nicename, display_name from wp_users;\r\n+------------+---------------+--------------+\r\n| user_login | user_nicename | display_name |\r\n+------------+---------------+--------------+\r\n| admin      | admin         | admin        |\r\n+------------+---------------+--------------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n
4. Update “user_login, user_nicename, display_name” in wp_users table to new prefered username, nickname and display name.<\/p>\n
MariaDB [wordpressdb]> update wp_users SET user_login = 'problogger';\r\nQuery OK, 1 row affected (0.01 sec)\r\nRows matched: 1  Changed: 1  Warnings: 0\r\n\r\nMariaDB [wordpressdb]> update wp_users SET user_nicename = 'problogger';\r\nQuery OK, 1 row affected (0.00 sec)\r\nRows matched: 1  Changed: 1  Warnings: 0\r\n\r\nMariaDB [wordpressdb]> update wp_users SET display_name = 'problogger';\r\nQuery OK, 1 row affected (0.00 sec)\r\nRows matched: 1  Changed: 1  Warnings: 0\r\n<\/pre>\n
5. Print updated “user_login, user_nicename, display_name” in wp_users table.<\/p>\n
MariaDB [wordpressdb]> select user_login, user_nicename, display_name from wp_users;\r\n+------------+---------------+--------------+\r\n| user_login | user_nicename | display_name |\r\n+------------+---------------+--------------+\r\n| problogger | problogger    | problogger   |\r\n+------------+---------------+--------------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n
I hope this article gives you some ideas and essential guidance on how to change your WordPress username, nickname and display name in MySQL table.<\/p>\n","protected":false},"excerpt":{"rendered":"
After you create an account log in WordPress, you may want to change your WordPress username, as appropriate or due to security reason. However, you can not do this from…<\/p>\n","protected":false},"author":6,"featured_media":6819,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wds_primary_category":0,"footnotes":""},"categories":[2056,1008],"tags":[1585,1933],"class_list":["post-6817","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cms","category-mysql","tag-mysql","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/6817","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/comments?post=6817"}],"version-history":[{"count":0,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/6817\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media\/6819"}],"wp:attachment":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media?parent=6817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/categories?post=6817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/tags?post=6817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}