SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Filterscripts > Tools and Files

Reply
 
Thread Tools Display Modes
Old 19/07/2012, 08:13 AM   #1
fiki574
Gangsta
 
fiki574's Avatar
 
Join Date: Mar 2011
Location: Croatia
Posts: 850
Reputation: 169
Default MySQL DB Manager - Easily manage your MySQL databases with this remote application

MySQL DB Manager v1.0

Released on 19th July 2012.


__________________________________________________ __________________________________________________

INTRO
This application allows you to easily control your MySQL databases/tables remotely and directly from your computer! No need of connecting to your hoster, then logging in, then finding correct DB/table, etc.! Reason that I created this app is that I wanted to see my C# skills since I went to learn C++, so I gave a try at C#, and also wanted to do something usefull for this community since I was not available pretty much time (here on SAMP)! Although this app indeed does execute same functions like you would have to do in "SQL Command" at your DB hoster, I think it will be helpfull for someone in some cases! Furthermore in this post, you'll be taken through explanations on how-to do something and how to easily manage your MySQL stuff! The application itself is pretty much colorfull and explanatory, so when and if you do something wrong/right, it will say that you did something wrong/right in nice, corresponding colors!

__________________________________________________ __________________________________________________

PICTURES:
Take a look on the app!





__________________________________________________ _______________________________________________

APP COMMANDS:
There are several application commands that will make your managing easier!

help - display help message and commands list
clear - clear whole application
disconnect - disconnect from current connection, choose new connection
reconnect - reconnect to connection that you are/were already connected to
close - close application
credits - self explanatory :P
info - application info such as app version, release date, creation date, update date, etc.
coninfo - connection info (displays host, DB, etc. that you are currently connected to)
mysql - prepare app for executing MySQL commands (NOTE: you must use this before executing command itself, otherwise nothing will happen)!

Also, when executing MySQL commands, you can, but dont have to put the semi-colon ( " ; ")!

__________________________________________________ _______________________________________________

BUGS:
Well, there is currently a bug/glitch, which is: if you put spaces pretty much times in everything (spaces in host, spaces in port, spaces in username, spaces in password, spaces in database), application will still (somehow) connect even though you havent defined ANYTHING from host to database! So, dont abuse that and it'll be good!

Report more bugs, if you find any!

__________________________________________________ _______________________________________________

DOWNLOAD:

Mediafire (v1.0, application + MySQL.Data.dll) (recommended)

Mediafire (v1.0, source)

Mirrors not allowed!!

__________________________________________________ _______________________________________________

Regards,
Fiki!

P.S. I know that thread is a bit small, but eh... quality > quantity :P
__________________
fiki574 is offline   Reply With Quote
Old 19/07/2012, 08:16 AM   #2
Glint
Guest
 
Posts: n/a
Default Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application

Pretty interesting idea, i say good job .
  Reply With Quote
Old 19/07/2012, 08:17 AM   #3
Ballu Miaa
High-roller
 
Ballu Miaa's Avatar
 
Join Date: Apr 2010
Location: New Delhi,India
Posts: 1,849
Reputation: 323
Default Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application

Wow. Never seen something like this, Great work Fiki. Thanks for the release!

EDIT: Rep+6 Added!
__________________


I will take half payment as an advance to script for you.
Click here to request my Scripting Service.


Last edited by Ballu Miaa; 19/07/2012 at 11:42 AM.
Ballu Miaa is offline   Reply With Quote
Old 19/07/2012, 08:18 AM   #4
fiki574
Gangsta
 
fiki574's Avatar
 
Join Date: Mar 2011
Location: Croatia
Posts: 850
Reputation: 169
Default Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application

Quote:
Originally Posted by Lexi' View Post
Pretty interesting idea, i say good job .
Thanks!

