Articles:

• mysql: How can I rename a database (122415)
• How can I rename table names and column names in mysql (28666)
• How to compare strings in mysql case sensitive (18607)
• Compare 2 dates in mysql (17702)
• Lock an entire mysql database with all its tables (14549)
• How to reset the root password on mysql (12834)
• mysql message ERROR 1054 (42S22): Unknown column in 'on clause' (11530)
• Create UNIQUE Index yields a not unique index in mysql - why? (10718)
• concat () function to concatenate 2 strings in mysql does not exist (5464)
• How to change the next value of an auto_increment field (5160)
• How can I obtain the next auto_increment number (before inserting a record)? (4270)
• My timestamp field in mysql does not update (4081)
• Problems installing DBD::mysql on Solaris 8 (3914)
• Best operating system settings for mysql throughput (3735)
• How to install mysql 5 on Solaris 8 (3711)
• Kill a long running blocking sql statement (3623)
• Handling of dates in mysql (Date formats) (3550)
• How to pick a random record from a mysql table (3260)
• Creating a table with an autoincrement primary key (3239)
• Can I install MySQL without root access? (3159)
• How to limit the size of a MySQL database (3121)
• Restoring the mysql system user table (2614)
• Setting a user password in mysql (Why do I get 'Access denied') (2417)
• What is the MERGE statement good for? (2414)
• Implementing a full text search with mysql (2392)
• Modifying a field to be auto_increment (2387)
• Extracting a table definition from the command line (2257)
• Exporting and importing between 2 mysql databases (2242)
• How can I connect to mysql? I need to update the helpdesk backend (2233)
• count(*) syntax in mysql (2230)
• Stub to connect from a C program to mysql (1994)
• count(distinct fieldname) very slow in mysql (1890)
• JDBC error message Illegal hour value for java.sql.Time type in value (1273)
• What timezone is my mysql database server running in? (1022)
• How to log all mysql database modifications (969)
• Location of mysql startup script (912)
• Monitoring mysql status (496)

How to install mysql 5 on Solaris 8 Question: I need to install mysql (version 5.0) on a Solaris box. It is Solaris 8 on a Sparc, 32 bit. Answer: First you need to download the proper package: mysql-standard-5.0.22-solaris8-sparc.pkg.gz You can find links to download on http://dev.mysql.com/downloads/mysql/5.0.html Unzip it. Before you can install this package, you need to create a mysql user and a mysql group. I also needed to create some folders and give this new user mysql access to it. See the script below: groupadd mysql useradd -g mysql mysql mkdir /var/mysql chgrp -R mysql /var/mysql chmod -R 770 /var/mysql pkgadd -d mysql_solaris.pkg