1、下载
mysql-standard-5.0.27-linux-i686.tar.gz
2、增加mysql用户
groupadd mysql
useradd -g mysql mysql
2、安装配置
tar -zxvf mysql-standard-5.0.27-linux-i686.tar.gz
cp -r mysql-standard-5.0.27-linux-i686 /usr/local/mysql
cd /usr/local/mysql
mkdir etc
cp support-files/my-medium.cnf etc/my.cnf
chown -R root .
chgrp -R mysql .
chown -R mysql data
scripts/mysql_install_db –user=mysql
3、启动mysql
su – mysql
/usr/local/mysql/bin/mysqld_safe &
4、初始化root密码
回车
exit
cd bin
./mysql -uroot
mysql> SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpwd’);
5.授权
grant all privileges on *.* to test@”%” Identified by “password”;
6、停止MySQL
./mysqladmin -uroot -p shutdown
7、添加mysql开机启动
把/usr/local/mysql/support-files/my.server 复制到/etc/init.d/mysqld
执行
sudo update-rc.d mysqld defaults
把mysqld加入到服务中,重新启动机器即可