CODEWITHSUNDEEP
mysqlpasswordsxampp
Nam G VU
Nam G VU

Reputation: 35434

How to set password for MySQL?

Installing XAMPP will set password for MySQL as blank as default.

Going for password in my.ini file doesn't work.

How can we set password for it?

Upvotes: 1

Views: 201

Answers (2)

Cyclonecode
Cyclonecode

Reputation: 30131

You should be able to change the password through the webinterface, try going to: http://localhost/security/, another way would be to run the following query from mysql:

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; 
FLUSH PRIVILEGES;

Upvotes: 2

clonelab
clonelab

Reputation: 651

Try this it may help you with your issue and offers 2 methods.

http://veerasundar.com/blog/2009/01/how-to-change-the-root-password-for-mysql-in-xampp/

Upvotes: 2

Related Questions