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

[Mike Holloway]

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
>> 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
>>
>>
> _______________________________________________
> 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
> 
>