Jump to content

Adminer


diogo
 Share

Recommended Posts

http://www.adminer.org/ is a small php file to manage SQL databases

I received this on Smashing Magazine newsletter and decided to try it because of all those PhpMyadmin securiy concerns. It's very easy to use, so i decided to install it on the server, inside my PW install. I droped the PHP file on the templates folder, created a new template, and a page with this template without Guest access. Works great! And I have two layers of security, the PW admin login, and the DB login.

Just wanted to share ;)

  • Like 1
Link to comment
Share on other sites

  • 2 weeks later...
  • 1 year later...
  • 3 weeks later...

MarcC, thanks a lot for the link to SQL Buddy! I already knew about Adminer and used it sometimes, but SQL Buddy looks much more appealing and is very quick and easy to use, too.

I think both of them would make a really nice backend module.

  • Like 1
Link to comment
Share on other sites

  • 2 years later...

Old thread I know. I tried to use Adminer (both as a template file and a process module)  but all I get is as shown below; no text links shown, just some numbers I don't understand  :( . Google doesn't help, except for one answered question about the same problem on their forums. Was wondering if any of you has encountered this problem? Thanks.

post-894-0-97823900-1446994479_thumb.png

Link to comment
Share on other sites

Disregard this thread. I'm using adminer outside the admin now. They must have changed something in the code that made this trick not work anymore. Still prefer it to phpMyAdmin, though.

Link to comment
Share on other sites

Thanks.

So is your installation web accessible to everyone then? I'd like to avoid that. I looked for alternatives but SQL buddy has been discontinued for a while and as for http://mywebsql.net/ , it has a class Session that collides with ProcessWire's :-). I think I will just use a locally installed MySQL client that can access a remote database via SSH.

Edited by kongondo
Link to comment
Share on other sites

Thanks guys. In the end I went with Horst's suggestion, HeidiSQL. This is installed on my PC and I'm connected securely to my remote server via an SSH tunnel. OK, next, how to mount my server locally with write access so I can edit my files locally using my favourite text editor :-)

https://www.digitalocean.com/community/tutorials/how-to-use-sshfs-to-mount-remote-file-systems-over-ssh

Something like this maybe?

Link to comment
Share on other sites

@MuchDev, yeah, thanks. I've tried it for the last couple of hours and it would intermittently hang. I am now using SFTP where I am the owner of the files in public_html. I can edit remote files using my local ST3. So, it's all sorted, thanks.

  • Like 1
Link to comment
Share on other sites

  • 2 months later...
 Share

×
×
  • Create New...