MYSQL installation and basic management in Linux

In Linux, MYSQL installation and basic management install some necessary linux packages: [plain] yum install gcc-c ++ gcc-g77 autoconf automake zlib * fiex * libxml * ncurses-devel libmcrypt * libtool-ltdl-devel * libevent install mysql, mysql installation package needs to be downloaded by yourself, installation directory/usr/local/web/[plain] sudo mkdir-p/usr/local/web/sudo tar xzvf mysql-5.1.39.tar.gz cd mysql-5.1.39 www.2cto.com. /configure -- prefix =/usr/local/web/mysql.5.1.39 -- enable-thread-safe-client -- enable-validator -- with-big-tables -- with-client-ldflags =-all -static -- with-mysqld-ldflags =-all-static -- with-charset = utf8 -- with-collation = utf8_general_ci -- with-extra-charsets = complex make install create a mysql user group, etc. information [plain] sudo groupadd mysql sudo useradd-g mysql-s/sbin/nologin mysql sudo. /scripts/mysql_install_db -- user = mysql -- datadir =/usr/local/web/mysql.5.1.39/var www.2cto.com sudo chown-R root/usr/local/web/mysql.5.1.39 sudo chown-R mysql: mysql/usr/local/web/mysql.5.1.39/var manage MYSQL [plain] # Start mysql: sudo/usr/local/web/mysql.5.1.39/share/mysql. server start # restart mysql sudo/usr/local/web/mysql.5.1.39/share/mysql. server restart # Stop mysql sudo/usr/local/web/mysql.5.1.39/share/mysql. server stop author initphp