I've just installed databases/mysql57-server on a new server, but can't see the example config files in /usr/local/share/mysql or anywhere to copy to run the server.
I've used:
and /usr/local/share/mysql/ has:
my-default.cnf
mysql-log-rotate
mysql.server
mysql_security_commands.sql
mysql_sys_schema.sql
mysql_system_tables.sql
mysql_system_tables_data.sql
mysql_test_data_timezone.sql
mysql/mysqld_multi.server
But in my /etc/rc.conf I have:
Trying to complete the installation gives an error:
The above
/tmp/mysql.sock.lock
I can't find anything in the setup that would have caused the lack of config files. Here's what I used:
[x] Archive
[x] Blackhole
[ ] Example Compile "Example Storage" statically in server
[x] Federated
[x] Innobase
[x] Partition
[x] Perfschema
( ) Bundled_SSL
(x ) OpenSSL
( ) Without_SSL
I'm not using a /etc/make.conf, so I guess that rules out a possible way the install could have excluded the example files.
Any ideas?
(Thanks)
I've used:
$ sudo find / -name "mysql*" 2>/dev/nulland /usr/local/share/mysql/ has:
my-default.cnf
mysql-log-rotate
mysql.server
mysql_security_commands.sql
mysql_sys_schema.sql
mysql_system_tables.sql
mysql_system_tables_data.sql
mysql_test_data_timezone.sql
mysql/mysqld_multi.server
Code:
$ cat my-default.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
Code:
$ ps -ax | grep mysql
617 - Is 0:00.01 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/freebsd-1gb-sfo1-01b-dev-db.pid
715 - I 0:41.51 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql/my.cnf --basedir=/usr/local --datadir=/var/db/mysql --plugin-dir=/usr/local/lib/mysql/plugin --log-error=/var/db/mysql/freebsd-1gb-sfo1-01b-dev-db.err --pid-file=/var/db/mysql/freebsd-1gb-sfo1-01b-dev-db.pid
Code:
$ sudo service mysql-server start
/etc/rc.conf: ---------------------------------------------: not found
/etc/rc.conf: ---------------------------------------------: not found
Starting mysql.But in my /etc/rc.conf I have:
Code:
mysql_enable="YES"Trying to complete the installation gives an error:
Code:
$ sudo mysql_secure_installation
Securing the MySQL server deployment.
Connecting to MySQL server using password in '/root/.mysql_secret'
Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)The above
find shows as the first result:/tmp/mysql.sock.lock
I can't find anything in the setup that would have caused the lack of config files. Here's what I used:
$ sudo make config[x] Archive
[x] Blackhole
[ ] Example Compile "Example Storage" statically in server
[x] Federated
[x] Innobase
[x] Partition
[x] Perfschema
( ) Bundled_SSL
(x ) OpenSSL
( ) Without_SSL
I'm not using a /etc/make.conf, so I guess that rules out a possible way the install could have excluded the example files.
Any ideas?
(Thanks)
