mysql username and password

[sintor]

How do you set your mysql username and password under linux mandrake 8.x ?

[Trumpcard]

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]

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]

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]

That did the trick, thanks guys.