残酷の青春

journey continues

MySQL安装

shell> groupadd mysqlshell> useradd -g mysql mysqlshell> cd /usr/localshell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -shell> ln -s full-path-to-mysql-VERSION-OS mysqlshell> cd mysqlshell> scripts/mysql_install_db –user=mysqlshell> chown -R root  .shell> chown -R mysql datashell> chgrp -R mysql .shell> bin/mysqld_safe –user=mysql &
创建用户CREATE USER user [IDENTIFIED BY [PASSWORD] ‘password’]    [, user [IDENTIFIED BY [PASSWORD] ‘password’]] …
修改密码SET PASSWORD FOR ‘USER’@’HOST’=OLD_PASSWORD(’XXX’);