scusate la domanda magari stupida “senza magari” il file di configurazione di mysql e sempre questo “my.cnf” se lo apro ce scritto :
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
Default to using old password format for compatibility with mysql 3.x
clients (those using the mysqlclient10 compatibility package).
old_passwords=1
To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring=“nodeid=4;host=localhost:1186”
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[ndbd]
If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
adjust its connection to the management daemon here.
Note: ndbd init script requires this to include nodeid!
connect-string=“nodeid=2;host=localhost:1186”
[ndb_mgm]
connection string for MySQL Cluster management tool
connect-string=“host=localhost:1186”
Anche se e un test vorrei capire se posso inserire i parametri per il mio server oppure e un altro file che gestisce il mysql. Di solito ero abituato trovare questo:
Example MySQL config file for medium systems.
This is for a system with little memory (32M - 64M) where MySQL plays
an important part, or systems up to 128M where MySQL is used together with
other programs (such as a web server)
You can copy this file to
/etc/my.cnf to set global options,
mysql-data-dir/my.cnf to set server-specific options (in this
installation this directory is /var/lib/mysql) or
~/.my.cnf to set user-specific options.
In this file, you can use all long options that a program supports.
If you want to know which options a program supports, run the program
with the “–help” option.
The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
Here follows entries for some specific programs
The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 3072M
max_allowed_packet = 512M
table_cache = 1024
sort_buffer_size = 512M
net_buffer_length = 64M
read_buffer_size = 256M
read_rnd_buffer_size = 512M
myisam_sort_buffer_size = 128M
Don’t listen on a TCP/IP port at all. This can be a security enhancement,
if all processes that need to connect to mysqld run on the same host.
All interaction with mysqld must be made via Unix sockets or named pipes.
Note that using this option without enabling named pipes on Windows
(via the “enable-named-pipe” option) will render mysqld useless!
#skip-networking
Replication Master Server (default)
binary logging is required for replication
log-bin=mysql-bin
required unique id between 1 and 2^32 - 1
defaults to 1 if master-host is not set
but will not function as a master if omitted
server-id = 1
sto sbalgiano file o cosa??
