centos安装mysql5.5.10

安装mysql5.5.10
cd /tmp
tar zxvf mysql-5.5.10.tar.gz
cd mysql-5.5.10
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/3306 -DSYSCONFDIR=/etc/mysql/3306 -DMYSQL_UNIX_ADDR=/usr/local/mysql/3306/mysqld.sock -DMYSQL_TCP_PORT=3306 -DMYSQL_DATADIR=/usr/local/mysql/3306/data -DSYSCONFDIR=/etc/mysql/3306 -DWITH_DEBUG=0 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1
make && make install


ls -l


useradd -M -r --shell /sbin/nologin --home-dir /usr/local/mysql mysql


chown -R mysql:mysql /usr/local/mysql


/usr/local/mysql/3306/scripts/mysql_install_db --basedir=/usr/local/mysql/3306 --datadir=/usr/local/mysql/3306/data --user=mysql



cp /usr/local/mysql/3306/support-files/my-innodb-heavy-4G.cnf /etc/mysql/3306/my.cnf



#cp /usr/local/mysql/3306/support-files/my-innodb-heavy-4G.cnf /etc/mysql/3306/my.cnf



cp /usr/local/mysql/3306/support-files/mysql.server /etc/init.d/mysqld3306



vi /etc/init.d/mysqld3306 #修改路径basedir=/usr/local/mysql/3306 datadir=/usr/local/mysql/3306/data



chmod 755 /etc/init.d/mysqld3306



chkconfig --add mysqld3306



chkconfig --level 2345 mysqld3306 on


service mysqld3306 start


#启动不了，请修改mysql相关目录权限


#yum install mysql-devel 客户端安装


#mysql -S/usr/local/mysql/3306/mysqld.sock -uroot -p #连接服务端
#use mysql;

#GRANT ALL PRIVILEGES ON *.* TO dev@"%" IDENTIFIED BY 'dev' WITH GRANT OPTION;

#flush privileges;

#service mysqld3306 stop
#service mysqld3306 start