linux下手动安装mysql

linux下手动安装mysql

先增加一个用户来跑mysql
# groupadd mysql
# useradd -g mysql mysql
# passwd mysql
# tar xzvf mysql-VERSION.tar.gz
# cd mysql-VERSION

配置
# ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --without-debug --with-extra-charsets=gbk --with-extra-charsets=all

编译
# make

安装
# make install
# scripts/mysql_install_db

# chown -R root  /usr/local/mysql;     
# chown -R mysql /usr/local/mysql/var;       
# chgrp -R mysql /usr/local/mysql
# cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf

# /usr/local/mysql/bin/mysqladmin -u root password 'Zzy01Test'

启动mysql
/usr/local/mysql/share/mysql/mysql.server start
/usr/local/mysql/share/mysql/mysql.server stop

/usr/local/mysql/bin/mysqld_safe &