Good MySQL Client (Windows) |
Author: |
Message: |
leito
Senior Member
Chameleon by KeyStorm
Posts: 720 Reputation: 5
38 / / –
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?
|
|
06-30-2004 05:09 AM |
|
|
WDZ
Former Admin
Posts: 7106 Reputation: 107
– / /
Joined: Mar 2002
|
RE: Good MySQL Client (Windows)
Well, I've never tried it, but there's this: http://www.mysql.com/products/mysqlcc/
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 |
|
|
leito
Senior Member
Chameleon by KeyStorm
Posts: 720 Reputation: 5
38 / / –
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.
|
|
06-30-2004 05:34 AM |
|
|
bach_m
Veteran Member
4837 :P
Posts: 2863 Reputation: 7
37 / / –
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 |
|
|
Chris.1
Full Member
addicted to the net
Posts: 363 Reputation: 3
37 / / –
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 |
|
|
leito
Senior Member
Chameleon by KeyStorm
Posts: 720 Reputation: 5
38 / / –
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.
|
|
07-01-2004 07:17 AM |
|
|
bach_m
Veteran Member
4837 :P
Posts: 2863 Reputation: 7
37 / / –
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 |
|
|
leito
Senior Member
Chameleon by KeyStorm
Posts: 720 Reputation: 5
38 / / –
Joined: Apr 2003
|
O.P. RE: Good MySQL Client (Windows)
Can I use it from a Localhost, since my MySQL server allows remote connections?
|
|
07-02-2004 01:27 AM |
|
|
bach_m
Veteran Member
4837 :P
Posts: 2863 Reputation: 7
37 / / –
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 |
|
|
leito
Senior Member
Chameleon by KeyStorm
Posts: 720 Reputation: 5
38 / / –
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.
|
|
07-02-2004 04:33 AM |
|
|
|