summaryrefslogtreecommitdiff
path: root/databases/mysql4-server/MESSAGE
blob: 281bf28cd22eb72fb11dbe19cb2b65a1aa0596af (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
===========================================================================
$NetBSD: MESSAGE,v 1.4 2004/11/18 08:19:01 jklos Exp $

The MySQL directory `${MYSQL_DATADIR}' should be owned by the user
`${MYSQL_USER}' and group `${MYSQL_GROUP}'.  This can be done with:

  chown -R ${MYSQL_USER}:${MYSQL_GROUP} ${MYSQL_DATADIR}

If this is a new installation, you will likely want to set up the 
initial database tables by using the following command:

  ${PREFIX}/bin/mysql_install_db --user=${MYSQL_USER}

After the tables are set up and the MySQL server is running, 
please remember to set a password for the MySQL root user!
This is done by running both:

  ${PREFIX}/bin/mysqladmin -u root -p password 'new-password'
  ${PREFIX}/bin/mysqladmin -h `hostname` -u root -p password 'new-password'

The "Enter password:" prompt is asking for the existing password.
As there is no existing password, just press the Return key.

There is a script distributed with MySQL that can help you lock down
an installation.  This script has been installed to

  ${PREFIX}/bin/mysql_secure_installation.

Please see the manual and the MySQL web site for more instructions.

===========================================================================