初始化：mysql/bin/mysqld --initialize
例如：/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --user=mysql --initialize
/etc/my.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21 | [mysqld]
port=3306
bind-address=0.0.0.0
user=mysql
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
#socket=/usr/local/mysql/mysql.sock
log-error=/usr/local/mysql/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid
max_connections=10000
max_user_connections=2000
wait_timeout=200
#character config
character_set_server=utf8
symbolic-links=0
explicit_defaults_for_timestamp=true
lower_case_table_names=1
#[client]
#port=3306
#socket=/usr/local/mysql/mysql.sock
|
开启远程
1
2
3
4
5
6
7
8
9
10
11
12
13 | mysql -u root -p
#更新密码
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
#访问mysql库
use mysql
#使root能再任何host访问
update user set host = '%' where user = 'root';
#刷新
FLUSH PRIVILEGES;
#退出
exit
|