安装mysql-5.0.41

#groupadd mysql
#useradd -g mysql mysql
#tar zxvf mysql-5.0.41.tar.gz
#cd mysql-5.0.41
#./configure --prefix=/usr/local/mysql --enable-thread-safe-client  --with-charset=gbk --with-extra-charset=all
#make
#make install
#cp support-files/my-medium.cnf /etc/my.cnf
#cd /usr/local/mysql
#chown -R mysql .
#chgrp -R mysql .
#bin/mysql_install_db --user=mysql
#chown -R root .
#chown -R mysql var
#bin/mysqld_safe --user=mysql &
#cd /usr/local/src/mysql-5.0.41

用户权限指定

GRANT ALL PRIVILEGES ON db.* TO david@'192.58.197.0/255.255.255.0';

添加root密码
#/usr/local/mysql/bin/mysqladmin -uroot -p

修改密码
shell> mysql -u root mysql
mysql> UPDATE user SET Password = PASSWORD('bagel')
-> WHERE Host = '%' AND User = 'francis';
mysql> FLUSH PRIVILEGES;