•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 425,935 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,613 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 643 | Replies: 3
 |
•
•
Join Date: Aug 2006
Posts: 999
Reputation: 
Rep Power: 4
Solved Threads: 1
Posting Shark
I am trying to maintain a MySQL db which is required for business usage. I recently ran into a problem where one of our programs would blow up with an SQL error; taking a look at the error message, the program description, and the database in question reveals that the program is trying to update some rows of the table without having the correct privileges for the user/password identification required to run the program.
I have looked at the only MySQL text I currently have on hand. It mentions the grant and revoke statements, but from what I can tell, 'grant' creates a new user. I need to change the permissions on an old user, and what little I've been able to find on the topic does not indicate how this would be done. Does anyone have any suggestions to offer?
Thank you for your consideration.
I have looked at the only MySQL text I currently have on hand. It mentions the grant and revoke statements, but from what I can tell, 'grant' creates a new user. I need to change the permissions on an old user, and what little I've been able to find on the topic does not indicate how this would be done. Does anyone have any suggestions to offer?
Thank you for your consideration.
"No trees were harmed in the production of this post. However, several electrons were severely inconvenienced."
Kumquat.
Kumquat.
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 268
cant you use a GUI tool like phpmyadmin?
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
james.bennet1@ntlworld.com
•
•
Join Date: Aug 2006
Posts: 999
Reputation:
Rep Power: 4
Solved Threads: 1
Posting Shark
Remote machine. At the moment, my only access is through putty.
"No trees were harmed in the production of this post. However, several electrons were severely inconvenienced."
Kumquat.
Kumquat.
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 268
hmm so no GUI or web based tools then.
Here is code for changing the root password. I believe you could modify the syntax to change permissions.
Here is code for changing the root password. I believe you could modify the syntax to change permissions.
mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
mysql> FLUSH PRIVILEGES;
Last edited by jbennet : May 22nd, 2007 at 4:30 pm.
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
james.bennet1@ntlworld.com
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- question about connecting odbc to sql through php script (PHP)
- Help me get rid of hot offers (Viruses, Spyware and other Nasties)
- IE6 not working for certain users on XP home (Web Browsers)
- Can't delete a folder (Windows NT / 2000 / XP / 2003)
- ATTN: VMWare Users (*nix Software)
Other Threads in the MySQL Forum
- Previous Thread: Sort MySQL results...
- Next Thread: Drop user error - suggestions?
