1. 创建用户及组

cd /groupadd mysqluseradd -g mysql mysqlpasswd mysqlchown -R mysql:mysql /usr/local

2. 解压安装包

cd /usr/local/tar -zxvf mysql5.6.tar.gz

3. 配置 /usr/local/mysql/my.cnf

[client]default-character-set=utf8socket=/usr/local/mysql/tmp/mysql.sock[mysql]default-character-set=utf8[mysqld]socket=/usr/local/mysql/tmp/mysql.socktmpdir=/usr/local/mysql/tmp/max_allowed_packet=1024Mbasedir=/usr/local/mysqldatadir=/usr/local/mysql/datasymbolic-links=0character_set_server=utf8[mysqld_safe]default-character-set=utf8log-error=/usr/local/mysql/logs/mysqld.logpid-file=/usr/local/mysql/run/mysqld/mysqld.pid

4. 授权

chmod 777 my.cnf

5. 初始化配置文件

cd /usr/local/mysqlscripts/mysql_install_db --user=mysql --defaults-file=/usr/local/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/

6. 配置MySQL启动文件

cd /usr/local/mysql/support-filescp mysql.server /etc/init.d/mysqldchmod +x /etc/init.d/mysqldservice mysqld start # 启动service mysqld stop # 停止

出现的问题解决办法

1. 解决Access denied for user ‘‘@‘localhost‘ to database ‘mysql原因是mysql的密码有问题用mysql匿名用户可以进入数据库，但是看不见mysql数据库.解决办法：具体操作步骤：关闭mysql:# service mysqld stop然后:# mysqld_safe --skip-grant-tables启动mysql:# service mysqld startmysql -u rootmysql> use mysqlmysql> UPDATE user SET Password=PASSWORD(‘xxx‘) WHERE user=‘root‘;mysql> flush privileges;mysql>\q到这里密码已经修改成功，mysql -u root -p2. MySQL启动出现The server quit without updating PID file错误解决办法将 /etc/mysql 下的 my.cnf 文件删除，再次启动MySQL服务