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]