bitnami@linux:~$ sudo find / -name my.cnf [sudo] password for bitnami: /opt/bitnami/mysql/my.cnf bitnami@linux:~$
注释掉这一行
[mysqladmin] user=root [mysqld] basedir=/opt/bitnami/mysql datadir=/opt/bitnami/mysql/data port=3306 socket=/opt/bitnami/mysql/tmp/mysql.sock tmpdir=/opt/bitnami/mysql/tmp max_allowed_packet=16M #bind-address=127.0.0.1 character-set-server=UTF8 collation-server=utf8_general_ci [mysqld_safe] mysqld=mysqld.bin [client] port=3306 socket=/opt/bitnami/mysql/tmp/mysql.sock default-character-set=UTF8 [manager] port=3306 socket=/opt/bitnami/mysql/tmp/mysql.sock pid-file=/opt/bitnami/mysql/tmp/manager.pid default-mysqld-path=/opt/bitnami/mysql/bin/mysqld.bin
这样就可远程访问。
$ cd /opt/bitnami
$ sudo ./ctlscript.sh restart mysql
$ /installdir/mysql/bin/mysql -u root -p -e "grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘your_root_password‘ with grant option";
如果执行完上面的命令以后还不能远程登陆，那么就可能是防火墙的问题了，请开放3306端口。
sudo ufw status
bitnami下mysql配置-包含phpMyAdmin配置
原文：http://www.cnblogs.com/xwdreamer/p/3553005.html