| View previous topic :: View next topic |
| Author |
Message |
metalgeek
n00b
Joined: 21 Oct 2002
Posts: 13
|
 Posted: Tue Jun 03, 2003 3:58 am Post subject: mysql logging in problems |
 |
|
I'm having problems logging into mysql as a certain user.
They exist in the system, and I can log on as my other user, but when I try with this one, it gives me an error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'pawprint@localhost' (Using password: YES)'
Not sure where I need to go to start troubleshooting this.
any suggestions? |
|
| Back to top |
|
 |
slartibartfasz
Veteran
Joined: 29 Oct 2002
Posts: 1462
Location: Vienna, Austria
|
| Posted: Tue Jun 03, 2003 7:26 am Post subject: |
|
|
login to a mysql shell
look at the privileges table
| Code: | use mysql;
select * from users; |
to see what permissions are granted on the user u are trying to connect with. notice that permissions in mysql are on per-machine-basis - user@somebox is not allowed to log in from localhost, only from somebox... for more details see the privilege system in the mysql manual or ask again...
_________________
To an engineer the glass is neither half full, nor half empty - it is just twice as big as it needs to be. |
|
| Back to top |
|
|
metalgeek
n00b
Joined: 21 Oct 2002
Posts: 13
|
| Posted: Tue Jun 03, 2003 2:44 pm Post subject: |
|
|
ok I get this error:
mysql> select * from users;
ERROR 1146: Table 'mysql.users' doesn't exist |
|
| Back to top |
|
|
slartibartfasz
Veteran
Joined: 29 Oct 2002
Posts: 1462
Location: Vienna, Austria
|
| Posted: Tue Jun 03, 2003 4:30 pm Post subject: |
|
|
sorry - typo, the table is called 'user' not 'users' - to see all existing tables u can 'show tables;' for more commands try 'help'  ....
_________________
To an engineer the glass is neither half full, nor half empty - it is just twice as big as it needs to be. |
|
| Back to top |
|
|
xedx
Tux's lil' helper
Joined: 23 May 2003
Posts: 93
|
| Posted: Wed Jun 04, 2003 3:30 am Post subject: Re: mysql logging in problems |
|
|
| metalgeek wrote: | I'm having problems logging into mysql as a certain user.
They exist in the system, and I can log on as my other user, but when I try with this one, it gives me an error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'pawprint@localhost' (Using password: YES)'
Not sure where I need to go to start troubleshooting this.
any suggestions? |
Just a friendly reminder, a mysql user has nothing to do with a system user. You need to manually add users for mysql.
http://www.mysql.com/doc/en/Adding_users.html
_________________
--+//+ |
|
| Back to top |
|
|
|
Networking & Security
