What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » Good MySQL Client (Windows)

Good MySQL Client (Windows)
Author: Message:
leito
Senior Member
****

Avatar
Chameleon by KeyStorm

Posts: 720
Reputation: 5
38 / Male / –
Joined: Apr 2003
O.P. Good MySQL Client (Windows)
I work for a webpage and their hosting gave them 1 Database. I have the user name, the database name, and the host. They don't use phpMyAdmin, is there something similar that I could use from my computer, like a Windows Client?
[Image: leonelgalan.png]
06-30-2004 05:09 AM
Profile E-Mail PM Find Quote Report
WDZ
Former Admin
*****

Avatar

Posts: 7106
Reputation: 107
– / Male / Flag
Joined: Mar 2002
RE: Good MySQL Client (Windows)
Well, I've never tried it, but there's this: http://www.mysql.com/products/mysqlcc/

[Image: mycc-query.png]

quote:
MySQL Control Center (or MySQLCC) is a GUI client that works alongside the MySQL database server. Built using Trolltech's Qt application toolkit, MySQLCC makes it easy to create databases and tables, write and execute SQL queries (in a syntax-highlighting editor), examine the contents of your tables directly, and back up or fine-tune your server setup. It supports both local and remote servers, and all table types.
You might not be able to connect remotely though, because as far as I know, most MySQL servers are configured to only allow connections from localhost and/or specific clients. :-/
06-30-2004 05:22 AM
Profile PM Web Find Quote Report
leito
Senior Member
****

Avatar
Chameleon by KeyStorm

Posts: 720
Reputation: 5
38 / Male / –
Joined: Apr 2003
O.P. RE: Good MySQL Client (Windows)
I have just connect using MySQLManager and from my computer's localhost php scripts, but... nothing so easy as in phpMyAdmin.

I'll try this one, thnx WDZ!

Not to bad! I create the SQL in phpMyAdmin and just copy it! hahaha, but it's not too bad and easy to use! thnx

This post was edited on 06-30-2004 at 06:39 AM by leito.
[Image: leonelgalan.png]
06-30-2004 05:34 AM
Profile E-Mail PM Find Quote Report
bach_m
Veteran Member
*****

Avatar
4837 :P

Posts: 2863
Reputation: 7
37 / Male / –
Joined: Feb 2003
RE: Good MySQL Client (Windows)
its possible to just edit the config files of phpMyAdmin, and then upload it. thats what i use.

don't forget to delete the folder from ur server, or anyone can use it (thats bad).

I keep a copy on my desktop for whenever i need it, and just up load it.

This post was edited on 06-30-2004 at 10:56 AM by bach_m.
06-30-2004 10:50 AM
Profile E-Mail PM Web Find Quote Report
Chris.1
Full Member
***

Avatar
addicted to the net

Posts: 363
Reputation: 3
37 / Male / –
Joined: Jun 2003
RE: Good MySQL Client (Windows)
Do as bach_m said, but you should be able to password protect PHPMyAdmin (or at least use apache authentication to password the directory) so that no one else can come along and mess with your database.
06-30-2004 01:16 PM
Profile E-Mail PM Web Find Quote Report
leito
Senior Member
****

Avatar
Chameleon by KeyStorm

Posts: 720
Reputation: 5
38 / Male / –
Joined: Apr 2003
O.P. RE: Good MySQL Client (Windows)
quote:
Originally posted by bach_m

I keep a copy on my desktop for whenever i need it, and just up load it.

Can I have a copy of a modified phpMyAdmin, that way I will only have to change the host, username, password, or something similar.
[Image: leonelgalan.png]
07-01-2004 07:17 AM
Profile E-Mail PM Find Quote Report
bach_m
Veteran Member
*****

Avatar
4837 :P

Posts: 2863
Reputation: 7
37 / Male / –
Joined: Feb 2003
RE: Good MySQL Client (Windows)
all i did was just download the file from the phpMyAdmin server and change the host, username and database name in the config file, so it seems rather superfullous to send u a copy of mine.


and just a hint, delete all the languages that you don't need from the /lang/ folder. that shud save on upload time

This post was edited on 07-01-2004 at 01:41 PM by bach_m.
07-01-2004 01:40 PM
Profile E-Mail PM Web Find Quote Report
leito
Senior Member
****

Avatar
Chameleon by KeyStorm

Posts: 720
Reputation: 5
38 / Male / –
Joined: Apr 2003
O.P. RE: Good MySQL Client (Windows)
Can I use it from a Localhost, since my MySQL server allows remote connections?
[Image: leonelgalan.png]
07-02-2004 01:27 AM
Profile E-Mail PM Find Quote Report
bach_m
Veteran Member
*****

Avatar
4837 :P

Posts: 2863
Reputation: 7
37 / Male / –
Joined: Feb 2003
RE: Good MySQL Client (Windows)
maybe, but you need to run it from a PHP server, so why not just FTP it to ur main directory, and run it from there?
07-02-2004 02:06 AM
Profile E-Mail PM Web Find Quote Report
leito
Senior Member
****

Avatar
Chameleon by KeyStorm

Posts: 720
Reputation: 5
38 / Male / –
Joined: Apr 2003
O.P. RE: Good MySQL Client (Windows)
I use, apache to test my php files in my computer, I'll try that, and post the results here.
[Image: leonelgalan.png]
07-02-2004 04:33 AM
Profile E-Mail PM Find Quote Report
« Next Oldest Return to Top Next Newest »


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On