development / ports / opt-arm.git / blame
| Commit | Line | Data |
|---|---|---|
| e41262f8 | 1 | README for mysql 5.x.xx |
| 825e3023 VM |
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 | |
| e41262f8 VM |
17 | to the MySQL privilege tables if you have databases |
| 18 | created with older versions of mysql | |
| 825e3023 VM |
19 | 4. Set a password for the mysql root user: |
| 20 | mysqladmin -u root password <mysql_root_password> | |
| 21 | ||
| e41262f8 | 22 | PRECAUTION |
| 825e3023 VM |
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. |