一、错误:在我error: 'Access denied for user 'root'@'localhost' (using password: NO)'
root@PovodoIptv:/usr/local/src/freepbx# mysqladmin -u root create asterisk
mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using password: NO)'
解决办法:
1、/etc/init.d/mysql stop
2、mysqld_safe --skip-grant-tables &
使用OK,成功创建
二、错误:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql> GRANT ALL PRIVILEGES ON asterisk.* TO asteriskuser@localhost IDENTIFIED BY '${ASTERISK_DB_PW}';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
解决办法:
mysql> flush privileges;