mysql --initalize_MySQL初始化设置

1 初始化数据:

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --datadir=/opt/mysql/data --basedir=/opt/mysql

2 配置文件

vim /etc/my.cnf

[mysqld]

basedir=/usr/local/mysql

datadir=/usr/local/mysql/mydata

socket=/tmp/mysql.sock

log_error=/var/log/mysql.log

user=mysql

port=6606

[mysql]

socket=/tmp/mysql.sock

作用:

1.影响服务端的启动

标签: [mysqld] [mysqld_safe] [server] ...

[mysqld]

basedir=/opt/mysql

datadir=/opt/mysql/data

user=mysql

socket=/tmp/mysql.sock

port=3306

server_id=6

2.影响客户端连接

标签: [client] [mysql] [mysqldump] ....

[mysql]

socket=/tmp/mysql.sock

====================