Hi people,
I have a small problem. I forgot the password for user root in my
personal MySQL instance. I'm a Linux user and running Debian Sarge on my
computer. I have few other DBs which I created and which I have access
to (still I remember the passwords) but are not having access to MySQL
Hi
Restart mysqld with the --skip-grant-tables option
More info : http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
--Praj
On Mon, 10 Apr 2006 12:57:32 +0600
Kosala Atapattu [EMAIL PROTECTED] wrote:
Hi people,
I have a small problem. I forgot the password for user root
At 02:57 PM 4/10/2006, Kosala Atapattu wrote:
Hi people,
I have a small problem. I forgot the password for user root in my
personal MySQL instance. I'm a Linux user and running Debian Sarge on my
computer. I have few other DBs which I created and which I have access
to (still I remember
Hi everyone,
I am just starting to work with MySql on MAC OS X.When i
installed mysql i got the following message :
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
/usr/local/bin/mysqladmin -u
with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
/usr/local/bin/mysqladmin -u root -h localhost -p password
'new-password'
try:
/usr/local/bin/mysqladmin -u root password 'new-password'
with the single quotes.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602
to work with MySql on MAC OS X.When i
installed mysql i got the following message :
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
/usr/local/bin/mysqladmin -u root -h localhost -p password
'new-password
Hi,
I installed mysql, and found root can login without a password.
So I checked mysql manual and setup a password for root. However,
according to the manual, I need to type another commond:
flush privileges; I don't undersdant why should I do this.
Any one can give me a hint?
Alex
Date |Thu, 2 Aug 2001 15:18:51 -0400
From |Stonix [EMAIL PROTECTED]
Hello!
S Hi,
S I installed mysql, and found root can login without a password.
S So I checked mysql manual and setup a password for root. However,
S according to the manual, I need to type another commond:
S flush privileges
From: "Michel Tignyemb" [EMAIL PROTECTED]
Sent: Tuesday, January 16, 2001 4:33 PM
Here is the command :
mysqladmin -u root -p password 'mysql'
Remove the space between -p and password:
mysqladmin -u root -ppassword mysql