Hi, > I have a problem connecting to the mysql server. I installed a new > server with mysql 4.1.9, apache2, php4 on freebsd5.3 and have some > websites running on it using the mysql server. Last friday I had a > crash of one off my other servers and I copied the websites and db's > to this new server. (old server was mysql 3). After that the mysql > server didn't startup anymore. I then chown'ed the data dir to > mysql:mysql. After that I was able to start the server with > "--skip-grant-tables &". But it didn't start with out the > --skip-grant-tables option". So I found out to use "mysql_install_db" > to create new grant tables. After that the server starts with and > without "--skip-grant-tables". But only with the "--skip-grant-tables" > option, websites can connect to the databases. I can't find any real > errors in the logs and I can't find anything on the web or forum. I > run mysql_fix_privilege_tables and installed a root passwd. Hopefully > somebody can help me on this.
I wonder if putting: [mysql] old-passwords ...in your my.cnf (I always use /etc/my.cnf because trying to guess where the 'real' data directory is, is painful). http://dev.mysql.com/doc/mysql/en/password-hashing.html DSL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
