mysql> select host, user, password from er I checked the user table to verify the new user repl was properly created. mysql> CREATE USER 'repl' IDENTIFIED BY '123' I left host blank, so the new user can may have access from any location.
I logged into MySQL as root: mysql -u root -p123 I just installed a fresh copy of Ubuntu 10.04.2 LTS on a new machine.