Posts Tagged ‘Fix’

I have just installed MySQL 5.1.33 sucessfully on my Solaris 10u6 running on Sparc Ultra IIIi machine. Firstly, I tought that newest version of MySQL must be fixed from bugs found before. But, this version comes up with new bugs too,,,LOL 😀

To begin install MySQL, you can download either binary package or tarbal source from here. It’s easier to install binary package, but you’ll feel more free with tarbal source. I prefer binary package first. Download the package and save wherever you like. I usually put additional software source on /opt.

Here are the steps to install:

1. Create mysql user and group

#groupadd mysql

#useradd -g mysql mysql

2. Extract and install the package

#gunzip -d mysql-5.1.34-solaris10-sparc-64bit.pkg.gz

#pkgadd -d mysql-5.1.34-solaris10-sparc-64bit.pkg

You will be asked to create installation directory. Answer with yes to continue installation. The installation process will put the files on /opt/mysql/mysql.

3. You will need to do these command to change file/folders permission

#chown -R mysql:mysql /opt/mysql/mysql

#chown -R mysql:mysql /var/lib/mysql

#chmod -R 550 /opt/mysql/mysql

4. Binary files will be located in /opt/mysql/mysql/bin after installation. Install mysql database with this command

#/opt/mysql/mysql/bin/mysql_install_db

4.  Usually, we start the server with this command

#/opt/mysql/mysql/bin/mysqld_safe –user=mysql &

But, MySQL 5.1.33 has a bug on this. Here the bug is: Installation process put data files on /var/lib/mysql, while default mysqld_safe command will look forward to /opt/mysql/mysql/data/. We can fix this by adding –datadir option. To start the server, the complete command will be like this

#/opt/mysql/mysql/bin/mysqld_safe –user=mysql –datadir=/var/lib/mysql &

5. Don’t forget to create mysql root password

#/opt/mysql/mysql/bin/mysqladmin -u root password ‘your new password’
Actually there are still many bugs in this release. But this one is the most significant one -in my opinion indeed 😀 – that the server will not be running without fixing it.

Comment please 😀

Sign up for PayPal and start accepting credit card payments instantly.