Changes between Version 26 and Version 27 of howto/MySQL


Ignore:
Timestamp:
Apr 8, 2018, 8:04:09 AM (6 years ago)
Author:
WolfgangFahl (Wolfgang Fahl)
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • howto/MySQL

    v26 v27  
    2929This 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.
    3030
    31 = Step 1: Install MySQL = #mysql
     31= Installation =
     32== Step 1: Install MySQL == #mysql
    3233
    3334If you want to run a MySQL server on this computer, install MySQL like this:
     
    3637}}}
    3738
    38 = Step 2: Create a database =
     39== Step 2: Create a database ==
    3940
    4041Also, mysql57 now uses the `''port select''` mechanism to manage the creation of symlinks in
     
    7576}}}
    7677
    77 = Step 3: Activate the installation =
     78== Step 3: Activate the installation ==
    7879Activate your MySQL server installation so that it autostarts when you boot your machine:
    7980{{{
     
    9495}}}
    9596
    96 = Step 4: Set the MySQL password =
     97== Step 4: Set the MySQL password ==
    9798Set 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):
    9899{{{
     
    135136again to verify that the daemon is again running.
    136137
    137 = Step 5:  Optional security configuration = #mysql_security
     138== Step 5:  Optional security configuration == #mysql_security
    138139
    139140There is an interactive program to secure a MySQL installation.
     
    176177
    177178
    178 = Step 6: Database upgrade as necessary = #mysql_upgrade
     179== Step 6: Database upgrade as necessary == #mysql_upgrade
    179180
    180181If the database exists from a previous installation, you may need to upgrade.