Hey again,
I know you all are probably getting pretty sick my MySQL questions, and probably my questions in general :-\. But I think the end is in sight for them for a little while. I was wondering if there is a GUI out there that is free and relatively easy to use for MySQL Admining, i.e. adding users and things like that. Also if anyone out there can give me some good pointers to either a good tutorial or some other refferance source for MySQL Admining, besides the MySQL manual (I find it a little too hard to understand :-[).
The reason for this is that I have the MySQL server running now as some of you have probably read about already. Now I need to add some users so that I can start actually using MySQL and hopefully then PHP. But I want a user that can create and delete their own databases, basically normal user rights, I just don't know what normal is for MySQL. I mean in Linux a user can do whatever they want with their own files, I want that in MySQL also. In linux a user can create almost whatever they want in the space allotted to them, would be nice in MySQL. Maybe I'm just thinking to much about it and it is already handled by the two together. But if anyone can give me some insight to these issues that would be great, thanx.
TIA
Sorry for the rant/long post
Hello,
There are quite a few good mysql front-ends on MySQL's website. I like a tool called "phpMyAdmin". It requires a web server with php support like Apache+mod_php. I'm kinda new to databases and that tool really helped me out. I also tried a tool called MyCC. It's a gui that runs locally and I thought it was ok. I found it on mysql's website. My vote goes to phpMyAdmin.
HTH,
Stix
I bought a really nice O'Reilly book at barnes and nobles for like $30 that is great for figuring out MySQL. It focuses on multioplatform lessons, so the CLI is stressed. But that may help you the most. The favorite tool you find for Linux may not work in AIX or Solaris. But the CLI commands are almost all the same.
[quote author=Izan Seth link=board=4;threadid=5430;start=0#52553 date=1035515193]
Hey again,
I know you all are probably getting pretty sick my MySQL questions, and probably my questions in general :-\
The reason for this is that I have the MySQL server running now as some of you have probably read about already. Now I need to add some users so that I can start actually using MySQL and hopefully then PHP. But I want a user that can create and delete their own databases, basically normal user rights, I just don't know what normal is for MySQL. I mean in Linux a user can do whatever they want with their own files, I want that in MySQL also. In linux a user can create almost whatever they want in the space allotted to them, would be nice in MySQL. Maybe I'm just thinking to much about it and it is already handled by the two together. But if anyone can give me some insight to these issues that would be great, thanx.
TIA
Sorry for the rant/long post
[/quote]
You could always (if your running apache) install webmin it has a Mysql configuration tab.
Ras
I just did that.. I like it!! I think it will work
Posting Permissions
Reply With Quote
Bookmarks