V my.cnf zakomentovat skip-networking a enable-named-pipe
A co ten <a href="http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html">odkaz, kam tě to furt odkazuje</a>?
Díky za odpověď,
našel jsem, že my.cnf je na windowsech my.ini (snad je to dobře),
zakomentoval jsem skip networking, ale enable named pipe jsem v tom souboru
našel jen v "okecávacích" komentech, takže pořád nefacha. Port 3306 jsem
ve firewallu odblokoval a port 90 je taky volnej. Přikládám soubor a v
komentech jsem označil problematická místa.
Díky za jakékoliv (správné) další rady.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
default-storage-engine = myisam
port = 3306
socket = /tmp/mysql.sock
datadir = "C:/UwAmp/bin/database/mysql-5.6.20/data"
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
explicit_defaults_for_timestamp = TRUE
# 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! <-tohle...
#
# skip-networking <- ...a tohle mi dělá vrásky na čele
# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin
# binary logging format - mixed recommended
binlog_format=mixed
# 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
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\\mysql\\data\\
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:\\mysql\\data\\
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeoutPopravdě úplně si to už nepamatuju, zkus pod definici portu hodit:
skip-networking
enable-named-pipe
Po přidání už nepadá, ale pro změnu vůbec nereaguje, nejde vypnout/zapnout a k databázi se pořád nedá připojit :-/
trošku jsem to mezitím předělal, my.ini teď vypadá takhle:
[client]
port = 3306
socket=/tmp/mysql.sock
[mysql]
default-character-set = utf8
[mysqld]
port = 3306
basedir="C:/UwAmp/bin/database/mysql-5.6.20/"
datadir="C:/UwAmp/bin/database/mysql-5.6.20/data"
character-set-server = utf8
default-storage-engine = INNODB
socket=/tmp/mysql.sock
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
explicit_defaults_for_timestamp
max_connections = 341
query_cache_size = 9M
tmp_table_size = 16M
bind-address = 0.0.0.0
thread_cache_size = 17
myisam_max_sort_file_size = 100G
myisam_sort_buffer_size = 8M
key_buffer_size = 16M
read_buffer_size = 64K
read_rnd_buffer_size = 256K
sort_buffer_size = 208K
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 1M
innodb_buffer_pool_size = 256M
innodb_log_file_size = 10M
innodb_thread_concurrency = 10
skip-networking
enable-named-pipea log takhle
2015-06-09 16:35:52 5668 [Note] Plugin 'FEDERATED' is disabled.
2015-06-09 16:35:52 5668 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-09 16:35:52 5668 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-09 16:35:52 5668 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-06-09 16:35:52 5668 [Note] InnoDB: Memory barrier is not used
2015-06-09 16:35:52 5668 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-06-09 16:35:52 5668 [Note] InnoDB: Not using CPU crc32 instructions
2015-06-09 16:35:52 5668 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2015-06-09 16:35:52 5668 [Note] InnoDB: Completed initialization of buffer pool
2015-06-09 16:35:53 5668 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-09 16:35:53 5668 [Note] InnoDB: The log sequence numbers 1602582 and 1602582 in ibdata files do not match the log sequence number 1603104 in the ib_logfiles!
2015-06-09 16:35:53 5668 [Note] InnoDB: Database was not shutdown normally!
2015-06-09 16:35:53 5668 [Note] InnoDB: Starting crash recovery.
2015-06-09 16:35:53 5668 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-06-09 16:35:53 5668 [Note] InnoDB: Restoring possible half-written data pages
2015-06-09 16:35:53 5668 [Note] InnoDB: from the doublewrite buffer...
2015-06-09 16:35:56 5668 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-09 16:35:56 5668 [Note] InnoDB: Waiting for purge to start
2015-06-09 16:35:56 5668 [Note] InnoDB: 5.6.20 started; log sequence number 1603104
2015-06-09 16:35:57 5668 [Note] Event Scheduler: Loaded 0 events
2015-06-09 16:35:57 5668 [Note] C:\UwAmp\bin\database\mysql-5.6.20\bin\mysqld.exe: ready for connections.
Version: '5.6.20' socket: '' port: 0 MySQL Community Server (GPL)díky za rady/připomínky/poznámky/cokoliv
ok, vyřešeno. Prostě jsem místo Uwampu stáhnul XAMPP, tam to fachá na
první nástřel 
Zobrazeno 10 zpráv z 10.