#tar zvxf mysql-4.1.15.tar.gz
#mv mysql-4.1.15 mysql
安装Mysql。(
#cd mysql
#./configure –prefix=/data/mysql –with-charset=gbk
#make
#make install
#cp support-files/my-medium.cnf /etc/my.cnf
#cd /usr/local/mysql
#bin/mysql_install_db –user=mysql
# chown -R root .
#chown -R mysql var
#chgrp -R mysql .
#bin/mysqld_safe –user=mysql &
mysql给用户授权和增加用户
grant all on *.* to user@”hostip” identified by ‘passwd’ with grant option
flush privileges
关闭MYSQL
/data/mysql/bin/mysqladmin -u root shutdown
修改mysql用户密码
mysql >use mysql;
mysql> update user set password=password(‘passwwd’) where user=’root’;
mysql> flush privileges;