文章标题

Mysql二进制安装步骤总结：
1.下载 mysql-5.5.46.bin.tgz，解压 tar -zcxf mysql-5.5.46.bin.tgz -C mysql

2.创建data，log，etc，tmp,mysql.sock目录

3.修改my.cnf 参数，目录等

4.初始化创建库 mysql_intall_db
$HOME/local/mysql-5.0.56/scripts/mysql_install_db --defaults-file=$HOME/local/mysql/etc/my.cnf

5.启动 mysql_safe
mysqld_safe –defaults-file=$HOME/local/mysql/etc/my.cnf &

6.使用root用户连接，mysql
mysql -hlocalhost -Pport -uroot -p

7.创建用户 insert into user
insert into mysql user(Host,User,Password) values (“localhost”，”username”,”password(“123”)”);

8.赋予权限 grant all privilege on “.” to ‘user@%’ identified by ‘password’ with grant option

1. flush privilege

2. native连接

done