breeze351
asked on
MySql Utilites For Server
I'm looking for a utility that I can install on a server to manage MySql .
What do you recomend?
It's a client site and I'm thinking that I need the following installed:
1. MySql
2. PHP
3. FTP access
4. Some type of GUI MySql management
Is there anything I'm missing?
What do you recomend?
It's a client site and I'm thinking that I need the following installed:
1. MySql
2. PHP
3. FTP access
4. Some type of GUI MySql management
Is there anything I'm missing?
1. You need MySQL - thats the database you will be looking after.
2. You only need PHP if the util you will manage it with uses PHP.
3. No... no...no.... Do not add FTP. It is insecure. If you really need the ability to transfer files then use a secure system like SSH or SFTP.
4. This is the real part of the question.... which util.
The most popular tool is phpmyadmin : http://www.phpmyadmin.net
There are many others - but this one is simple and does just about everything.
Oh and you will need PHP and a web server (like apache) installed to get this to work.
2. You only need PHP if the util you will manage it with uses PHP.
3. No... no...no.... Do not add FTP. It is insecure. If you really need the ability to transfer files then use a secure system like SSH or SFTP.
4. This is the real part of the question.... which util.
The most popular tool is phpmyadmin : http://www.phpmyadmin.net
There are many others - but this one is simple and does just about everything.
Oh and you will need PHP and a web server (like apache) installed to get this to work.
The simplest one to use/connect is Adminer.
Single file, drop it in your html folder, put credentials and you're done.
HTH,
Dan
Single file, drop it in your html folder, put credentials and you're done.
HTH,
Dan
Thnx Dan, didnt know about this one, looks very easy....
You're welcome Patrick. I actually found about it here on E-E :)
Coolest place to grow smart :)
I'd suggest not using a server-side application at all if you can help it. Use a client-side GUI like HeidiSQL instead (http://www.heidisql.com/).
Server-side scripts like phpMyAdmin and Adminer get so popular that people put them in common places and when a bug or exploit or vulnerability is discovered, robots go out and search common places for those scripts and can automatically and quickly gain access to your server (usually before you take the time to install an upgraded / fixed version).
My web access logs for every site I've ever maintained are filled with automated attempts to hit common installs for scripts like phpMyAdmin, so it's not a question of "if" - it's "when". A client-side utility will help reduce that risk as long as you put good security practices in place with MySQL.
Server-side scripts like phpMyAdmin and Adminer get so popular that people put them in common places and when a bug or exploit or vulnerability is discovered, robots go out and search common places for those scripts and can automatically and quickly gain access to your server (usually before you take the time to install an upgraded / fixed version).
My web access logs for every site I've ever maintained are filled with automated attempts to hit common installs for scripts like phpMyAdmin, so it's not a question of "if" - it's "when". A client-side utility will help reduce that risk as long as you put good security practices in place with MySQL.
I agree with gr8gonzo, that's the best way to manage your MySQL databases, if your host allows it.
You would need the webhost to allow connections to MySQL from places other than localhost or (much better) to allow you to establish an SSH tunnel through which you connect with Heidisql or another client.
HTH,
Dan
You would need the webhost to allow connections to MySQL from places other than localhost or (much better) to allow you to establish an SSH tunnel through which you connect with Heidisql or another client.
HTH,
Dan
ASKER
All your comments are helpful. How can I forward these to my partner?
The client is clueless and we have to tell him what to do.
Glenn
The client is clueless and we have to tell him what to do.
Glenn
If I may suggest something, don't try to handhold a clueless client through administrative tasks if you can help it. Even though I'm confident in my own grip and skills, I still wouldn't try to guide a 2 year old through cutting a block of wood with a table saw. I'm assuming your partner is not your client, so I would just tell your partner to check this thread?
ASKER
The question was "How can I send your responses to my partner".
Have you ever worked with a client with 2 partners? We are dealing with an outfit that has 6! Plus we have a guy who thinks he knows everything about computers.
I need to write this up and send it in.
Have you ever worked with a client with 2 partners? We are dealing with an outfit that has 6! Plus we have a guy who thinks he knows everything about computers.
I need to write this up and send it in.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have a look here for some options.
5. Apache