mysql源码安装

一、mysql源码安装部分    

shell> groupadd mysql 添加用户组：组名,mysql
     shell> useradd -g mysql mysql 添加用户同时属于mysql组
     shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
     shell> cd mysql-VERSION
     shell> ./configure --prefix=/usr/local/mysql 源码安装三部曲:./configure && make && make install
     shell> make
     shell> make install
     shell> cp support-files/my-medium.cnf /etc/my.cnf //将默认的mysql全局配置文件考到/etc/目录下
     shell> cd /usr/local/mysql
     shell> chown -R mysql .
     shell> chgrp -R mysql .
     shell> bin/mysql_install_db --user=mysql //安装mysql初始化表
     shell> chown -R root .
     shell> chown -R mysql var
     shell> bin/mysqld_safe --user=mysql & //启动mysql

二、设置mysql自动启动

cp /usr/local/mysql/script/mysql.server /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig --level 2345 mysqld on

三、设置mysql用户和密码

mysqladmin -u root password 'newpassowrd'

mysql>create user username indentified 'password'