UbuntuServerUbuntu
i've been playing around with ubuntu 14.04 since it came out a few weeks (days?) ago. one thing i needed was to be able to use phpmyadmin to access multiple development mysql servers. since i haven't found very good documentation on this, i wanted to post it here so that it hopefully helps others.
Note that I won't help with MySQL privileges here. I'll assume you just want the same setup as I have: 1 LAMP server, several MySQL servers with remote root access. You'll have to verify that you can actually access the MySQL servers remotely as root.
So first, install phpMyAdmin:
sudo apt-get updatesudo apt-get install phpmyadmin
It'll ask you a bunch of questions. Since the MySQL servers are remote, just say "No" to any database question. For the web server question, choose the one you used (most probably Apache).
Next, just copy the sample configuration Ubuntu includes for multiple hosts:
立即学习“PHP免费学习笔记（深入）”；
sudo cp /usr/share/doc/phpmyadmin/examples/config.manyhosts.inc.php /etc/phpmyadmin/conf.d
That will copy the file into /etc/phpmyadmin/conf.d/ which I assume won't be blown away by an Ubuntu phpMyAdmin update. Then edit the file and change the $hosts array to whatever your servers' hostnames or IP addresses are.
$hosts = array ("db01.example.com","db02.example.com",);
These will be listed in a dropdown box below the Username/Password fields.
That's it! Since I setup my development MySQL servers without a root password, I added the following before the last brace:
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
You should follow me onTwitter.
PHP怎么学习？PHP怎么入门？PHP在哪学？PHP怎么学才快？不用担心，这里为大家提供了PHP速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
974
收藏
取消收藏
