Description: Kmysqladmin is a graphical frontend for administration of mysql servers. With a buildin script editor with syntax-highlighting you can process more complex script. A script generator is in work.
It can: - Displaying and edit the contents of tables within a separate view. - export results of a query into another format (ASCII, Latex, HTML) - Edit user rights - Creating databases and tables - watching status and threads continuously - alter tables and keys - execute sql scripts - generate sql scripts from search resultsLast changelog:
0.7.2 - massive layout work - fix for build with mysql 4.1
0.7.1 - fixed build problems with various distributions and compilers. Thanks for your reports. 0.7.0 - fixed a real ugly bug: I did not handle binary data in a result set the right way all the time. - blob data (eg images and so on) can be inserted via kmysqladmin now - if blobs are saved to other fileformats them will be marked as that or if them contains images the images will be saved (as jpeg) when saving html files - textfields can be filled from external textfiles now - result set can stored as sql-script for insertion
0.6.10 - connection profiles implemented - passwords will stored in kdewallet not in rc-files - hungarian translation (from aroly Barcza - many tnx) - grant setup knows most about mysql 4.0 grants
0.6.9: - user can give an operator when inserting/modifying/searching data - layout fix for search/data edit dialog
...there is no buts. this program is good. maybe you misspelled your password the first time, and your wallet was closed when you were exitting. wallet/kmysqladmin/kde3.5.7 all work fine here.
I am using Kubuntu Breezy and tried the source rpm with:
rpm -ivh kmysql....
It seemed to go OK doing the 100% thing but I cannot seem to find the program in my menu and typing kmysqladmin at the command line doesn't work either.
Can someone point me in the right direction?
Thanks,
j
This is an awesome program! Thank you so much for all of your hard work and dedication to make such a needed gui tool for kde!
thankyou, thankyou, thankyou, thankyou!
Tim
i need a .deb for this :D
i am using 0.7.1 but i dislike the "conecpt" of windows and more windows, i prefer a workarea like MySQLFront (win32 app) this app has the power, but need direction
well, in 0.7.2 I have just one window :) Or the user may switched which kind he likes more.
deb: sorry. I don't have a running debian - not on extra computer or vmware :( I hoped that another one will make one, but....
I'll take a look around.
why?
do them have such a user-grant-wizard meanwhile?
capability to display images stored in database inline?
export search result into 4 external formats? And some stuff more I ever missed in mysqlcc
Well, may you like mysqlcc more than my software. Thats your choice. But that does not mean, that it is the BETTER choice. It is another - good - choice. And would great when you post such statetements not without a reason on the programs page. I'm realy interested in to know what is missing or wrong.
Alwin
another reason for mysqlcc is that it was replaced by mysql query browser which is a pain in the butt to compile. I spent a few hours find old gnome packages and still fail because of dumb version issues. kmysqladmin compiled with only a minor glitch.
--btw, seems like the configure script doesn't check for ssl and it eventually gives an error while compiling.
Hi! When I compiling Kmysqladmin i got errors:
::read undeclared
...
in file MultiTextInput.cpp. I added #include to MultiTextInput.h, compile it, and it's works now:). Before this I patched Kmysqladmin by settings_0_7_0.patch. After this fixes, it's compiling good on Slackware 9.0. Thx for good program, and sorry about my bad english;)
ARGS!
My failure I think.
You're using a QT without STL support, for instance that one delivered with SuSE. Right?
On Fedora and Debian the STL support and so the translation for STL strings to QString is builtin.
thinking.... I'll put a patch on my webpage next time, sorry.
Alwin
ah! this was the missing information, I don't know if Slackware compile their qt with STL support builtin but seems that you didn't it. The patch is on the download side.
In 0.7.1 I think I'll resolve it in another way so this problems never happens again.
Alwin
p.s.: why do I get the simplest tricks AFTER a release.... ;)
The latest official SlackBuild includes a "-no-stl" option... so here's the clue.
The patch didn't work, I still get similar errors :( but I'm just recompiling qt with stl support, this surely will work!
ok, you had right.
I had made it myself, eg., installed a qt lib without stl support and hopefully fixed all.
So you may download the patch again, it should be fine now (testet with qt333 without stl support)
ciao
Alwin
p.s.: and thanks for your feedback
Ok, the last patch works!
The best solution, since recompiling qt with stl means recompiling most (if not all) kde packages.
Thanks a lot, that's a nice app!
btw, I should provide a slackbuild that includes patching sources or/and a slack package. Let me know if you are interested in it (giancarlobianchi at email dot it).
Ratings & Comments
29 Comments
Hi, I'm running Opensuse 11.0 and get the following error while building this app: tom@linux:~/Desktop/kmysqladmin-0.7.2> make make all-recursive make[1]: Entering directory `/home/tom/Desktop/kmysqladmin-0.7.2' Making all in kmysqladmin make[2]: Entering directory `/home/tom/Desktop/kmysqladmin-0.7.2/kmysqladmin' Making all in toolbar make[3]: Entering directory `/home/tom/Desktop/kmysqladmin-0.7.2/kmysqladmin/too lbar' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/home/tom/Desktop/kmysqladmin-0.7.2/kmysqladmin/tool bar' Making all in helpers make[3]: Entering directory `/home/tom/Desktop/kmysqladmin-0.7.2/kmysqladmin/hel pers' source='stringlist.cpp' object='stringlist.o' libtool=no \ depfile='.deps/stringlist.Po' tmpdepfile='.deps/stringlist.TPo' \ depmode=gcc3 /bin/sh ../../admin/depcomp \ g++ -DHAVE_CONFIG_H -I. -I. -I../.. -I../.. -I/opt/kde3/include -I/usr/l ib/qt3/include -I. -I/usr/include/mysql -DQT_THREAD_SUPPORT -D_REENTRANT -Wn on-virtual-dtor -Wno-long-long -Wundef -Wall -pedantic -W -Wpointer-arith -Wwrit e-strings -ansi -D_XOPEN_SOURCE=500 -D_BSD_SOURCE -Wcast-align -Wconversion -Wch ar-subscripts -O2 -Wformat-security -Wmissing-format-attribute -fno-exceptions - fno-check-new -fno-common -fexceptions -c -o stringlist.o `test -f 'stringlist. cpp' || echo './'`stringlist.cpp In file included from stringlist.cpp:1: stringlist.h: In member function ‘__gnu_cxx::__normal_iterator<std::basic_string <char, std::char_traits<char>, std::allocator<char> >*, std::vector<std::basic_s tring<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std:: basic_string<char, std::char_traits<char>, std::allocator<char> > > > > stringli st::find_nocase(const std::string&, __gnu_cxx::__normal_iterator<std::basic_stri ng<char, std::char_traits<char>, std::allocator<char> >*, std::vector<std::basic _string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std ::basic_string<char, std::char_traits<char>, std::allocator<char> > > > >)’: stringlist.h:82: error: ‘find_if’ is not a member of ‘std’ make[3]: *** [stringlist.o] Error 1 make[3]: Leaving directory `/home/tom/Desktop/kmysqladmin-0.7.2/kmysqladmin/help ers' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/home/tom/Desktop/kmysqladmin-0.7.2/kmysqladmin' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/tom/Desktop/kmysqladmin-0.7.2' make: *** [all] Error 2 tom@linux:~/Desktop/kmysqladmin-0.7.2> Any ideas?
...but on latest kde 3.5.6 I need to enter kdewallet password 2 times to enter mysql and one time to exit....
...there is no buts. this program is good. maybe you misspelled your password the first time, and your wallet was closed when you were exitting. wallet/kmysqladmin/kde3.5.7 all work fine here.
backup/restore also for big DB would be a good feature for Your app
What is wrong with phpMyAdmin?
I am using Kubuntu Breezy and tried the source rpm with: rpm -ivh kmysql.... It seemed to go OK doing the 100% thing but I cannot seem to find the program in my menu and typing kmysqladmin at the command line doesn't work either. Can someone point me in the right direction? Thanks, j
This is an awesome program! Thank you so much for all of your hard work and dedication to make such a needed gui tool for kde! thankyou, thankyou, thankyou, thankyou! Tim
A SlackWare 10.2 TGZ Package with SlackBuild script is ready to download!! http://www.slacky.it http://www.slacky.it/index.php?option=com_remository&Itemid=29&func=fileinfo&filecatid=778&parent=category
i need a .deb for this :D i am using 0.7.1 but i dislike the "conecpt" of windows and more windows, i prefer a workarea like MySQLFront (win32 app) this app has the power, but need direction
well, in 0.7.2 I have just one window :) Or the user may switched which kind he likes more. deb: sorry. I don't have a running debian - not on extra computer or vmware :( I hoped that another one will make one, but.... I'll take a look around.
i think mysqlcc -- published by mysql.com -- is a better choice...
why? do them have such a user-grant-wizard meanwhile? capability to display images stored in database inline? export search result into 4 external formats? And some stuff more I ever missed in mysqlcc Well, may you like mysqlcc more than my software. Thats your choice. But that does not mean, that it is the BETTER choice. It is another - good - choice. And would great when you post such statetements not without a reason on the programs page. I'm realy interested in to know what is missing or wrong. Alwin
another reason for mysqlcc is that it was replaced by mysql query browser which is a pain in the butt to compile. I spent a few hours find old gnome packages and still fail because of dumb version issues. kmysqladmin compiled with only a minor glitch. --btw, seems like the configure script doesn't check for ssl and it eventually gives an error while compiling.
Hi everybody, if somebody wants a suse 9.1 rpm, I made one, it is in www.osite.com.ar/rpm/kmysqladmin-0.7.0-1.i586.rpm bye
Hi! When I compiling Kmysqladmin i got errors: ::read undeclared ... in file MultiTextInput.cpp. I added #include to MultiTextInput.h, compile it, and it's works now:). Before this I patched Kmysqladmin by settings_0_7_0.patch. After this fixes, it's compiling good on Slackware 9.0. Thx for good program, and sorry about my bad english;)
gentoo ebuild please.
I get this error: settings.cpp: In static member function `static KWallet::Wallet* CSettings::openWallet(const std::string&)': settings.cpp:146: error: no matching function for call to `KWallet::Wallet:: setFolder(const std::basic_string&)' /opt/kde/include/kwallet.h:233: error: candidates are: virtual bool KWallet::Wallet::setFolder(const QString&) settings.cpp: In member function `void CSettings::SaveLastLogin(std::basic_string, std::basic_string, std::basic_string, std::basic_string)': settings.cpp:164: error: no match for 'operator=' in ' (&login_values)->QMap::operator[] [with Key = QString, T = QString]((&QString("last_user"))) = user' /usr/lib/qt/include/qstring.h:413: error: candidates are: QString& QString::operator=(const QString&) /usr/lib/qt/include/qstring.h:414: error: QString& QString::operator=(const char*) /usr/lib/qt/include/qstring.h:418: error: QString& QString::operator=(const QCString&) /usr/lib/qt/include/qstring.h:868: error: QString& QString::operator=(QChar) /usr/lib/qt/include/qstring.h:871: error: QString& QString::operator=(char) settings.cpp:165: error: no match for 'operator=' in ' (&login_values)->QMap::operator[] [with Key = QString, T = QString]((&QString("last_host"))) = host' /usr/lib/qt/include/qstring.h:413: error: candidates are: QString& QString::operator=(const QString&) /usr/lib/qt/include/qstring.h:414: error: QString& QString::operator=(const char*) /usr/lib/qt/include/qstring.h:418: error: QString& QString::operator=(const QCString&) /usr/lib/qt/include/qstring.h:868: error: QString& QString::operator=(QChar) /usr/lib/qt/include/qstring.h:871: error: QString& QString::operator=(char) settings.cpp:166: error: no match for 'operator=' in ' (&login_values)->QMap::operator[] [with Key = QString, T = QString]((&QString("last_port"))) = port' /usr/lib/qt/include/qstring.h:413: error: candidates are: QString& QString::operator=(const QString&) /usr/lib/qt/include/qstring.h:414: error: QString& QString::operator=(const char*) /usr/lib/qt/include/qstring.h:418: error: QString& QString::operator=(const QCString&) /usr/lib/qt/include/qstring.h:868: error: QString& QString::operator=(QChar) /usr/lib/qt/include/qstring.h:871: error: QString& QString::operator=(char) settings.cpp:167: error: no match for 'operator=' in ' (&login_values)->QMap::operator[] [with Key = QString, T = QString]((&QString("last_password"))) = pass' /usr/lib/qt/include/qstring.h:413: error: candidates are: QString& QString::operator=(const QString&) /usr/lib/qt/include/qstring.h:414: error: QString& QString::operator=(const char*) /usr/lib/qt/include/qstring.h:418: error: QString& QString::operator=(const QCString&) /usr/lib/qt/include/qstring.h:868: error: QString& QString::operator=(QChar) /usr/lib/qt/include/qstring.h:871: error: QString& QString::operator=(char) Any hint?
ARGS! My failure I think. You're using a QT without STL support, for instance that one delivered with SuSE. Right? On Fedora and Debian the STL support and so the translation for STL strings to QString is builtin. thinking.... I'll put a patch on my webpage next time, sorry. Alwin
Actually, I'm building on Slack 10, with Qt 3.3.3 compiled by myself. I should recompile it, or wait for the patch. Thank you, anyway.
ah! this was the missing information, I don't know if Slackware compile their qt with STL support builtin but seems that you didn't it. The patch is on the download side. In 0.7.1 I think I'll resolve it in another way so this problems never happens again. Alwin p.s.: why do I get the simplest tricks AFTER a release.... ;)
The latest official SlackBuild includes a "-no-stl" option... so here's the clue. The patch didn't work, I still get similar errors :( but I'm just recompiling qt with stl support, this surely will work!
ok, you had right. I had made it myself, eg., installed a qt lib without stl support and hopefully fixed all. So you may download the patch again, it should be fine now (testet with qt333 without stl support) ciao Alwin p.s.: and thanks for your feedback
Ok, the last patch works! The best solution, since recompiling qt with stl means recompiling most (if not all) kde packages. Thanks a lot, that's a nice app!
btw, I should provide a slackbuild that includes patching sources or/and a slack package. Let me know if you are interested in it (giancarlobianchi at email dot it).
I had uploaded a patch: http://www.alwins-world.de/programs/download/kmysqladmin/settings_0_7_0.patch this should resolve your problems. If you're realy building for SuSE - can you make RPMs for it and let me know? tnx alwin