统计

留言簿(1)

DB

Others

QA

Tech Website

阅读排行榜

评论排行榜

Install MySQL5.1.25 on Ubuntu

      Ubuntu crashed tonight which urged me to reintsall the system and MySQL. Damn!

-------------------main procedure-------------------

shell> groupadd mysql

shell> useradd -g mysql mysql

shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -

shell> cd mysql-VERSION

shell> ./configure --prefix=/usr/local/mysql

shell> make

shell> make install

shell> cp support-files/my-medium.cnf /etc/my.cnf

shell> cd /usr/local/mysql

shell> bin/mysql_install_db --user=mysql

shell> chown -R root  .

shell> chown -R mysql var

shell> chgrp -R mysql .

shell> bin/mysqld_safe --user=mysql &

------------------initilize the password ------------------
#set the password for root
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');

#creat user mysql and set its password '123456'
CREATE USER mysql@localhost IDENTIFIED BY '123456';
GRANT ALL ON db_name.* TO mysql@localhost


References: http://dev.mysql.com/doc/refman/5.1/zh/index.html

posted on 2010-12-29 00:20 XXXXXX 阅读(319) 评论(0)  编辑  收藏 所属分类: Linux&Unix


只有注册用户登录后才能发表评论。


网站导航: