(mysqld)
port ,,,,,,=, 3306
socket ,,,,,=,/tmp/mysql.sock
skip-external-locking
key_buffer_size =256
max_allowed_packet =1米
table_open_cache =256
sort_buffer_size =1米
read_buffer_size =1米
read_rnd_buffer_size =, 4 m
myisam_sort_buffer_size =64
thread_cache_size =8
query_cache_size=16米
#,Try number of CPU的* 2,for thread_concurrency
时间=thread_concurrency 2
datadir =, mydata/数据
skip-grant-tables , #加入此项
<强>
#,/etc/摆在/mysqld restart
Stopping MySQL: [, OK ],
Starting MySQL: [], OK
<强>
#,/usr/bin/mysql
Welcome 用,MySQL 监控只Commands 最终获得with ,,趁机\ g只
Your MySQL connection id is 3,用server 版本:,3.23.56
Type 帮助;”,或“\ h”, for 帮助只Type ‘\ c’,用clear 从而缓冲区只
mysql>, USE mysql ,,
Reading table 方式、for completion of table 以及column names
你还要turn off 却;能够feature 用get a quicker startup with -A
Database changed
mysql>, UPDATE user SET Password =, Password (,“新密码”),WHERE user =,“根”,,,
Query 好吧,,0,rows affected (0.00,秒),
匹配:Rows 2,改变:,0,警告:,0,
mysql>, flush privileges ,,
Query 好吧,,0,rows affected (0.01,秒),
mysql>, quit
再见
