| View previous topic :: View next topic |
| Author |
Message |
lramos85
Tux's lil' helper
Joined: 29 Jun 2004
Posts: 141
Location: Riverside, Ca
|
 Posted: Thu Feb 09, 2006 6:31 pm Post subject: MySQL user account access |
 |
|
Hi, I want to have multiple users with differrent access, but I can't seem to log in any user to mysql. For example mysql -u fred -p does not work.
This is what i do in mysql as root:
| Code: |
mysql> grant select, insert, update, delete, index, alter, create, drop
-> on dbname
-> to fred identified by fred123;
|
and when I try to log in to mysql I get this:
| Code: |
mysql -u fred -p
Enter password:
ERROR 1045 (28000): Access denied for user 'fred'@'localhost' (using password: YES)
|
Even If I grant the user Full Privileges I can't log in as him, in both myphpadmin or just mysql.
Thanks for the help.
_________________
Registered Linux User #328996
Register Now!
Adpot an unanswered post today! |
|
| Back to top |
|
 |
ectospasm
l33t
Joined: 19 Feb 2003
Posts: 711
Location: Mobile, AL, USA
|
|
| Back to top |
|
|
jonnevers
Veteran
Joined: 02 Jan 2003
Posts: 1594
Location: Gentoo64 land
|
| Posted: Thu Feb 09, 2006 7:43 pm Post subject: Re: MySQL user account access |
|
|
| lramos85 wrote: |
Even If I grant the user Full Privileges I can't log in as him, in both myphpadmin or just mysql.
Thanks for the help. |
| Code: | mysql > grant select,insert,update,delete on somedatabase.sometable to someusername;
mysql > flush privileges;
|
this basically forces mysql to reload the privileges table.
- Jon
Last edited by jonnevers on Thu Feb 09, 2006 11:54 pm; edited 1 time in total |
|
| Back to top |
|
|
lramos85
Tux's lil' helper
Joined: 29 Jun 2004
Posts: 141
Location: Riverside, Ca
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
