LATEST NEWS: What Features Do You Want To See On Paid Hosting?
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
+ Helping Webmasters - Website Support and Webmaster Forum
|-+ T35 Hosting Support
| |-+ Paid Hosting cPanel & Fantastico Support
| | |-+ MySQL users and permissions
Pages: [1]
« previous next »
Send this topic | Print
Topic: MySQL users and permissions  (Read 3903 times)
« on: February 02, 2005, 06:53:10 PM »
00 Agent Kid
Guest
For some reason, the cPanel will not let me add any MySQL users with anything less than all permissions. No matter what I do, it'll always say "Granted all permissions on MySQL database to MySQL user ." And that's exactly what it does. I have my scripts set up in a way that if I can't set specific permissions, than it leaves open security holes.

And why we're at it, why can't I just edit the users in PHPMyAdmin? It would be a lot easier that way.
Report to moderator   Logged

 
« Reply #1 on: February 02, 2005, 09:42:36 PM »
Alex Melen Offline
President / Founder
Administrator
Addict

View Profile WWW 		*****
Posts: 2,178
You can't edit users in phpmyadmin because it would create security issues in cpanel. As for the mysql issue, I have reported it to cpanel and they should be coming out with a fix for it sometime soon.
Report to moderator   Logged
www.T35.com - Free Web Hosting
www.AlexMelen.com - About Me
« Reply #2 on: April 29, 2005, 06:43:49 PM »
00 Agent Kid
Guest
Well, it's been a couple of months, and the problem is still occuring. Have you progressed any further in fixing this problem?
Report to moderator   Logged
« Reply #3 on: April 30, 2005, 07:19:14 PM »
Alex Melen Offline
President / Founder
Administrator
Addict

View Profile WWW 		*****
Posts: 2,178
From the looks of things you will never be able to manage mysql users in phpmyadmin... you need to use cpanel. It creates to many security problems to do it the way you want, and thus cpanel would never agree to release a version with it.
Report to moderator   Logged
www.T35.com - Free Web Hosting
www.AlexMelen.com - About Me
« Reply #4 on: May 01, 2005, 10:42:47 AM »
00 Agent Kid
Guest
I was referring to the problem with cPanel automatically granting the users All Privileges regardless of what permissions I want them to have, not the phpMyAdmin issue.
Report to moderator   Logged
« Reply #5 on: May 01, 2005, 07:26:34 PM »
Alex Melen Offline
President / Founder
Administrator
Addict

View Profile WWW 		*****
Posts: 2,178
From my attempts to contact cpanel and phpmyadmin... there was nothing that they could do. You can try contacting them yourself... I don't have any special "host" privilidges when contacting them... but as an FYI, they haven't been very helpfull so far and i don't think the issue will be resolved in the near future.
Report to moderator   Logged
www.T35.com - Free Web Hosting
www.AlexMelen.com - About Me
« Reply #6 on: July 03, 2005, 10:41:28 AM »
00 Agent Kid
Guest
I found a workaround for this problem. If you delete all of the privileges of the user while making sure the user still exists, you can then add the privileges induvidually. It still says "Granted All Privileges...." when you do it, but it works correctly nonetheless.
Report to moderator   Logged
 
Pages: [1]
Send this topic | Print
« previous next »
Jump to:  

Powered by SMF | SMF © 2006-2008, Simple Machines LLC