1. MySQL .
d:\.
d:\mysql56
MySQL
my.cnf: d:\mysql56\my.cnf
: d:\\data
: utf8
''.
root:sa.
.
, ﳿ, my.cnf.
2. MySQL .
, my2.cnf, my2.cnf port = XXXX, XXXX - , 3306 + .
d:\\data2
, mysql .
, ﳿ, my2.cnf.
3. MySQL '-.
my.cnf , '- \\kit-server, \stud\DBIS
:
' ( \\kit-server\stud d:\stud).
my.cnf port = XXXX, XXXX - , 3306 + .
my.cnf , d:\stud\\dataYY, YY .
, mysql ' \\kit-server .
\\kit-server\stud\DBIS\mysql56, , , my7.cnf.
,
mysql -u root -p --host=10.1.100.39 --port=XXXX
10.1.100.39 IP- kit-server. .
璺 MySQL SQLYog. ﳿ .
ճ :
ϳ , (+r). bin. ___>mysqld. , (ctrl+alt+del). , : < mysqld mysqld u root> - , <SELECT * FROM user;> . : < mysqladmin -u root password your_password> < mysqladmin -u root reload>. , : <mysqld u root --defaults-file=my.cnf >. : <mysqld u root port=3307> <mysqld u root h _ _>. , : <mysqladmin u root shutdown> , : <mysqladmin u root port=3307>.
|
|
(my.cnf).
[client]
default_character_set=cp1251
[mysqld]
datadir= D:/mysql562/data/
basedir= D:/mysql562
port=3306 # ,
character_set_server=cp1251
collation_server=cp1251_general_ci
innodb_data_home_dir=c:/work/mysql562/data
innodb_log_group_home_dir=c:/work/mysql562/data
[mysql]
character_set_client=cp1251
[myisamchk]
key_buffer_size=256M
sort_buffer_size=256M
read_buffer=2M
write_buffer=2M
[mysql.server]
user=mysql
basedir=d:/mysql562