[ports/opt-arm.git] / mysql / README

README for mysql 5.1.xx

REQUIREMENTS

PRE-INSTALL
   Run the included pre-install script to create a new
   user/group mysql.

POST-INSTALL
1. Fix user/group of your mysql databases and the log file
   if you are upgrading mysql from 5.0.x:
   chown -R mysql:mysql /var/lib/mysql
   chown mysql:mysql /var/log/mysqld.log
2. run 'mysql_install_db' to build the system database
   in /var/lib/mysql
3. run 'mysql_upgrade' to add new privileges and features 
   to the MySQL privilege tables if you have 4.x or 3.x 
   databases
4. Set a password for the mysql root user:
   mysqladmin -u root password <mysql_root_password>

PRECAUTION
1. With the default configuration networking support for 
   mysql is disabled, meaning the mysql daemon is accessable 
   from localhost only. 
   To add networking support comment out the 'skip-networking' 
   line in /etc/my.cnf. 
2. If you upgrade from mysql 4.0.x you must recompile the 
   other packages on your system that are linked against the 
   mysql client libraries (libmysqlclient). 
   To obtain such a list of packages for your system, you 
   may use the command 'prt-get dependent mysql' or use yapo 
   to list the packages.

INNODB
  InnoDB table type support is compiled in but disabled by
  default. Comment out the skip-innodb line in /etc/my.cnf
  to fully enable InnoDB support.
Commit	Line	Data
	1	README for mysql 5.1.xx
	2
	3	REQUIREMENTS
	4
	5	PRE-INSTALL
	6	Run the included pre-install script to create a new
	7	user/group mysql.
	8
	9	POST-INSTALL
	10	1. Fix user/group of your mysql databases and the log file
	11	if you are upgrading mysql from 5.0.x:
	12	chown -R mysql:mysql /var/lib/mysql
	13	chown mysql:mysql /var/log/mysqld.log
	14	2. run 'mysql_install_db' to build the system database
	15	in /var/lib/mysql
	16	3. run 'mysql_upgrade' to add new privileges and features
	17	to the MySQL privilege tables if you have 4.x or 3.x
	18	databases
	19	4. Set a password for the mysql root user:
	20	mysqladmin -u root password <mysql_root_password>
	21
	22	PRECAUTION
	23	1. With the default configuration networking support for
	24	mysql is disabled, meaning the mysql daemon is accessable
	25	from localhost only.
	26	To add networking support comment out the 'skip-networking'
	27	line in /etc/my.cnf.
	28	2. If you upgrade from mysql 4.0.x you must recompile the
	29	other packages on your system that are linked against the
	30	mysql client libraries (libmysqlclient).
	31	To obtain such a list of packages for your system, you
	32	may use the command 'prt-get dependent mysql' or use yapo
	33	to list the packages.
	34
	35	INNODB
	36	InnoDB table type support is compiled in but disabled by
	37	default. Comment out the skip-innodb line in /etc/my.cnf
	38	to fully enable InnoDB support.