{"id":2753,"date":"2021-12-26T09:06:02","date_gmt":"2021-12-26T17:06:02","guid":{"rendered":"https:\/\/192.168.1.30\/wordpress\/?p=2753"},"modified":"2021-12-26T10:28:16","modified_gmt":"2021-12-26T18:28:16","slug":"update-mariadb-phpmyadmin-pw","status":"publish","type":"post","link":"https:\/\/spiffynasty.com\/blahblahblah\/update-mariadb-phpmyadmin-pw\/","title":{"rendered":"Update MariaDB + PhpMyAdmin PW"},"content":{"rendered":"

UserAccounts – root\/localhost user – edit privileges<\/p>\n

\"image-20211226075719051\"<\/p>\n

 <\/p>\n

Hit Change Password – <\/p>\n

\"image-20211226075856971\"<\/p>\n

 <\/p>\n

Update Password<\/p>\n

\"image-20211226075928864\"<\/p>\n

 <\/p>\n

Changes root for mariaDB and phpmyadmin – so relogin<\/p>\n

 <\/p>\n

+++++++++++++++++++++++++++++<\/p>\n

 <\/p>\n

 <\/p>\n

https:\/\/amigotechnotes.wordpress.com\/2016\/06\/20\/change-default-password-for-mysqlmariadb-and-phpmyadmin-on-nas\/<\/a><\/p>\n

Change Default Password for MySQL\/MariaDB and phpMyAdmin on NAS<\/h3>\n

2016\/06\/20<\/a> Amigo<\/a> How-To<\/a>, Information<\/a>Asustor<\/a>, MariaDB<\/a>, MySQL<\/a>, NAS<\/a>, password<\/a>, phpMyAdmin<\/a>, QNAP<\/a>, Synology<\/a><\/p>\n

 <\/p>\n

I always need to look for the default password for MariaDB<\/a> and phpMyAdmin<\/a> in my NAS. There is no hint at all. Some even change the rules after upgrade. Therefore, I write a note here and share to save your time. This page would be continuously maintained.<\/p>\n

 <\/p>\n

Asustor<\/h3>\n

You don\u2019t need to install MariaDB<\/a> which is already build-in in ADM<\/a>. Open Services<\/strong> \u2192 MariaDB S*<\/strong>*erver, select <\/strong>\u201cEnable MariaDB server\u201d, and click <\/strong>\u201cApply\u201d** to launch.<\/p>\n

If your application and MariaDB<\/a> run on the same machine, there is no need to select \u201cEnable MariaDB remote access\u201d<\/strong>. More detail, please read Using NAS as your Database Server<\/a>.<\/p>\n

About phpMyAdmin<\/a>, you need to register an Asustor ID<\/strong> in Settings<\/strong> \u2192 Registration<\/strong>. Then to install it from App Central<\/strong> first. In 2016\/6\/19, the phpMyAdmin<\/a> is 4.0.1.<\/p>\n

Default<\/h4>\n
\n\n\n\n\n\n\n
 <\/th>\nADM 2.6.1 R5h3<\/strong><\/th>\n <\/th>\n<\/tr>\n<\/thead>\n
MySQL<\/strong><\/td>\nroot\/admin<\/td>\n <\/td>\n<\/tr>\n
phpMyAdmin<\/strong><\/td>\nroot\/admin<\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n

Reset MySQL root Password in ADM 2.6.1<\/h4>\n

\"ResetReset MySQL in ADM<\/p>\n

Open Services \u2192 *MariaDB S*<\/em>*erver*<\/em><\/strong>, click \u201cReset Password\u201d<\/strong> then \u201cOK\u201d<\/strong> to confirm. It will remind you the password for MySQL<\/a> has been changed into default \u201cadmin\u201d<\/strong>.<\/p>\n

Change Password for MariaDB and phpMyAdmin in ADM 2.6.1<\/h4>\n[\"Edit]\n[<\/p>\n

(https:\/\/amigotechnotes.files.wordpress.com\/2016\/06\/edit-user-privileges-in-phpmyadmin-4-0-1.png)Edit<\/a> user privileges in phpMyAdmin 4.0.1<\/p>\n

There is no build-in tools to customize MariaDB<\/a>\u2018s password. You will need phpMyAdmin<\/a>. Login and click on \u201cUsers\u201d<\/strong> tab. Click the \u201cEdit privileges\u201d<\/strong> which is next to root user at localhost.<\/p>\n[\"Change]\n

 <\/p>\n[(https:\/\/amigotechnotes.files.wordpress.com\/2016\/06\/change-user-password-in-phpmyadmin-470-1.png)Change<\/a> user password in phpMyAdmin 4.0.1<\/p>\n

 <\/p>\n

\"Change<\/p>\n

Scroll down until \u201cChange password\u201d<\/strong> section, provide your new password in these fields. Then press \u201cGo\u201d<\/strong> which is on lower right in the same section to execute.<\/p>\n

Once MariaDB<\/a>\u2018s password has been changed, phpMyAdmin<\/a> is changed to the same new password.<\/p>\n

If you want change the authentication from cookie<\/strong> to http<\/strong> or config<\/strong>, you may copy from config.sample.inc.php<\/strong> to config.inc.php<\/strong> which is located in \/share\/Web\/phpMyAdmin<\/strong>. Then edit it manually. Auth types<\/a> and Cookie authentication options<\/a> provides detail description.<\/p>\n

 <\/p>\n

 <\/p>\n

\n\n\n\n\n\n
How to reconfigure the password of root account in MariaDB<\/strong><\/th>\n<\/tr>\n<\/thead>\n
How to reconfigure the password of root account in MariaDB
================================================================<\/p>\n

1. Go to ADM\\Services\\MariaDB Server to stop the MariaDB service <\/p>\n

2. Use ssh to login into the NAS by "root" account <\/p>\n

3. Run the mysql service without permission:
root@AS7004T# mysqld_safe –skip-grant-tables –skip-networking & <\/p>\n

4. Login into the mysql by root root@AS7004T#mysql -u root
Below is what you will see in the console: <\/p>\n

Welcome to the MariaDB monitor. Commands end with ; or \\g. Your MariaDB connection id is 2 Server version: 10.0.28-MariaDB Source distribution Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement. <\/p>\n

5. Flush the privileges =>
MariaDB [(none)]> FLUSH PRIVILEGES; <\/p>\n

6. Alter the passwords:
Example: =>
We set the pass as admin for root
MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'admin';
MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('admin');
MariaDB [(none)]> UPDATE mysql.user SET authentication_string = PASSWORD('admin') WHERE User = 'root' AND Host = 'localhost'; <\/p>\n

7. Go to ADM\\Services\\MariaDB to enable the MariaDB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n

 <\/p>\n

QNAP<\/h3>\n

You don\u2019t need to install MySQL<\/a> which is already build-in in QTS<\/a>. Open Control Panel<\/strong> \u2192 Applications<\/strong> \u2192 SQL server<\/strong>, select \u201cEnable SQL server\u201d<\/strong>, and click \u201cApply\u201d<\/strong> to launch.<\/p>\n

If your application and MySQL<\/a> run on the same machine, there is no need to select \u201cEnable TCP\/IP networking\u201d<\/strong>. More detail, please read Using NAS as your Database Server<\/a>.<\/p>\n

About phpMyAdmin<\/a>, you need to install it from App Center<\/strong> first. In 2016\/6\/19, the phpMyAdmin<\/a> is 4.2.3.<\/p>\n

Default<\/h4>\n
\n\n\n\n\n\n\n
 <\/th>\nQTS 4.2<\/strong><\/th>\n <\/th>\n<\/tr>\n<\/thead>\n
MySQL<\/strong><\/td>\nroot\/admin<\/td>\n <\/td>\n<\/tr>\n
phpMyAdmin<\/strong><\/td>\nroot\/admin<\/td>\n <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n

Reset MySQL root Password in QTS 4.2<\/h4>\n

\"ResetReset MySQL in QTS<\/p>\n

Open Control Panel<\/strong> \u2192 Applications<\/strong> \u2192 SQL server<\/strong>, click \u201cReset Root Password\u201d<\/strong> then \u201cApply\u201d<\/strong> to confirm. It will remind you the password for MySQL<\/a> has been changed into default \u201cadmin\u201d<\/strong>.<\/p>\n

Change Password for MySQL and phpMyAdmin in QTS 4.2<\/h4>\n

\"EditEdit user privileges in phpMyAdmin 4.2.3<\/p>\n

There is no build-in tools to customize MySQL<\/a>\u2018s password. You will need phpMyAdmin<\/a>. Login and click on \u201cUsers\u201d<\/strong> tab. Click the \u201cEdit privileges\u201d<\/strong> which is next to root user at localhost.<\/p>\n

\"ChangeChange user password in phpMyAdmin 4.2.3<\/p>\n

Scroll down until \u201cChange password\u201d<\/strong> section, provide your new password in these fields. Then press \u201cGo\u201d<\/strong> which is on lower right in the same section to execute.<\/p>\n

Once MySQL<\/a>\u2018s password has been changed, phpMyAdmin<\/a> is changed to the same new password.<\/p>\n

If you want change the authentication from cookie<\/strong> to http<\/strong> or config<\/strong>, you may manually edit config.inc.php<\/strong> which is located in \/share\/HDA_DATA\/.qpkg\/phpMyAdmin\/phpMyAdmin<\/strong> or \/share\/Web\/phpMyAdmin<\/strong>. Auth types<\/a> and Cookie authentication options<\/a> provides detail description.<\/p>\n

Synology<\/h3>\n

You have to install both MariaDB<\/a> and phpMyAdmin<\/a> from Package Center<\/strong>. In 2016\/6\/19, the phpMyAdmin<\/a> is 4.6.2.<\/p>\n

Default<\/h4>\n
\n\n\n\n\n\n\n
 <\/th>\nDSM 5.2<\/strong><\/th>\nDSM 6.0<\/strong><\/th>\n<\/tr>\n<\/thead>\n
MySQL<\/strong><\/td>\nroot\/[empty] * Password is empty aka null string.<\/td>\nroot\/[admin password] * Same as admin<\/td>\n<\/tr>\n
phpMyAdmin<\/strong><\/td>\nroot\/[empty] * Password is empty aka null string.<\/td>\nroot\/[admin password] * Same as admin<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n

Reset MariaDB root Password in DSM 6.0<\/h4>\n

\"MariaDBMariaDB Dialog in DSM 6.0<\/p>\n

Click on MariaDB<\/a> icon to launch above configuration dialog. Then click \u201cChange MariaDB password\u201d<\/strong> to pop-up \u201cLog in to MariaDB\u201d<\/strong> dialog.<\/p>\n

For password reset, ignore the \u201cMariaDB password\u201d<\/strong> field and click \u201cReset MariaDB Password\u201d<\/strong>. It will be rest to empty aka null string.<\/p>\n

Change Password for MySQL and phpMyAdmin in DSM 6.0<\/h4>\n

* Use build-in tool to customize password for both. phpMyAdmin<\/a> will destroy DSM<\/a>\u2018s mechanism. *<\/strong><\/em><\/p>\n

Click on MariaDB<\/a> icon to launch above configuration dialog. Then click \u201cChange MariaDB password\u201d<\/strong> to pop-up \u201cLog in to MariaDB\u201d<\/strong> dialog.<\/p>\n

For password customization, provide your password in \u201cMariaDB password\u201d<\/strong> and click \u201cOK\u201d<\/strong>. A new dialog will pop-up for new password for root.<\/p>\n

Once MariaDB<\/a>\u2018s password has been changed, phpMyAdmin<\/a> is changed to the same new password.<\/p>\n

Reference<\/h3>\n
    \n
  1. Asustor<\/a><\/li>\n
  2. Asustor ADM<\/a><\/li>\n
  3. Asustor: Support Center: How do I configure MySQL? What is the default password for MySQL? If I forget admin password for MySQL, how should I do?<\/a><\/li>\n
  4. Asustor: Support Center: What is the default username and password for phpMyAdmin?<\/a><\/li>\n
  5. Julien Nicole Blog: Synology : Installing phpMyAdmin<\/a><\/li>\n
  6. Julien Nicole Blog: Synology : Installing MariaDB<\/a><\/li>\n
  7. MariaDB<\/a><\/li>\n
  8. MySQL<\/a><\/li>\n
  9. phpMyAdmin<\/a><\/li>\n
  10. phpMyAdmin: Docs: Cookie authentication options<\/a><\/li>\n
  11. phpMyAdmin: Wiki: Auth types<\/a><\/li>\n
  12. QNAP: How do I reset or change a root password for MySQL?<\/a><\/li>\n
  13. QNAP: QTS<\/a><\/li>\n
  14. Synology: DSM<\/a><\/li>\n
  15. Using NAS as your Database Server<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    UserAccounts – root\/localhost user – edit privileges   Hit Change Password –   Update Password   Changes root for mariaDB and phpmyadmin – so relogin   +++++++++++++++++++++++++++++     https:\/\/amigotechnotes.wordpress.com\/2016\/06\/20\/change-default-password-for-mysqlmariadb-and-phpmyadmin-on-nas\/ Change Default Password for MySQL\/MariaDB and phpMyAdmin on NAS 2016\/06\/20 Amigo How-To, InformationAsustor, MariaDB, MySQL, NAS, password, phpMyAdmin, QNAP, Synology   I always need to look for the default password for MariaDB and phpMyAdmin in my NAS. There is no hint at all. Some even change the rules after upgrade. Therefore, I write a note here and share to save your time. This page would be continuously maintained.   Asustor You don\u2019t need to install MariaDB which is already build-in in ADM. Open Services \u2192 MariaDB S**erver, select \u201cEnable MariaDB server\u201d, and click \u201cApply\u201d** to launch. If your application and MariaDB run on the same machine, there is no need to select \u201cEnable MariaDB remote access\u201d. More detail, please read Using NAS as your Database […]<\/p>\n","protected":false},"author":1,"featured_media":2874,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[65,27],"tags":[],"class_list":["post-2753","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-frontpage","category-nas"],"_links":{"self":[{"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/posts\/2753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/comments?post=2753"}],"version-history":[{"count":4,"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/posts\/2753\/revisions"}],"predecessor-version":[{"id":2793,"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/posts\/2753\/revisions\/2793"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/media\/2874"}],"wp:attachment":[{"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/media?parent=2753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/categories?post=2753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spiffynasty.com\/blahblahblah\/wp-json\/wp\/v2\/tags?post=2753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}