Web Hosting Talk







View Full Version : MySQL setting password


FireFoz
09-30-2001, 09:51 AM
Hi,

I did exactly as told on http://list.cobalt.com/pipermail/cobalt-users/2001-February/033275.html to install mysql.

When i do "/usr/local/mysql/bin/mysqladmin -u root password 'YOURPASSWORDHERE' " where i changed 'YOURPASSWORDHERE' into my own ofcourse, i get this error:

/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

this means that i cant connect because im not using a password, but shouldnt i set the password here? i really cant figure out what im doing wrong, i started all over a thousand of times already, and im 100% sure im doing it exactly as it says. Can anyone help me?

ffeingol
09-30-2001, 10:11 AM
What kind of RaQ do you have (i.e. RaQ 3 or 4)? Why not just install the MySQL .pkg?

Frank

FireFoz
09-30-2001, 10:31 AM
RaQ3i..i couldnt find it

i found it now tho
shall i just install it over it?

eva2000
09-30-2001, 02:20 PM
after you changed the password did you flush privileges to make the change recognised by mysql?

edit : never mind didn't read the above thread properly

you are doing the above install logged in as root user?