It means you're connecting to the server as an annonymous user.
If you have a username to connect to the server, run the following
query:
mysql> show grants for your_user_name@localhost;
and it will show you all the priveleges that you have for specific
databases and tables. That's the best way to figure out what happened.
If it says that you do not have ALTER privelege for 'dbname', then
update the grants for yourself, or ask your ISP to do that if you
dont have su access
--
"The road to hell is paved with melting snowballs."
-- Larry Wall in <[EMAIL PROTECTED]>
Carl Troein wrote:
CT:
CT: Steve Osborne writes:
CT:
CT: > ERROR 2000: Access denied for user: '@localhost' to database 'dbname'
CT: >
CT: > Can anyone give me some insight as to why I cannot do this? Do I require
CT: > root privileges to do this (right now I am logged in as a user, as this
CT: > remote server is an ISP)?
CT:
CT: What unix user you are is irrelevant. However, what MySQL user
CT: you are is not. You should read the chapters on privileges and
CT: security, and ask your ISP to do so too. You shouldn't be able
CT: to connect as the anonymous user.
CT:
CT: BTW, your clock is off by ~65 minutes.
CT:
CT: //C
CT:
CT:
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
