MySQL databses and usernames/passwords

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL databses and usernames/passwords

Postby fogga » 21. September 2006 11:46

Everytime I install a script that needs database access, how do I setup one up to use a different password?

Also when changing my main MySQL username where od I change it? I did have a file open yesterday with some info like username/auth type/password but I cannot remember where that was.
fogga
 
Posts: 16
Joined: 28. December 2005 15:10

Re: MySQL databses and usernames/passwords

Postby Izzy » 21. September 2006 12:09

fogga wrote:Everytime I install a script that needs database access, how do I setup one up to use a different password?

Also when changing my main MySQL username where od I change it? I did have a file open yesterday with some info like username/auth type/password but I cannot remember where that was.

Use phpMyAdmin for setting up your databases and in phpMyAdmin the Privileges menu item will allow you to set a new user with a password for that user. You then give that user privileges to the database you want.
http://localhost/phpmyadmin

If you search the forum I have done a few posts with a detailed how-to set up databases and user/pass for each database. Can't remember the actual posts but they are not too far back.

Your main mySQL password for user root is set using the Security menu in the main XAMPP Welcome pages.
Then select this link from the security page:
http://localhost/security/xamppsecurity.php
to get to the Security console MySQL & XAMPP directory protection.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 66 guests