- SIPit 26 - Why SIP testing is important to Asterisk and to you
- Voip Users Conference March 26th
- Attrafax t.30 and t.38 alternative now released as gpl2 and commercial license
- New patch for app_queue to show all call attempts
- Asterisk 1.4.30-rc3, 1.6.0.26-rc1, 1.6.1.18-rc1, and 1.6.2.6-rc1 Now Available
- GSoC 2010 - Calling for Project Ideas and Mentors
- Video of Mark Spencer
- Call Completion: Asterisk Component
- Audio to remote AGI server
- Asterisk iPhone: New version of AsteriskRef online
- Asterisk 1.2.40, 1.4.29.1, 1.6.0.24, 1.6.1.16, and 1.6.2.4 Now Available
- AST-2010-002: Dialplan injection vulnerability
- A2Billing 1.6 Release
- AsteriskRef Free iPhone application available on app store
Create a new MySQL User
Create a new MySQL User
GRANT ALL ON astsmb.* TO astuser@localhost IDENTIFIED BY 'password';
GRANT SELECT ON astsmb.* TO astuser@localhost IDENTIFIED BY 'password';
GRANT SELECT ON astsmb.* TO voxsrv1@'127.0.0.1' IDENTIFIED BY 'password';
On some old OS versions you may have to use this command to use the old MySQL Password encryption
SET PASSWORD FOR 'astsmb'@'localhost' = OLD_PASSWORD('password');
This is how to view MySQL Users
SHOW GRANTS FOR 'astsmb'@'127.0.0.1';
select Host,User,Password from mysql.user;
drop user astsmb;
Please replace 127.0.0.7 with your valid IP address. For MySQL security it is safer to grant access by user IP address and not to all IP addresses. Use of VPN or SSL tunnelling is the preferred option.
- Login to post comments
