乌班图mysql解压过程_Ubuntu下MySQL解压安装

1.Ubuntu下解压到/usr/local/MySQL

groupadd mysql

useradd -g mysql mysql

cd /usr/local/mysql

chown -R mysql .

chgrp -R mysql .

chown -R root .

chown -R mysql data

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

cp /usr/local/mysql/support-files/my-huge.cnf /etc/my.cnf

2.修改my.cnf

nano /etc/my.cnf

添加

basedir=/usr/local/mysql

datadir=/home/mysql

3.初始化数据库

scripts/mysql_install_db --user=mysql

4.启动

bin/mysqld_safe --user=mysql &

修改密码

mysql>use mysql

mysql>UPDATE user SET password=PASSWORD('root') WHERE user='root';

mysql>FLUSH PRIVILEGES;

mysql>exit

5.设置自动启动

apt-get install chkconfig

chkconfig --add mysqld

chkconfig mysqld on

6.将mysql加入到path

nano /etc/profile

umask前加进这句

export PATH=$PATH:/usr/local/mysql/bin

7.重启系统

reboot