Jump to content

ihelp! Installing MySQl on Windows 2000


surfskatedude

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: \'[email protected]\' (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

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.