Saari Development

This blog is intended to be a log of my (Ali Rizvi's) professional ramblings as a software development engineer. I intend to add logs of my experience with different technologies, software, tech books/articles and related stuff from time to time. My intention is to have an archive for my personal use and public benefit.

Saturday, November 19, 2005

MySQL Post Installation

Here is the command again for running mysql server:
sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &

The documentation would tell you to change the root password immediately but wait until you are through the section about installing Perl support (DBI and DBD::mysql) and run the MYSQLDIR /sql-bench perl run-all-tests.

Both the CPAN installation and run-all-tests expect a blank password for root user.

If you have already changed your password you have two options:
1. force install DBD::mysql (on perl -MCPAN -e shell) OR
2. change your root password back to blank using :-> mysqladmin -u root -p password ''

The test under sql-bench are very processor intensive and take some time so be patient with them. (you might need to do sudo perl run-all-tests).

0 Comments:

Post a Comment

<< Home