{"id":202,"date":"2016-07-05T09:56:06","date_gmt":"2016-07-05T09:56:06","guid":{"rendered":"http:\/\/symbioticindia.in\/docu\/?p=202"},"modified":"2016-07-05T09:56:06","modified_gmt":"2016-07-05T09:56:06","slug":"change-sql-in-trixbox-2-6-1-passwords-step-by-step","status":"publish","type":"post","link":"http:\/\/symbioticindia.in\/docu\/2016\/07\/05\/change-sql-in-trixbox-2-6-1-passwords-step-by-step\/","title":{"rendered":"Change SQL in Trixbox 2.6.1 Passwords Step by Step"},"content":{"rendered":"
\n

http:\/\/trixbox.org\/forums\/trixbox-forums\/open-discussion\/change-default-sql-password-freepbx-version-2-6<\/h1>\n<\/div>\n
\nHow to Change MySQL passwords: Follow each step in order !<\/p>\n

Step 1) mysql -u root \u2013p [ENTER]
\nStep 2) Enter password: passw0rd [ENTER]<\/p>\n

Welcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 3743 to server version: 5.0.22<\/p>\n

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the buffer.<\/p>\n

Step 3) mysql> use mysql; [ENTER]
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n

Database changed
\nStep 4) mysql> update user set password = PASSWORD(‘NEW_PASSWORD’) where User = ‘asteriskuser’; [ENTER]`
\nQuery OK, 1 row affected (0.00 sec)
\nRows matched: 1 Changed: 1 Warnings: 0<\/p>\n

Step 5) mysql> grant all privileges on *.* to root@localhost identified by ”NEW_PASSWORD ‘ with grant option; [ENTER]
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n

Step 6) mysql> show databases; [ENTER]
\n+————————+
\n| Database |
\n+————————+
\n| information_schema |
\n| asterisk |
\n| asteriskcdrdb |
\n| asteriskrealtime |
\n| endpoints |
\n| meetme |
\n| mysql |
\n| sugarcrm |
\n| test |
\n+————————+
\n9 rows in set (0.00 sec)<\/p>\n

Step 7) mysql> grant all privileges on meetme.* to asteriskuser@localhost; [ENTER]
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n

Step 7) mysql> grant all privileges on endpoints.* to asteriskuser@localhost; [ENTER]
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n

Step 8) mysql> grant all privileges on asteriskrealtime.* to asteriskuser@localhost; [ENTER]
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n

Step 9) mysql> grant all privileges on asteriskcdrdb.* to asteriskuser@localhost; [ENTER]
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n

Step 10) mysql> grant all privileges on asterisk.* to asteriskuser@localhost; [ENTER]
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n

Step 11) mysql> flush privileges; [ENTER]
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n

mysql> exit [ENTER]
\nBye<\/p>\n

OK THIS PART IS FINISHED!<\/p>\n

Next\u2026..<\/p>\n

Change default passwords:<\/p>\n

To change the FreePBX manager pass, you need to edit two separate files and put in the new password.<\/p>\n

Step 12) nano \/etc\/asterisk\/manager.conf [ENTER]<\/p>\n

Find ‘secret = amp111’ under the [admin] section. Change ‘amp11’ to your new desired password. CTRL+X followed by ‘Y’ to save and exit.<\/p>\n

Now, we need to edit the \/etc\/amportal.conf to use our new password.<\/p>\n

Step 13) nano \/etc\/amportal.conf [ENTER]<\/p>\n

Find the line that says ‘AMPMGRPASS=amp111’ and change the ‘amp11’ to the new password you just set. CTRL+X followed by ‘Y’ to save and exit.<\/p>\n

Now we need to edit the \/etc\/cbmysql.conf<\/p>\n

Step 14) nano \/etc\/asterisk\/cbmysql.conf [ENTER]<\/p>\n

Find the line that says password=passw0rd’ and change the ‘ passw0rd’ to the new password you just set. CTRL+X followed by ‘Y’ to save and exit.<\/p>\n

Now we need to edit the \/var\/www\/html\/web-meetme\/lib\/database.php
\nStep 15) nano \/var\/www\/html\/web-meetme\/lib\/database.php [ENTER]
\nFind the line that says $password = ‘passw0rd’;’ and change the ‘passw0rd’ to the new password you just set. CTRL+X followed by ‘Y’ to save and exit.<\/p>\n

You will also need to update the password in the \/etc\/asterisk\/cdr_mysql.conf file for call detail records (cdr) and in \/etc\/asterisk\/res_mysql<\/p>\n

Step 16) nano \/etc\/asterisk\/cdr_mysql.conf [ENTER]<\/p>\n

Find the line that says ‘password=amp109’ and change the ‘amp109’ to the new password you just set. CTRL+X followed by ‘Y’ to save and exit.<\/p>\n

Step 17) nano \/etc\/asterisk\/res_mysql.conf [ENTER]<\/p>\n

Find the line that says ‘dbpass=amp109’ and change the ‘amp109’ to the new password you just set. CTRL+X followed by ‘Y’ to save and exit.<\/p>\n

Step 18) service mysqld restart [ENTER]<\/p>\n

Step 19) amportal restart [ENTER]<\/p>\n

Ready to Rock \u2018n\u2019 Roll!<\/p>\n

*** NOTE: FreePBX\/MySQL does not like having an exclamation point (!) in the password. There may be other special characters that it doesn’t like also.<\/p>\n

Document prepared by: Scott J. Arnold 09\/11\/2008 Contact: Scott@TheVOIPWiz.com
\nIAX2 Hardware at http:\/\/www.thevoipwiz.com<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

http:\/\/trixbox.org\/forums\/trixbox-forums\/open-discussion\/change-default-sql-password-freepbx-version-2-6 How to Change MySQL passwords: Follow each step in order ! Step 1) mysql -u root \u2013p [ENTER] Step 2) Enter password: passw0rd [ENTER] Welcome to the MySQL monitor. Commands end with ; or \\g. Your MySQL connection id is 3743 to server version: 5.0.22 Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to ..<\/p>\n

<\/div>\n

Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,27],"tags":[],"class_list":["post-202","post","type-post","status-publish","format-standard","hentry","category-asterisk","category-trixbox"],"_links":{"self":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/comments?post=202"}],"version-history":[{"count":1,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/202\/revisions"}],"predecessor-version":[{"id":203,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/202\/revisions\/203"}],"wp:attachment":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/media?parent=202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/categories?post=202"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/tags?post=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}