Re: mysql-server root password

2000-07-20 Thread Kirt Runolfson
I ended up being able to set the password via some select commands. Here are those commands if anybody is interested. mysql -u root mysql UPDATE user SET Password = PASSWORD ('new_password') WHERE user = 'root'; FLUSH PRIVILEGES; The password was blank but for

mysql-server root password

2000-07-19 Thread Northwest Advantage
Please cc [EMAIL PROTECTED] 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

Re: mysql-server root password

2000-07-19 Thread Ron Rademaker
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 password=$password). Ron Rademaker On Wed, 19 Jul 2000, Northwest Advantage wrote: Please cc

Re: mysql-server root password

2000-07-19 Thread Mark Walter
Hello, frodo:~# /usr/bin/mysqladmin -u root password blah /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' had the same problem. My sysadmin possibly raised a password during installation. So the