Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Put a password on mysql of xampp

Posted on 2009-05-20
10
Medium Priority
?
1,091 Views
Last Modified: 2013-12-13
I'm running xampp on a linux server with some php applications running over MySQL.

Actually MySQL has the security disable (root password is not set). We want to change that assigning a password to root mysql user.

Can anybody show me how can I put a password for accessing mysql for enabling its security ?

Thank you very much.
0
Comment
Question by:gplana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +2
10 Comments
 
LVL 14

Assisted Solution

by:shobinsun
shobinsun earned 200 total points
ID: 24430656
Hi,

   1. Stop the mysqld daemon process.
   2. Start the mysqld daemon process with the --skip-grant-tables option.
   3. Start the mysql client with the -u root option.
   4. Execute the UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
   5. Execute the FLUSH PRIVILEGES; command.

For more about that:

http://www.mydigitallife.info/2006/06/06/change-and-reset-mysql-root-password/

0
 
LVL 8

Accepted Solution

by:
yfastud earned 800 total points
ID: 24430781
this guide is used for wampserver but should work for xampp as well, just make sure to open correct file in proper location ;)
http://blog.jlbn.net/?p=17
0
 
LVL 15

Author Comment

by:gplana
ID: 24430792
Thank you for your answer.

Hiowever, this article explains to change password in case it's forgotten. This is not my case. My case is that MySQL is installed without any security password, so I enter without putting a password.

Can I set the password just by typing some SQL statement inside mysql client ?
0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
LVL 8

Expert Comment

by:yfastud
ID: 24430793
you also might want to know how to setup db for user account as well ;)
http://blog.jlbn.net/?p=19
0
 
LVL 14

Expert Comment

by:shobinsun
ID: 24430813
Hi,

You can set the password using the same method as I have posted above(If you didnt set any).
0
 
LVL 8

Expert Comment

by:yfastud
ID: 24430837
if you address my answer, no, it's for setting up password when you first install wamp package such as wampserver, xampp, so on ;)
0
 
LVL 8

Expert Comment

by:yfastud
ID: 24430894
Quote "Can I set the password just by typing some SQL statement inside mysql client ?"
Yes, you can just as shobinsun posted but then you might have problem to use phpmyadmin to manage your db ;)
0
 
LVL 26

Assisted Solution

by:Umesh
Umesh earned 200 total points
ID: 24431837
Simply run this command and your root password would be set..  when it is prompted for password simply press enter..you new password is set..
mysqladmin -uroot -p password newpassword
 
 
Once the above step is done... for securoty reasons delete those accounts whose password is not set...

Open in new window

0
 
LVL 2

Assisted Solution

by:miyosia
miyosia earned 800 total points
ID: 24431840
if you are using xampp you can configure security through this link http://localhost/security/index.php you need to have the apache and mysql running to be able to setup security for each installed components.
0
 
LVL 15

Author Closing Comment

by:gplana
ID: 31583460
Thank you very much to all. I think miyosia and yfastud are good solutions for me, as it will not just change MySQL password, but also configure phpmyadmin with new password.

However, shobinson and ushastry solutions can be useful too for changing mysql password.

Thank you all !!!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question