Linux下安装mysql

1. 解压

2. move到/usr/local下，改名为mysql

3. copy support-files中的my-default.cnf到/etc/my.cnf

4. copy support-files中的mysql.server到/etc/init.d/mysqld

5. mkdir data

6. cd bin

./mysqld –initialize –user=mysql –basedir= –datadir=

1. 修改my.cnf和mysqld

2. 字符设置character_set_server=utf8

3. service mysqld start

4. ps -ef|grep mysql kill -9 端口号

10 mysql登入，root， 临时密码

11 alter user ‘root’@’localhost’ identified by ‘123456’;

12 update user set host = ‘%’ where user = ‘root’