Re: MYSQl admin

Hi, OK, this could be one of several things or a combination of them. Sounds like you have either: a) given the mysql root account (which is not the same as the system root account) a password and are not suppliying it on the command line. No matter if its the same as the system root account (which I wouldn't do), you still need to supply the password to get in if it has been set. b) you have not allowed root to log into "localhost" in the mysql.user table. Perhaps you set it to the hostname instead of localhost. c) did you run the mysql_install_db script when to set up the initial grant tables when you set up the server? This is all I can think of at the moment. Meanwhile, you _can_ reset the privileges via another route: Reload the mysql daemon with the --skip-grant-tables option which load mysql with the permissions wide open (do *not* leave it like this in production) and then update the grant tables to set a password/host that root can log in from. I strongly suggest that you don't take my word for it but read the documentation on this problem at: http://www.mysql.com/documentation/mysql/commented/manual.php?section=Ac cess_denied Hope this helps, Jamie On 22 Sep 2000, at 2:14, Dhaval Desai wrote: > Hi!!! > > Hey guys whenever I have mysql on Linux with php4 > running...under apache.. > > > Now the problem is that I can't use mysqladmin bcoz it > says access denied root@localhost > > Do u guys know how to setup mysqladmin a/c on my > system... > > Ofcourse I am the root user.... > > > Dhaval Desai > > > __________________________________________________ > Do You Yahoo!? > Send instant messages & get email alerts with Yahoo! Messenger. > http://im.yahoo.com/ > Jamie Shields Deputy Computing Officer Computer Resources Centre Faculty of Human Sciences Kingston University Phone: (0181) 547-2000 ex:2367 http://humansciences.king.ac.uk