- Events in Europe: MySQL - News from Oracle OpenWorld and Beyond
- Astricon: Matt Jordan: Asterisk APIs
- Astricon: Shaun Ruffell: DAHDI
- Astricon: Matt Jordan: Asterisk Developer Tools
- Astricon: Jason Parker: Asterisk Module API
- David Vossell: Asterisk Architecture
- AstriCon: Paul Belanger: Introduction to Asterisk Development
- AstriDevCon final session
- AstriDevCon afternoon session - Asterisk 11
- AstriDevCon Test Framework
- AstriDevCon second morning session
- MySQL.com Security Notice
- Oracle Enhances MySQL Installer and High Availability for Windows
- Asterisk 1.8.6.0 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
