{"id":80,"date":"2007-09-04T22:30:34","date_gmt":"2007-09-05T06:30:34","guid":{"rendered":"http:\/\/learnbyblogging.com\/?p=80"},"modified":"2007-09-04T22:30:34","modified_gmt":"2007-09-05T06:30:34","slug":"installing-mysql-on-solaris-10","status":"publish","type":"post","link":"https:\/\/learnbyblogging.com\/?p=80","title":{"rendered":"Installing MySql on Solaris 10"},"content":{"rendered":"

I followed the Mel Lester Jr.’s instructions<\/a> with some minor tweaks on the paths.<\/p>\n

To start using the mysql bundled with Solaris 10, a number of post-install procedures need to be made by root. This configuration has been successfully tested in a Sparce Root Local Zone. The following steps are derived from the mysql manual (manual.ps, manual.txt or manual_toc.html) found in the \/usr\/sfw\/src\/mysql\/Docs directory. <\/p>\n

1. Log in as root and initialise the database tables.
\n# \/usr\/local\/mysql\/bin\/mysql_install_db
\nPreparing db table
\nPreparing host table
\nPreparing user table
\nPreparing func table
\nPreparing tables_priv table
\nPreparing columns_priv table
\nInstalling all prepared tables
\n060118 21:24:03 \/usr\/local\/mysql\/bin\/mysqld: Shutdown Complete
\n<\/p>\n

2. Create mysql user and group and change data directory group.
\n# groupadd mysql
\n# useradd -g mysql mysql
\n# chgrp -R mysql \/var\/mysql
\n# chmod -R 770 \/var\/mysql
\n# installf SUNWmysqlr \/var\/mysql d 770 root mysql
\n# chown -R mysql:mysql \/usr\/local\/mysql\/var (critical step or you may end up with “[1] Exit 127”
\n(This took me a while to figure out, this directory is where the database is stored. Good to know if you want to back up)<\/p>\n

\/usr\/local\/bin\/mysqld_safe –user=mysql
\n# Starting mysqld daemon with databases from \/usr\/local\/mysql\/var
\nSTOPPING server from pid file \/usr\/local\/mysql\/var\/tsai86.pid
\n070902 23:39:39 mysqld ended<\/p>\n

3. MySQL reads configuration files from different places in the following order:
\nFilename Purpose
\n——— ———
\n\/etc\/my.cnf Global options
\nDATADIR\/my.cnf Server-specific options
\ndefaults-extra-file\tThe file specified with –defaults-extra-file=path
\n~\/.my.cnf User-specific options<\/p>\n

4. Optionally copy a mysql daemon configuration file to configuration directory.
\nNote: there are other configuration profiles available.
\nFor default solaris installation DATADIR is \/var\/mysql.
\n# cp \/usr\/local\/mysql\/share\/mysql\/my-medium.cnf \/var\/mysql\/my.cnf<\/p>\n

5. Start mysql daemon as mysql user manually
\n# \/usr\/local\/mysql\/bin\/mysqld_safe –user=mysql &<\/p>\n

6. Set the root MySQL user password (Substitute a unique password for “new-password”)
\n# cd \/usr\/local\/mysql\/bin<\/p>\n

Note the use of single quotes surrounding your new-password and the back ticks surrounding the hostname command — they are not the same!
\n# .\/mysqladmin -u root password ‘new-password’
\n# .\/mysqladmin -u root -h `hostname` password ‘new-password’<\/p>\n

7. Test the server:
\n# .\/mysqlshow -p
\nEnter password: new-password
\n+———–+
\n| Databases |
\n+———–+
\n| mysql |
\n| test |
\n+———–+
\n# .\/mysql -u root -p
\nEnter password: new-password
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 3 to server version: 4.0.20-standard
\nType ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the buffer.
\nmysql> show databases;<\/p>\n

\t+——————–+
\n\t| Database
\n\t\t|
\n\t+——————–+
\n\t| information_schema |
\n\t| mysql\t\t\t|
\n\t| test\t\t\t|
\n\t+——————–+
\n\t3 rows in set (0.00 sec)
\n8. mysql> quit;
\nBye<\/p>\n

9. Optionally perform the following steps for automatic start and stop of mysql daemon at boot and shutdown: (This doesn’t quite work for me and I haven’t figured out how to use the svc service to do this automatically.) Stay tuned…
\nLink boot time start up script from rc3.d and rc[012S].d
\n# ln \/usr\/local\/mysql\/share\/mysql\/mysql.server \/etc\/rc3.d\/S99mysql
\n# ln \/usr\/local\/mysql\/share\/mysql\/mysql.server \/etc\/rc0.d\/K00mysql
\n# ln \/usr\/local\/mysql\/share\/mysql\/mysql.server \/etc\/rc1.d\/K00mysql
\n# ln \/usr\/local\/mysql\/share\/mysql\/mysql.server \/etc\/rc2.d\/K00mysql
\n# ln \/usr\/local\/mysql\/share\/mysql\/mysql.server \/etc\/rcS.d\/K00mysql<\/p>\n","protected":false},"excerpt":{"rendered":"

I followed the Mel Lester Jr.’s instructions with some minor tweaks on the paths. To start using the mysql bundled with Solaris 10, a number of post-install procedures need to be made by root. This configuration has been successfully tested in a Sparce Root Local Zone. The following steps are derived from the mysql manual … Continue reading Installing MySql on Solaris 10<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-80","post","type-post","status-publish","format-standard","hentry","category-tips-for-computer"],"_links":{"self":[{"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/posts\/80","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=80"}],"version-history":[{"count":0,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=\/wp\/v2\/posts\/80\/revisions"}],"wp:attachment":[{"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnbyblogging.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}