View Full Version : mysql username and password
sintor
04-04-2002, 12:45 AM
How do you set your mysql username and password under linux mandrake 8.x ?
Trumpcard
04-04-2002, 02:23 AM
type:
mysql
then
GRANT ALL PRIVILEGES ON eq.* TO someid@localhost
IDENTIFIED BY 'somepass' WITH GRANT OPTION;
read through the mysql documentation, they'll give you a rundown on settng permissions.
sintor
04-04-2002, 10:03 AM
If i type mysql i get :
error 1045:access denied for user: 'root@localhost' (using password: no)
Now what, as far as the mysql docs, looks like greek to me.
flipper
04-04-2002, 10:20 AM
You can change the password for mysql by using mysqladmin. I think the following will do it for you:
mysqladmin -u root -p password <new password>
Just replace <new password> with the new password you want to use. Typing this command will cause mysql to prompt you for your existing password. Since Mandrake 8.x doesn't assign a password, just hit enter when prompted.
EDIT: The above command may interpret the string "password" as your old password. If that happens try this command instead:
mysqladmin -p -u root password <new password>
sintor
04-05-2002, 11:27 AM
That did the trick, thanks guys.
vBulletin® v3.8.11, Copyright ©2000-2024, vBulletin Solutions Inc.