Quote:
Originally Posted by Ballu Miaa View Post
Wow. Never seen something like this, Great work Fiki. Thanks for the release!
Thank you!
__________________
fiki574 is offline   Reply With Quote
Old 19/07/2012, 10:16 PM   #5
nGen.SoNNy
Gangsta
 
nGen.SoNNy's Avatar
 
Join Date: Sep 2009
Location: Romania
Posts: 941
Reputation: 69
Default Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application

Nice app I will use it to edit my clans)
__________________
If i've helped you, please click
nGen.SoNNy is offline   Reply With Quote
Old 20/07/2012, 12:30 PM   #6
R@f
Huge Clucker
 
Join Date: Aug 2007
Posts: 313
Reputation: 225
Default Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application

Nice work but I prefer using MySQL Workbench for managing my databases. But for a small and light tool, it's good
R@f is offline   Reply With Quote
Old 20/07/2012, 12:43 PM   #7
Niko_boy
High-roller
 
Niko_boy's Avatar
 
Join Date: Aug 2010
Location: Somewhere i belong
Posts: 1,338
Reputation: 138
Default Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application

pretty sueful release but is it same as we do in "cmd" comamnd prompt stuff cause it looks like but making things easy
__________________
nope[IMG]http://*******/1r0SOkH_[/IMG]
•••[CLOSED]LCS•Freeroam•DM•Stunts•••AutoArena [0.3z][No SkinShot][sixtytiger.com]Want a decent Attack Defend Gamemode?
N/A176.31.229.148:7830Get This! Attack-Defend(v2.3.1)
Niko_boy is offline   Reply With Quote
Old 20/07/2012, 05:14 PM   #8
fiki574
Gangsta
 
fiki574's Avatar
 
Join Date: Mar 2011
Location: Croatia
Posts: 850
Reputation: 169
Default Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application

Quote:
Originally Posted by Anonym2009 View Post
Nice app I will use it to edit my clans)
Thanks!

Quote:
Originally Posted by R@f View Post
Nice work but I prefer using MySQL Workbench for managing my databases. But for a small and light tool, it's good
Well yea, its not advanced and big as that! Anyways, thank you!

Quote:
Originally Posted by Niko_boy View Post
pretty sueful release but is it same as we do in "cmd" comamnd prompt stuff cause it looks like but making things easy
Its easier, yes, but from "cmd" you cant execute MySQL commands (or can you?)! Also, tnx!
__________________
fiki574 is offline   Reply With Quote
Old 21/07/2012, 12:11 PM   #9
ca2k
Huge Clucker
 
ca2k's Avatar
 
Join Date: Sep 2010
Posts: 329
Reputation: 106
Default Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application

Why is this better than HeidiSQL or any of the other programs which I believe are created and updated by groups of developers? You don't have any UI either. Don't take this is as an insult but I think you should invest your time into something else, you remind of another user on SA-MP forums who had great potential but just wrong directions.

e: nevermind, didn't read the intro.
__________________

pls Stop SprEAding eYe CanCer
ca2k is offline   Reply With Quote
Old 21/07/2012, 12:16 PM   #10
Lorenc_
High-roller
 
Lorenc_'s Avatar
 
Join Date: Jan 2010
Location: Australia
Posts: 3,802
Reputation: 1160
Default Re: MySQL DB Manager - Easily manage your MySQL databases with this remote application

If this were like phpmyadmin, but an application I'd be amused.. This doesn't really have much and is basic lol.
__________________
Join the best Cops And Robbers in SA-MP, today. svr.sfcnr.com:7777

Lorenc_ is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql remote host issue mati233 Scripting Help 5 01/06/2012 07:24 PM
How to connect to a mysql remote host? Sascha Help Archive 1 16/01/2011 04:56 PM
Tool to manage MySQL databases RoamPT Everything and Nothing 7 17/04/2010 12:39 PM
MySQL User restricted to one databases table? Torran Everything and Nothing 6 30/03/2010 01:20 PM


All times are GMT. The time now is 08:30 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.