- Allison Smith Hilarity
- Asterisk 1.8.0-beta3 Now Available
- Asterisk 1.6.2.11 Now Available
- Asterisk 1.4.35 Now Available
- Asterisk and Kamailio (openser) realtime integration
- The Everything Asterisk Video Collection
- Leif Madsen: Speaking at AstriCon 2010
- SIP STUN support testing
- Automated Testing Update
- Asterisk 1.8.0-beta2 Now Available
- HumBug - Pre BETA Launch Registration
- Branch Merging Changes
- Asterisk 1.8.0-beta1 is Now Available
- Asterisk 1.6.2.10 Now Available
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
