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
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