MySQL Forums
Forum List  »  Newbie

Re: Access Denied
Posted by: Nick Roper
Date: August 10, 2004 02:28PM

Hi Don,

the fact that you are logged into the machine as the administrator is irrelevant as far as MySQL is concerned. In order to execute a mysqladmin command you need to identify yourself as a valid MySQL user. MySQL creates some default accounts when you install it, including a root account with no password.

Try:

c:\>mysqladmin -u root -p create testdb

When prompted for a password, just hit enter.

You should really assign a password to the root account to avoid any security issues, and also create another account to use for day to day operations. See:

http://dev.mysql.com/doc/mysql/en/Post-installation.html

Nick



--
Nick Roper

Options: ReplyQuote


Subject
Written By
Posted
August 10, 2004 01:23PM
Re: Access Denied
August 10, 2004 02:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.