Setting up root account

Anon

Ok, my server admin set up MySql on my server, but when I loggin via telnet and type mysqladmin -uroot password mynewpassword I get a error can't connect to localhost, etc, etc.

Did he not install it right or is there a step I'm missing?

Ben

jburfield

Try: mysql -u root -pPASSWORDHERE
^ space here

You can also try:
mysql -u root -p

and it will ask you for a password.

The space has to be there though.

-- Jason

Anon

No I need to set up the root account not log-in to mysql. I can't login until I've set up the root account can I? I wanted to know if all you do once you have mysql installed to set up the root account is:

mysqladmin -uroot -pPASSWORD

Thanks,
Ben

jburfield

So, basically, you have a fresh install of MySQL with no passwords at all? Is that correct?

If so, can you connect with no password?

mysql -u root

Does that connect you?

If so, try this:

SET PASSWORD FOR root@localhost=PASSWORD('new_password');

That will set the root password to whatever it is you want it to be.

I'm assuming you are using some version of *nix for the OS...this may be slightly different if you are running on Windoze.

Once you have changed the password above, I'd issue a 'flush priviileges' command and then create a regular user.

You can do that using the 'grant' command. Something like:

grant ALL PRIVILEGES on . to 'user'@'localhost' identified by 'PASSWORD';

This will give the user 'user' FULL privileges to all databases when connected from the local machine.(probably NOT a good idea.)

Is this helping you any?

-- Jason