Rumah > pangkalan data > tutorial mysql > Ubuntu phpMyAdmin and Multiple Servers_MySQL

Ubuntu phpMyAdmin and Multiple Servers_MySQL

WBOY
Lepaskan: 2016-06-01 13:16:43
asal
1042 orang telah melayarinya

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.

Install phpMyAdmin

So first, install phpMyAdmin:

sudo apt-get updatesudo apt-get install phpmyadmin
Salin selepas log masuk

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).

Copy and Configure

Next, just copy the sample configuration Ubuntu includes for multiple hosts:

sudo cp /usr/share/doc/phpmyadmin/examples/config.manyhosts.inc.php /etc/phpmyadmin/conf.d
Salin selepas log masuk

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",
Salin selepas log masuk

);

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;
Salin selepas log masuk

You should follow me onTwitter.

sumber:php.cn
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Tutorial Popular
Lagi>
Muat turun terkini
Lagi>
kesan web
Kod sumber laman web
Bahan laman web
Templat hujung hadapan