Shulou(Shulou.com)06/01 Report--

# tar zvxf mysql-4.1.15.tar.gz

# mv mysql-4.1.15 mysql

Install 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 authorizes and adds users to users

Grant all on *. * to user@ "hostip" identified by 'passwd' with grant option

Flush privileges

Close MYSQL

/ data/mysql/bin/mysqladmin-u root shutdown

Modify mysql user password

Mysql > use mysql

Mysql > update user set password=password ('passwwd') where user='root'

Mysql > flush privileges

[@ more@]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.