Jump to content

Recommended Posts

Hi, im installing MySQL on this Windows 2000 computer, I am following http://www.phpfreaks.com/mysqlmanual/page/...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?

Link to comment
https://forums.phpfreaks.com/topic/1157-ihelp-installing-mysql-on-windows-2000/
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.