为了方便快捷的搭建linux环境，我有了这几篇文字。CentOS使用yum安装jdkCentOS安装tomcatCentOS安装NginxCentOS安装MySql5。/dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz2。解压mysql并修改名称#解压mysqltar-zxvfmysql-5.6.33-linux-glibc2.5-x86_64.tar.gz#修改mysql名称mvmysql-5.6.33-linux-glibc2.5-x86_64mysql3。添加用户和组#添加用户组groupaddmysql#添加用户mysql到用户组mysqluseradd-gmysqlmysql4.安装mysql#进入mysql目录cd/usr/local/mysql#给mysql组下的mysql用户分配目录权限chown-Rmysql:mysql./#安装mysql./scripts/mysql_install_db--user=mysql--datadir=/usr/local/mysql/data#installmysql语句错误执行yum-yinstallperlperl-devel#复制配置文件cpsupport-files/mysql.server/etc/init.d/mysqld#添加权限chmod755/etc/init.d/mysqld#复制启动脚本cpsupport-files/my-default.cnf/etc/my.cnf5.修改配置文件#打开配置目录vi/etc/init.d/mysqld#添加目录配置basedir=/usr/local/mysql/datadir=/usr/local/mysql/data6。启动，修改root密码，添加远程连接用户权限#修改环境变量配置文件vi/etc/profile#增加mysql全局变量，使服务mysqld可以在任何地方启动使用exportPATH=$PATH:/usr/local/mysql/bin#immediatelyeffectivesource/etc/profile#startmysqlservicemysqldstart#mysql刚安装不用密码进入mysql命令行mysql-uroot-p#querymysqluserselectUser,Host,PasswordFROMmysql.user;#修改root密码updatemysql.usersetpassword=password('root')whereUser="root";#为root添加远程权限grantallprivilegeson*.*to'root'@'%'identifiedby'root'withgrantoption;#Refreshprivilegesflushprivileges;7.修改mysql启动占用内存过多的问题。mysql5.6及以上默认内存占用为128m。my.cnf在mysql根目录添加如下配置修改默认占用为40mperformance_schema_max_table_instances=400table_definition_cache=400table_open_cache=256
