{"id":53294,"date":"2022-10-25T18:06:21","date_gmt":"2022-10-25T15:06:21","guid":{"rendered":"https:\/\/tuthost.ua\/faq\/how-do-i-change-the-authorization-data-of-the-opencart-administrator-user\/"},"modified":"2024-07-19T20:48:47","modified_gmt":"2024-07-19T17:48:47","slug":"kak-izmenit-dannye-avtorizatsii-ot-polzovatelya-administrator-opencart","status":"publish","type":"ht_kb","link":"https:\/\/tuthost.ua\/en\/faq\/kak-izmenit-dannye-avtorizatsii-ot-polzovatelya-administrator-opencart\/","title":{"rendered":"How do I change the authorization data of the OpenCart administrator user?"},"content":{"rendered":"\n<p>Data about users and passwords opencart stores in the database in the table <strong>user<\/strong>.<\/p>\n\n<p>Therefore, to change the password to go to the database management interface <strong>PhpMyAdmin<\/strong> and choose a database that is used in <strong>OpenCart<\/strong>.<\/p>\n\n<p>If you forget the name of the database used for the site, you can look in the file <strong>config.php<\/strong>, field<strong> DB_DATABASE<\/strong>.<\/p>\n\n<p>In <strong>PhpMyAdmin <\/strong>go to<strong>the SQL section<\/strong>:<\/p>\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/tuthost.ua\/wp-content\/uploads\/2022\/10\/image-14.png\"><img loading=\"lazy\" decoding=\"async\" width=\"745\" height=\"213\" src=\"https:\/\/tuthost.ua\/wp-content\/uploads\/2022\/10\/image-14.png\" alt=\"\" class=\"wp-image-53245\" title=\"\" srcset=\"https:\/\/tuthost.ua\/wp-content\/uploads\/2022\/10\/image-14.png 745w, https:\/\/tuthost.ua\/wp-content\/uploads\/2022\/10\/image-14-300x86.png 300w, https:\/\/tuthost.ua\/wp-content\/uploads\/2022\/10\/image-14-150x43.png 150w, https:\/\/tuthost.ua\/wp-content\/uploads\/2022\/10\/image-14-125x36.png 125w, https:\/\/tuthost.ua\/wp-content\/uploads\/2022\/10\/image-14-75x21.png 75w\" sizes=\"auto, (max-width: 745px) 100vw, 745px\" \/><\/a><\/figure>\n<p>By default <strong>OpenCart<\/strong> uses the &#8220;<strong>oc_<\/strong>&#8221; prefix and the administrator <strong>ID<\/strong> is usually set to <strong>1<\/strong>.<\/p>\n\n<p>Therefore, use the following sql command to change the password:<\/p>\n\n<pre class=\"wp-block-code\"><code>UPDATE `oc_user` SET `password` = MD5('my_secret_password') WHERE `user_id` = 1;\r<\/code><\/pre>\n\n<p>where instead of <strong>my_secret_password<\/strong> specify your new password.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data about users and passwords opencart stores in the database in the table user. Therefore, to change the password to go to the database management interface PhpMyAdmin and choose a database that is used in OpenCart. If you forget the name of the database used for the site, you can look in the file config.php,&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","ghostkit_customizer_options":"","ghostkit_custom_css":"","ghostkit_custom_js_head":"","ghostkit_custom_js_foot":"","ghostkit_typography":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"ht-kb-category":[10669],"ht-kb-tag":[],"class_list":["post-53294","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hosting-en"],"taxonomy_info":{"ht_kb_category":[{"value":10669,"label":"Hosting"}]},"featured_image_src_large":[],"author_info":{"display_name":"Denys Semeniuk","author_link":"https:\/\/tuthost.ua\/en\/author\/semden\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb\/53294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/comments?post=53294"}],"version-history":[{"count":1,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb\/53294\/revisions"}],"predecessor-version":[{"id":53304,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb\/53294\/revisions\/53304"}],"wp:attachment":[{"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/media?parent=53294"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb-category?post=53294"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/tuthost.ua\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=53294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}