Mysql-front

[jzanzinger]

Trying to make connection to MYSQL-FRONT, an alternative to phpMyAdmin. MYSQL-FRONT requires the username to be [email protected] i.e.([email protected]). cPanel removes the periods and @ in the ip when I try to create a user name in the required form (i.e. chnages [email protected] to domain_jeff652212112). I'de like to root shell to mysql add the username. QUESTION: will this mess up the cPanel or WHM web interface? Any suggestions are greatly appreciated.

 

[Svaha]

I use mySQL- front version 2.2. I do not need to use a username in that format.

I simply configure a username in cpanel, and use that. For instance db_user might be my username.

In mySQL- front I simply enter the database name as it appears in cpanel, hostname or IP address, the username as above, password, and it connects.

MySQL-front is a great tool, it's too bad it's no longer being developed. Still the best thing out there though.

 

[jzanzinger]

Version 2.5 works diferent and requires the [email protected]_address. I have to agree the mysql front interface is remarkable. Could you possibly email version 2.2 to me. Thank you for your reply.

 

[casey]

Try here:
http://mysqlfront.venturemedia.de/index.php?act=ST&f=2&t=328

 

[jzanzinger]

Thanks for your reply's. I installed version 2.2 had same problem as before so I shelled in as root in mysql and created a new user with the domain pointing to the IP of my remote machine. Works great! I will have a problem with my remote machine on DHCP as the IP changes when the cable box is turned off. Guess I'll just have to change the IP in the mysql user table or perhaps use %. I reinstalled ver 2.5 and here's why

New features:
- Refresh host status via popup menu
- Set column widths in the Data-Tab (right click on headers)
- reimplemented "Set Filter"-Form

Fixed bugs:
- auto-refresh processlist works again
- "rename table" does not crash (some problems remain)
- connection time in status bar works even if there is more than one connection
- some problems fixed when executing querys with more than one statement or no result rows.
- can't add fields with empty fieldnames any more.