i just want to know if exists a php script where i
1 - setup a mysql connection ( host,user,password )
2 - visually select databases i want to alter
3 - set sql statements ( from .sql file or text on web form )
4 - execute specified sql statements on all selected databases
problem to solve :: i have +100 databases with same structure on same server, executing a simple "ALTER TABLE" on each database is a boring / time-loss task, iam currently doing this manually with phpMyAdmin, but i know exists a better way.
I think you are referring to the phpmyadmin
I'm not sure what pre-fab script could exist, but you are looking at a one-shot thing, are you not? Why not just write a script?
It would look something like this (pseudo code)
$yourDatabases = array($database1, $databas2, ....);
foreach($yourDatabases as $database){
connect($database);
query("your alter table");
close($database);
}