[Asterisk-Users] I want to move the MySQL server out to anothermachine

[Mike Holloway]

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
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
> 
>