Re: mysql-server root password
You can also change the password by loggin in as root, and use mysql,
change the password entry in the table user (with SQL statements, don't
forget to use password=password('$password') instead of
On Wed, 19 Jul 2000, Northwest Advantage wrote:
> Please cc firstname.lastname@example.org as I am not currently subscribed to the list.
> When I installed mysql-server debconf said to set the mysql root
> password. Then it referenced /usr/share/doc/mysql-server/README.Debian
> for the instructions to do so. The instructions tell you to change it
> with /usr/bin/mysqladmin -u root password 'new-password'
> This is what happens when I run this command.
> frodo:~# /usr/bin/mysqladmin -u root password blah
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> Does it have something to do with the hosts file or is it an error in the
> instructions or possibly something else?
> frodo:~# cat /etc/hosts
> 127.0.0.1 localhost
> 184.108.40.206 frodo.nwadv.com frodo
> 192.168.1.1 frodo.nwadv.com frodo
> P.S. The box was a potato test cycle 2 install that has been kept
> Unsubscribe? mail -s unsubscribe email@example.com < /dev/null