./mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privi

Portal Home > Knowledgebase > Articles Database > ./mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privi

Posted by ShaolinFinest, 12-10-2008, 09:26 AM
mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privi Hi Guys, I am running ubuntu 8.10 installed mysql 5.1.30 from source. i am trying to change passwords for some of the users but I keep getting the error listed in the title. Does anyone know whats going wrong ? Code: .mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation' Last edited by ShaolinFinest : 12-10-2008 at 08:31 AM.
Posted by ub3r, 12-10-2008, 09:32 AM
You need to paste the error again, because you got cut off.
Posted by ShaolinFinest, 12-10-2008, 09:33 AM
Here you go: ./mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'
Posted by ub3r, 12-10-2008, 10:08 AM
are you passing along your mysql root password with your mysqladmin command line?
Posted by ShaolinFinest, 12-10-2008, 10:16 AM
I dont think I am. How do I do that ?
Posted by ub3r, 12-10-2008, 10:40 AM
mysqladmin -u root -p enter password after you hit enter
Posted by ShaolinFinest, 12-10-2008, 10:47 AM
I did that and then tried mysqladmin -u user1 password 123 - It still outputs the same error.
Posted by ub3r, 12-10-2008, 10:58 AM
what are you trying to do here, exactly?
Posted by ShaolinFinest, 12-10-2008, 11:18 AM
I have afew users who dont have passwords so they can access the db without the need for a password. So I tried to create a new password for them by using mysqladmin -u testuser password 123 - But that keeps spitting out the error above.
Posted by ShaolinFinest, 12-10-2008, 01:35 PM
Anyone?...
Posted by Jonathan Kinney, 12-10-2008, 02:59 PM
Perhaps it has something to do with the user you are trying to make changes with. Maybe sudo the commands to make the changes you want to make. __________________ Jonathan Kinney Data Systems Specialist Advantagecom Networks, Inc.http://www.simplywebhosting.com
Posted by ShaolinFinest, 12-10-2008, 03:39 PM
That dont work. Ok, maybe I should get some things clarified before I continue. Basically, I am trying to setup 5 hosting accounts, each account has its own webspace, and its own mysql account. What I am confused about is the mysql account. When I add a new user on my ubuntu it automatically creates a mysql account for that user. Do I need to do anything else ? One concern is that I can login to ANY account apart from root without a password i.e. mysql -u user20 mysql> Is this a security issue that someone can exploit ? If yes, how do I fix it ? I have tried the mysqladmin but it doesnt work... Last edited by ShaolinFinest : 12-10-2008 at 02:42 PM.