Kmysqladmin
Database
Score 62%
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 results
Last changelog:

13 years ago

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

tommycw1

9 years ago

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?

Report

mattepiu

10 years ago

...but on latest kde 3.5.6 I need to enter kdewallet password 2 times to enter mysql and one time to exit....

Report

sodamnmad

10 years ago

...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.

Report

polrus

11 years ago

backup/restore also for big DB would be a good feature for Your app

Report

medworthy

11 years ago

What is wrong with phpMyAdmin?

Report

jonnymccullagh

11 years ago

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

Report

timcharper

11 years ago

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

Report

gohanz

11 years ago

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

Report

fabiomb

12 years ago

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

Report

C

alwin

12 years ago

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.

Report

tux86

12 years ago

i think mysqlcc -- published by mysql.com -- is a better choice...

Report

C

alwin

12 years ago

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

Report

sodamnmad

11 years ago

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.

Report

maxxs

12 years ago

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

Report

kbe

12 years ago

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;)

Report

somekool

12 years ago

gentoo ebuild please.

Report

SWaN

13 years ago

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?

Report

C

alwin

13 years ago

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

Report

SWaN

13 years ago

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.

Report

C

alwin

13 years ago

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.... ;)

Report

SWaN

13 years ago

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!

Report

C

alwin

13 years ago

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

Report

SWaN

13 years ago

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!

Report

SWaN

13 years ago

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).

Report

C

alwin

13 years ago

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

Report

13 years ago

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

product-maker 44 77

File (click to download) Version Description Filetype Packagetype License Downloads Date Filesize OCS-Install DL
Details
version
0.7.2
updated Jul 08 2005
added Feb 03 2004
downloads today
0
page views today 1