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

1. Prepare the installation environment # wget-O / etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo# yum install cmake-y # yum install ncurses-devel-y # useradd-s / sbin/nologin-M mysql 2, The compilation environment prepares # mkdir / usr/local/mysql# mkdir / software# cd / software/# tar-zxvf mysql-5.5.32.tar.gz # to upload files: mysql-5.5.32.tar.gz to: / software directory # cd mysql-5.5.32# cmake. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DMYSQL_DATADIR=/usr/local/mysql/data\-DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DEXTRA_CHARSETS=gbk,gb2312,utf8 Ascii\-DENABLED_LOCAL_INFILE=ON\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_FEDERATED_STORAGE_ENGINE=1\-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1\-DWITHOUT_PARTITION_STORAGE_ENGINE=1\-DWITH_FAST_MUTEXES=1\-DWITH_ZLIB=bundled\-DENABLED_LOCAL_INFILE=1\-DWITH_READLINE=1\-DWITH_DEBUG=0# make & & make install 3, Initialize MySQL database # / usr/local/mysql/scripts/mysql_install_db-- basedir=/usr/local/mysql/\-- datadir=/usr/local/mysql/data\-- user=mysql # initialize database # cp / usr/local/mysql/support-files/mysql.server / etc/init.d/mysqld## modification file: / etc/my.cnf Because my MySQL is installed in the / usr/local/mysql directory # [mysqld] # datadir= / usr/local/mysql/data# socket=/usr/local/mysql/tmp/mysql.sock # sed-I's Universe datadir =\ / var\ / lib\ / mysql/datadir=\ / usr\ / local\ / mysql\ / data/g' / etc/my.cnf # sed-I's Compact socket=\ / var\ / lib\ / mysql\ / mysql.sock/socket=\ / usr\ / local\ / mysql\ / tmp\ / mysql.sock/g' / etc/my.cnf # chown-R mysql.mysql / usr/local/mysql# / etc/init.d/mysqld start # start the database service # / usr/local/mysql/bin/mysql# cp / usr/local/mysql/bin/mysql / usr/local/sbin/ # put mysql Copy the client program to the / usr/local/sbin/ directory # / usr/local/mysql/bin/mysqladmin-uroot password '123456' # change the root user password # mysql-uroot-p123456 > drop user "" @ Lab-Srv-02 > drop user "root" @ ":: 1"; > drop user "" @ "localhost"

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.