Changes between Version 26 and Version 27 of howto/MySQL
- Timestamp:
- Apr 8, 2018, 8:04:09 AM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
howto/MySQL
v26 v27 29 29 This page shows how to install and use the mysql56 port, but you can use another version if you prefer; all of these ports use a similar directory layout. 30 30 31 = Step 1: Install MySQL = #mysql 31 = Installation = 32 == Step 1: Install MySQL == #mysql 32 33 33 34 If you want to run a MySQL server on this computer, install MySQL like this: … … 36 37 }}} 37 38 38 = Step 2: Create a database=39 == Step 2: Create a database == 39 40 40 41 Also, mysql57 now uses the `''port select''` mechanism to manage the creation of symlinks in … … 75 76 }}} 76 77 77 = Step 3: Activate the installation=78 == Step 3: Activate the installation == 78 79 Activate your MySQL server installation so that it autostarts when you boot your machine: 79 80 {{{ … … 94 95 }}} 95 96 96 = Step 4: Set the MySQL password=97 == Step 4: Set the MySQL password == 97 98 Set the MySQL `root` password (use the auto-generated password from the --initialize command above for MySQL 5.7. For MySQL 5.6 and earlier the password should currently be empty; see also the security option below): 98 99 {{{ … … 135 136 again to verify that the daemon is again running. 136 137 137 = Step 5: Optional security configuration= #mysql_security138 == Step 5: Optional security configuration == #mysql_security 138 139 139 140 There is an interactive program to secure a MySQL installation. … … 176 177 177 178 178 = Step 6: Database upgrade as necessary= #mysql_upgrade179 == Step 6: Database upgrade as necessary == #mysql_upgrade 179 180 180 181 If the database exists from a previous installation, you may need to upgrade.