MySQL在linux上的安装

下载MySQL二进制分发版本tar包
需要安装libaio的库

shell> yum search libaio  # search for infoshell> yum install libaio # install library

shell> apt-cache search libaio # search for infoshell> apt-get install libaio1 # install library

确保机器上存在libaio的库
我是在MacOSX上面安装的mysql。
先把mysqld的命令加入到PATH目录
mysql分发包的目录结果如下

.//bin.//COPYING.//data.//docs.//include.//lib.//man.//my.cnf.//mysql-test.//README.//share.//support-files

PATH=$PATH:/Users/chenrenyuan/program/mysql/bin/

先做好命令行参数的个性化配置，本人配置如下

nohup mysqld --initialize --user=chenrenyuan --basedir=/Users/chenrenyuan/program/mysql/ --datadir=/Users/chenrenyuan/program/mysql/data --plugin-dir=/Users/chenrenyuan/program/mysql/plugin  --character-set-server=utf8 --general-log-file=/Users/chenrenyuan/program/mysql/general-log.file &

这里需要关注的是初始化的命令参数

参数 说明 user mysql服务器的启动用户，服务器的运行用户 basedir mysql二进制tar包的解压缩位置，绝对路径 datadir 数据库文件的存放目录，绝对路径，同时也会存在异常的日志，需要关注，很多启动失败的问题可以在这里找到答案和原因 plugin-dir character-set-server 服务器存储编码 general-log-file

然后会输出

chenrenyuan-MacBookPro:mysql chenrenyuan$ bash install.sh 2017-07-14T02:51:19.586472Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2017-07-14T02:51:19.588413Z 0 [Warning] Setting lower_case_table_names=2 because file system for /Users/chenrenyuan/program/mysql/data/ is case insensitive2017-07-14T02:51:19.732025Z 0 [Warning] InnoDB: New log files created, LSN=457902017-07-14T02:51:19.752084Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2017-07-14T02:51:19.807617Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 50552860-683f-11e7-a608-245a56a32efc.2017-07-14T02:51:19.827411Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.2017-07-14T02:51:19.829059Z 1 [Note] A temporary password is generated for root@localhost: gIMndkX:N1po

主要要关注一个地方是会生成一个root的密码，需要用到这个初始化密码去改root密码

2017-07-14T02:51:19.829059Z 1 [Note] A temporary password is generated for root@localhost: gIMndkX:N1po

然后进入到mysql的目录下的support-files目录，里面有mysql服务器的启动脚本mysql.server,但是里面的basedir跟datadir要修改成与你在命令参数启动一致的文件名

启动

chenrenyuan-MacBookPro:support-files chenrenyuan$ bash mysql.server startStarting MySQL. SUCCESS! chenrenyuan-MacBookPro:support-files chenrenyuan$ 

然后使用 进入修改密码，不修改密码前进行操作会报错

mysql -u root -h localhost -p

mysql> show tables;ERROR 1046 (3D000): No database selectedmysql> use mysql;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql> 

修改密码

set password for root@localhost = password('root');

退出重新登录使用修改密码即可

配置文件配置utf8编码配置demo

[mysqld]character-set-server=utf8collation-server=utf8_general_ci[mysql]default-character-set=utf8[mysql.server]default-character-set=utf8[mysqld_safe]default-character-set=utf8[client]default-character-set=utf8