Cambiar clave por default de mysql (passw0rd) en trixbox

Step 1) mysql -u root –p [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 clear the buffer.

Step 3) mysql> use mysql; [ENTER]
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
Step 4) mysql> update user set password = PASSWORD(‘NEW_PASSWORD’) where User = ‘asteriskuser’; [ENTER]`
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

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

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

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

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

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

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

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

Step 11) mysql> flush privileges; [ENTER]
Query OK, 0 rows affected (0.00 sec)

mysql> exit [ENTER]

One Response to “Cambiar clave por default de mysql (passw0rd) en trixbox”

  1. Brochure site hul Says:

    wonderful brochure site

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: