Jump to content


Photo

ihelp! Installing MySQl on Windows 2000


  • Please log in to reply
No replies to this topic

#1 surfskatedude

surfskatedude
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 12 October 2003 - 10:04 PM

Hi, im installing MySQL on this Windows 2000 computer, I am following http://www.phpfreaks...Installing.html i am stuck at section
2.6.2.3 Running MySQL on Windows
It state:
////////////////////////////////
The default privileges on Windows give all local users full privileges to all databases without specifying a password. To make MySQL more secure, you should set a password for all users and remove the row in the mysql.user table that has Host=\'localhost\' and User=\'\'.

You should also add a password for the root user. The following example starts by removing the anonymous user that has all privileges, then sets a root user password:

C:> C:mysqlbinmysql mysql mysql> DELETE FROM user WHERE Host=\'localhost\' AND User=\'\'; mysql> QUIT C:> C:mysqlbinmysqladmin reload C:> C:mysqlbinmysqladmin -u root password your_password
After you\'ve set the password, if you want to shut down the mysqld server, you can do so using this command:

C:> mysqladmin --user=root --password=your_password shutdown

///////////////////////////////////////

I followed the steps and recieved the following error:
C:> C:mysqlbinmysqladmin --user=root --password=my_pass shutdown
C:mysqlbinmysqladmin: connect to server at \'localhost\' failed
error: \'Access denied for user: \'root@127.0.0.1\' (Using password: YES)\'

CAn any one help?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users