Solved

Put a password on mysql of xampp

Posted on 2009-05-20
10
1,058 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
  • 4
  • 2
  • 2
  • +2
10 Comments
 
LVL 14

Assisted Solution

by:shobinsun
shobinsun earned 50 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 200 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
 
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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:ushastry
ushastry earned 50 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 200 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
The viewer will learn how to count occurrences of each item in an array.
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.

929 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now