connect access denied in perl DBI

2001-05-09 Thread tang jie
the user mysql is given all priviliges, another user is given db table privileges (INSERT, SELECT, etc.), the database files are owned by user mysql, in the same perl DBI script, at the very biginning, the line: $dbh = DBI-connect($dsn, $user_name, $password, {RaiseError = 1}); works when

problem while SETting A PASSWORD during installation

2001-05-07 Thread tang jie
After installation of MySQL version 3.23.37 on Linux/i386 with the command: rpm -i MySQL-3.23.37-1.i386.rpm two lines of instruction come up, asking to /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h hostxxx -p password 'new-password' the first line