Mysql password,how to set ?

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

Mysql password,how to set ?

Postby linkking » 17. March 2004 12:23

Hi !
I have installed "xampp" on my XP system and it works fine, but how do I
make/set the Mysql password ?
In the manual it says the following, but I cant make head and tails out of it:

"MySQL starts with standard values for the user id and the password. The preset
user id is "root", the password is "" (= no password). To access MySQL via PHP
with the preset values, you'll have to use the following syntax:
mysql_connect("localhost","root","")"


and in the faq section it said the following:

"In the \xampp\mysql\bin directory enter into the console:
mysqladmin -u root password secret
"

What is the name of this console, there are many exe's in that folder ?
Could someone please clarify this I would be very happy :D
Thanks
linkking
 
Posts: 3
Joined: 17. March 2004 12:04

Postby Roach » 18. March 2004 18:47

you can also do a sql-query to set your root-password:

SET PASSWORD FOR root=PASSWORD('your_new_password');
Roach
 
Posts: 34
Joined: 18. March 2004 13:41

Postby linkking » 19. March 2004 12:49

Ok thanks, but what I am wondering is what application do I use
to communicate with Mysql to set the password ?, is it the XP command console(dos prompt) or....?
When you wrote "you can also do a sql-query", what is the name of the
tool youre using to type that in ?

:oops: Newbie man :oops:
linkking
 
Posts: 3
Joined: 17. March 2004 12:04

Postby Wiedmann » 19. March 2004 13:33

What is the name of this console

it is the XP command console(dos prompt):
dosprompt>cd \xampp\mysql\bin
dosprompt>mysql -u root mysql
mysql> SET PASSWORD FOR root=PASSWORD('new_passwort');

(After that. You must change your settings for phpmyadmin.)
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Roach » 19. March 2004 14:26

linkking wrote:What is the name of the
tool youre using to type that in ?

:oops: Newbie man :oops:


you can you use the PhpMyAdmin to send the mysql-query
Roach
 
Posts: 34
Joined: 18. March 2004 13:41

Postby linkking » 20. March 2004 11:36

Ok, thanks for your help ! :D
linkking
 
Posts: 3
Joined: 17. March 2004 12:04

Postby Roach » 20. March 2004 16:37

you're welcome
Roach
 
Posts: 34
Joined: 18. March 2004 13:41


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 126 guests