summaryrefslogtreecommitdiff
path: root/databases/mysql-server/MESSAGE
blob: ce555a8131bb6e0fb969258f056e075d9faac468 (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.10 2004/11/18 08:22:27 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.

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