The password starts off as nothing
i.e on a fresh install you dont need to supply a password,
another way to set the password is to log in
, switch to the mysql database (use mysql;) and issue these queries
UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
FLUSH PRIVILEGES;
-----Original Message-----
From: Oscar E. Salninch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 9:04 AM
To: MySQL Discussions
Subject: MySQL + Linux
Hi!
Does anybody know how do i change the 'root' password for mysql server?
I installation guide they say that it's done by typing
'/usr/local/bin/mysqladmin -u root -p password new-password', but how
would i know the old passsword?
Am i mising anything?
Thanks for helping!
By the way, i'm fresh here... :-)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
