Open Dental Forum

Code: Select all

SHOW VARIABLES LIKE "%version%";

Code: Select all

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 1.1.8                        |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.5.14                       |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86                          |
| version_compile_os      | Win32                        |
+-------------------------+------------------------------+
7 rows in set (0.02 sec)

mysql>

Code: Select all

[mysqld]
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"
datadir="C:/mysql/data/"
default-storage-engine=MyISAM
max_allowed_packet=40M

bind-address = 192.168.1.160

server-id = 2

log-bin = C:\mysql\mysql-bin.log

Code: Select all

[info] /usr/bin/mysqladmin  Ver 8.42 Distrib 5.5.46, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version          5.5.46-0+deb7u1-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 2 hours 12 min 35 sec

Threads: 9  Questions: 55954  Slow queries: 0  Opens: 3748  Flush tables: 1  Open tables: 400  Queries per second avg: 7.033.
@odserver:~$ [info] /usr/bin/mysqladmin  Ver 8.42 Distrib 5.5.46, for debian-linux-gnu on x86_64-bash: [info]: command not found
@odserver:~$ Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Uptime:                 2 hours 12 mi-bash: syntax error near unexpected token `c'
n 35 sec

Code: Select all

[mysqld]
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"
datadir="C:/mysql/data/"
default-storage-engine=MyISAM
max_allowed_packet=40M

bind-address=192.168.1.160

server-id=2

log-bin="C:/mysql/mysql-bin.log"