Forgot to mention the step to
mysql> FLUSH PRIVILEGES;
after making changes.
-mike
Mike Holloway wrote:
If you have phpMyAdmin installed, you can simply go to the webpage, go
into the mysql database, the db table, hit the Browser tab, and clone
the line for your particular asterisk db, changing the Host to %, which
will permit any host to connect to that database (assuming proper
user/password).
If you don't have phpMyAdmin installed, install it :P
Instead, from linux shell, you can follow the instructions on that URL I
sent, something like:
# mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
where *.* is the database name (or just leave *.* for all db's) and root
is the username that you will be connecting to mysql with. The user
must already exist in the 'user' table of the mysql database. You can
see what databases and users are already defined:
mysql> SELECT * from database;
mysql> SELECT * from user;
-mike
Ronald Wiplinger wrote:
Ritesh Jalan wrote:
Have you given the access to your asterisk server in your database
server??
Thanks, you are right, ...
However, I cannot find the right way to GRANT the access. Do you have
an example for me, please?
bye
Ronald
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
