Category: Database

phpmyadmin access problem and change server from URL

I was having issues with one of the phpmyadmin setups. The first server defined in the config file was not accessible and the theme that I was using was not allowing me to change the server from the first page. This resulted in a state where I was not able to access phpmyadmin in any way. I could not connect to any of the servers. And thus had to hack my way in to phpmyadmin to find out how to connect to other servers from URL. And here is my finding:

http://server/phpmyadmin/index.php?server=1

In the above, replace server with your server address/IP. and also the number in the end with the server index in you phpmyadmin config file.

Enhanced by Zemanta

gqlplus – sqlplus with readline (tab completion)

Tab completion is something which is missing in the sqlplus and if you have lot of tables with long names or lot of columns then it is sufficiently┬á difficult to type them ­čÖé

Here is a solution for this problem. Download and install gqlplus. gqlplus is a replcement for sqlplus which supports completion for commands/tablenames and column names. Quite useful.

Oracle SQL*Plus
Oracle SQL*Plus (Photo credit: Manuel Cernuda)
Enhanced by Zemanta

tora installation on Fedora 17.

Here are the previous links on Tora:

Tora on F16

Tora on Fedora

And if you are interested in installing from source then you can always use this link:
http://blog.amit-agarwal.com/2012/02/06/tora-fedora-16-mysql-oracle/

 

And if you are interested in just installing it then you can always do:

rpm -ivh "http://amit-agarwal.co.in/mystuff/tora-2.1.3-1.fc17.i686.rpm"
Enhanced by Zemanta