- Asterisk 1.8.9.1 Now Available
- Asterisk 10.1.1 Now Available
- Digium Creates Phones for Asterisk
- New Oracle PartnerNetwork (OPN) Specialization for MySQL Enables Partners to Showcase Expertise
- Converting multiple exten lines to using same in Asterisk dialplan
- Asterisk 1.8.8.2 and 10.0.1 Now Available (Security Release)
- AstLinux 1.01 Released
- New Release of Oracle® Database Firewall Extends Support to MySQL
- Asterisk 1.6.2.22 Now Available
- Asterisk 1.8.8.0 Now Available
- Asterisk 10.0.0 Released
- AstLinux 1.0.0 release
- Events in Europe: MySQL - News from Oracle OpenWorld and Beyond
- Astricon: Matt Jordan: Asterisk APIs
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
